Hi all, I have recently downloaded mysql version 3.23.45 and I am struggling to get it to start.
Every time I type in ./safe_mysqld the program starts and then shuts down immediately with the following being written to the error log: --------------------------------------------------------------------------- mysqld started /usr/local/mysql/libexec/mysqld: Can't find file: './mysql/host.frm' (errno:13) /usr/local/mysql/libexec/mysqld: Normal Shutdown --------------------------------------------------------------------------- Initially there wasn't any 'host.frm' in the mysql home directory but I found one in the mysql/var/mysql directory. I've tried creating a link from the mysql home directory to the host.frm in the mysql/var/mysql directory but this makes no difference. I've tried changing permissions on both the host.frm file and the link so that they were read/write/execute for everybody but this makes no difference. I am running the 'safe_mysqld' command as root. I have run the ./mysql_install_db command which I think has run sucessfully. I received the following message when I ran this command. ------------------------------------------------------------------------------------------- sh-2.03# ./mysql_install_db Installing all prepared tables 020920 11:50:57 /usr/local/mysql/libexec/mysqld: Shutdown Complete To start mysqld at boot time you have to copy support-files/mysql.server to the right place for your system PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER ! This is done with: /usr/local/mysql/bin/mysqladmin -u root -p password 'new-password' /usr/local/mysql/bin/mysqladmin -u root -h imrahil -p password 'new-password' See the manual for more instructions. NOTE: If you are upgrading from a MySQL <= 3.22.10 you should run the /usr/local/mysql/bin/mysql_fix_privilege_tables. Otherwise you will not be able to use the new GRANT command! You can start the MySQL daemon with: cd /usr/local/mysql ; /usr/local/mysql/bin/safe_mysqld & You can test the MySQL daemon with the benchmarks in the 'sql-bench' directory: cd sql-bench ; run-all-tests Please report any problems with the /usr/local/mysql/bin/mysqlbug script! The latest information about MySQL is available on the web at http://www.mysql.com Support MySQL by buying support/licenses at https://order.mysql.com ------------------------------------------------------------------------------- Does anyone out there have any ideas as to what I might be doing wrong? Regards Mindy --------------------------------------------------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. /\\\/\\\/\\\ / / Merrindal (Mindy) Routley / \\\ \\\ \\\ / / Network Design Engineer / /\\\/\\\/\\\/ / 87 Peters Ave, Mulgrave / / \\\ \\\ \\\ / PO Box 4112, Mulgrave, Vic, 3170, AUSTRALIA / / \\\/\\\ \\\/ Ph:+61 3 85614263 Fax:+61 3 95609055 Tele-IP Ltd WWW: http://www.tele-ip.com.au --------------------------------------------------------------------------------- --------------------------------------------------------------------------------- This email and any files transmitted with it are confidential and intended solely for the use of the individual or entity to whom they are addressed. If you have received this email in error please notify the system manager. /\\\/\\\/\\\ / / Merrindal (Mindy) Routley / \\\ \\\ \\\ / / Network Design Engineer / /\\\/\\\/\\\/ / 87 Peters Ave, Mulgrave / / \\\ \\\ \\\ / PO Box 4112, Mulgrave, Vic, 3170, AUSTRALIA / / \\\/\\\ \\\/ Ph:+61 3 85614263 Fax:+61 3 95609055 Tele-IP Ltd WWW: http://www.tele-ip.com.au --------------------------------------------------------------------------------- --------------------------------------------------------------------- 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
