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
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 Paha
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 performe
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.
Inn
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 Maili
