Hi, If this is a FAQ, I haven't been able to find it. I am a newbie to MySQL, but I've followed the directions carefully and I get this whenever I start mysqld:
# bin/safe_mysqld --user=mysql & [1] 24487 zaphod:/usr/local/mysql[15:02]# Starting mysqld daemon with databases from /var/lib/mysql 021113 15:02:18 mysqld ended [1] + 24487 done bin/safe_mysqld --user=mysql There is nothing in the log that suggest why the daemon ends immediately. Any further attempts to connect to mysql result in errors: # mysql/bin/mysqld version Fatal error: Please read "Security" section of the manual to find out how to run mysqld as root! 021113 15:07:13 Aborting 021113 15:07:13 mysql/bin/mysqld: Shutdown Complete There doesn't appear to be any reason for this listed in the "Security" section of the manual. # ./bin/mysqladmin -u root -h zaphod.randori.com password 'new-password' ./bin/mysqladmin: connect to server at 'zaphod.randori.com' failed error: 'Can't connect to MySQL server on 'zaphod.randori.com' (111)' Check that mysqld is running on zaphod.randori.com and that the port is 3306. You can check this by doing 'telnet zaphod.randori.com 3306' # telnet zaphod.randori.com 3306 Trying 209.155.82.57... telnet: connect to address 209.155.82.57: Connection refused Also, why is this file "lost"? It appears that you *have* to be in /usr/local (or whereever your "root" is) to run "mysqld". # bin/!! bin/mysqld version 021113 15:04:41 Can't find messagefile 'src/mysql-max-4.0.3-beta-pc-linux-gnu-i686/share/mysql/english/errmsg.sys' 021113 15:04:41 Aborting Any help would be greatly appreciated. -Kevin L. Gross Randori News Inc. --------------------------------------------------------------------- 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
