Hi, Like a number of other people on the list, I've been having considerable difficulty getting MySQL (i've tried both 3.23.51 and 3.23.52) to work on RH8.0
Initially, I ran ./configure with --localstatedir=/server/local/mysql (among a number of other directives - note that I install the software in a completely different location to the datadir). This compiled and installed fine, until I went to run scripts/mysql_install_db. This generated pages and pages of suggestions, telling me where I should try to look (such as the log files in /server/local/mysql/). No such log files existed. So I ran mysqld --help, and lo-and-behold, the server was compiled with datadir (also called localstatedir in ./configure) == /ser/ . After much retrying and digging, I decided to try safe_mysqld --datadir=/server/local/mysql/. It started, but couldn't read the grant tables (since mysql_install_db was still failing). To cut a [very] long story short, I finally got some grant tables happening (by copying them from a backup i'd made, since mysql - the client - was causing errors and failing all over the place). When I try to load an SQL script from the command line, I get: ERROR 2013 at line 50: Lost connection to MySQL server during query The error's i'm getting in my log file are: Number of processes running now: 1 mysqld process hanging, pid 24946 - killed 021008 10:37:42 mysqld restarted It does this every time I try to run a query. I also can't ^C the daemon - I have to kill -9 it. I'm not even sure where to go here. Please don't tell me I have to install the binary packages. I install from source for a number of really good reasons (the major two are that I use "stow" to keep my installed apps managed, and that I like to have control over where my data is stored). Hope someone has suggestions for a solution. -- Regards, Dan Goodes --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
