Re: Cannot start mysqld
check if rpm creates mysql user and group. then mysql_install_db, chown mysql:mysql /var/lib/mysql -R and finally try starting mysqld again t 050810 20:26:52 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.host' doesn't exist 050810 20:26:52 mysqld ended -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start mysqld
Thanks for your reply. I confirmed that user and group, mysql, exists and performed the chown as instructed but same thing. Here is my log again after I did this: 050810 23:18:09 mysqld started 050810 23:18:09 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 050810 23:18:09 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 050810 23:18:09 InnoDB: Flushing modified pages from the buffer pool... 050810 23:18:09 InnoDB: Started; log sequence number 0 43634 050810 23:18:09 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.h ost' doesn't exist 050810 23:18:09 mysqld ended Michael. Pinter Tibor (tibyke) wrote: check if rpm creates mysql user and group. then mysql_install_db, chown mysql:mysql /var/lib/mysql -R and finally try starting mysqld again t -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start mysqld
Hello. Check that mysql_install_db filled mysql database in the same directory as your datadir. See: http://dev.mysql.com/doc/mysql/en/unix-post-installation.html Gobi [EMAIL PROTECTED] wrote: Thanks for your reply. I confirmed that user and group, mysql, exists and performed the chown as instructed but same thing. Here is my log again after I did this: 050810 23:18:09 mysqld started 050810 23:18:09 InnoDB: Database was not shut down normally! InnoDB: Starting crash recovery. InnoDB: Reading tablespace information from the .ibd files... InnoDB: Restoring possible half-written data pages from the doublewrite InnoDB: buffer... 050810 23:18:09 InnoDB: Starting log scan based on checkpoint at InnoDB: log sequence number 0 43634. InnoDB: Doing recovery: scanned up to log sequence number 0 43634 050810 23:18:09 InnoDB: Flushing modified pages from the buffer pool... 050810 23:18:09 InnoDB: Started; log sequence number 0 43634 050810 23:18:09 [ERROR] Fatal error: Can't open privilege tables: Table 'mysql.h ost' doesn't exist 050810 23:18:09 mysqld ended Michael. Pinter Tibor (tibyke) wrote: check if rpm creates mysql user and group. then mysql_install_db, chown mysql:mysql /var/lib/mysql -R and finally try starting mysqld again t -- For technical support contracts, goto https://order.mysql.com/?ref=ensita This email is sponsored by Ensita.NET http://www.ensita.net/ __ ___ ___ __ / |/ /_ __/ __/ __ \/ /Gleb Paharenko / /|_/ / // /\ \/ /_/ / /__ [EMAIL PROTECTED] /_/ /_/\_, /___/\___\_\___/ MySQL AB / Ensita.NET ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start mysqld
I find that I can start mysqld by using the --skip-grant-tables option but as soon as I run mysqld without that option, it dies again. I did try running mysql_install_db --user=mysql but when I did mysqlshow mysql, it was empty. Any ideas on how to proceed? Thanks, Michael. Gleb Paharenko wrote: Hello. Check that mysql_install_db filled mysql database in the same directory as your datadir. See: http://dev.mysql.com/doc/mysql/en/unix-post-installation.html -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Cannot start mysqld
Never mind. I figured it out. I had to run the install_db script as mysql user. Gobi wrote: I find that I can start mysqld by using the --skip-grant-tables option but as soon as I run mysqld without that option, it dies again. I did try running mysql_install_db --user=mysql but when I did mysqlshow mysql, it was empty. Any ideas on how to proceed? Thanks, Michael. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]