I have am having problems getting the MySQL server to start running, please help me, here are my problems, I have also displayed my error logs below, at least I hope they are the error logs;
I have been trying to install the mysql-3.23.52-pc-linux-gnu-i686.tar.gz Everything seems to be going smoothly until I entered the command ./scripts/mysql_install_db I got this output which i believe is ok; cords-orj86jfje:/usr/local/mysql/mysql # ./scripts/mysql_install_db Preparing db table Preparing host table Preparing user table Preparing func table Preparing tables_priv table Preparing columns_priv table Installing all prepared tables 021007 18:15:39 ./bin/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: ./bin/mysqladmin -u root password 'new-password' ./bin/mysqladmin -u root -h cords-orj86jfje password 'new-password' See the manual for more instructions. You can start the MySQL daemon with: cd . ; ./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 ./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 Then I try to enter this command to configure my passwords; Firstly cords-orj86jfje:/usr/local/mysql/mysql # ./bin/safe_mysqld --user=mysql & [1] 1346 cords-orj86jfje:/usr/local/mysql/mysql # Starting mysqld daemon with databases from /usr/local/mysql/mysql/data 021007 19:15:21 mysqld ended [1]+ Done ./bin/safe_mysqld --user=mysql THEN, cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root password sqlpass ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' OR cords-orj86jfje:/usr/local/mysql/mysql # ./bin/mysqladmin -u root sqlpass ./bin/mysqladmin: connect to server at 'localhost' failed error: 'Can't connect to local MySQL server through socket '/tmp/mysql.sock' (111)' Check that mysqld is running and that the socket: '/tmp/mysql.sock' exists! Now I was told my a few intelligent guys that I must check the mysql error logs and that they should tell me what is going wrong so I went looking for these mysterious error logs; mike@cords-orj86jfje:/var/lib/mysql> locate *.err /var/lib/mysql/cords-orj86jfje.err mike@cords-orj86jfje:/var/lib/mysql> ls cords-orj86jfje.err mysql test mike@cords-orj86jfje:/var/lib/mysql> pico cords-orj86jfje.err 21002 10:09:23 mysqld started /usr/sbin/mysqld: ready for connections A mysqld process already exists at Wed Oct 2 10:11:58 EDT 2002 A mysqld process already exists at Wed Oct 2 10:13:36 EDT 2002 021002 10:21:37 /usr/sbin/mysqld: Normal shutdown 021002 10:21:37 /usr/sbin/mysqld: Shutdown Complete 021002 10:21:37 mysqld ended ALSO; cords-orj86jfje:/usr/local/mysql/mysql/data # ls . .. cords-orj86jfje.err cords-orj86jfje.err.save mysql test cords-orj86jfje:/usr/local/mysql/mysql/data # pico cords-orj86jfje.err 021007 17:41:08 mysqld started 021007 17:41:08 /usr/local/mysql/mysql/bin/mysqld: Table 'mysql.host' doesn't exist 021007 17:41:08 mysqld ended 021007 18:03:06 mysqld started 021007 18:03:07 /usr/local/mysql/mysql/bin/mysqld: Table 'mysql.host' doesn't exist 021007 18:03:07 mysqld ended 021007 18:05:01 mysqld started 021007 18:05:01 /usr/local/mysql/mysql/bin/mysqld: Table 'mysql.host' doesn't exist 021007 18:05:02 mysqld ended 021007 19:01:35 mysqld started 021007 19:01:35 /usr/local/mysql/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021007 19:01:35 mysqld ended 021007 19:03:17 mysqld started 021007 19:03:17 /usr/local/mysql/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021007 19:03:17 mysqld ended 021007 19:09:55 mysqld started 021007 19:09:55 /usr/local/mysql/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021007 19:09:55 mysqld ended 021007 19:15:21 mysqld started 021007 19:15:21 /usr/local/mysql/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021007 19:15:21 mysqld ended 021008 13:41:20 mysqld started 021008 13:41:21 /usr/local/mysql/mysql/bin/mysqld: Can't find file: './mysql/host.frm' (errno: 13) 021008 13:41:21 mysqld ended Where is this file host.frm ??????? cords-orj86jfje:/usr/local/mysql/mysql/data # locate *.frm cords-orj86jfje:/usr/local/mysql/mysql/data # locate host* cords-orj86jfje:/usr/local/mysql/mysql/data # /******************MILLION DOLLAR QUESTION*********************/ I believe I have viewed my err logs but I still don't know what I have to do to get MySQL server to start working? What must I do to get the MySQL server to start working????? Thanks, DeNewbie --------------------------------------------------------------------- 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
