michaelzhou23
asked on
Problem when starting MySQL shipped with Fedora 7
Hi experts,
When I tried to start the MySQL that was shipped with Fedora 7, I got the "[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist".
I am not sure what to do about this. Could you please tell me what I should do to start this?
Thanks!
Michael
When I tried to start the MySQL that was shipped with Fedora 7, I got the "[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist".
I am not sure what to do about this. Could you please tell me what I should do to start this?
Thanks!
Michael
http://forums.mysql.com/read.php?11,51024,147280#msg-147280
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks for the reply.
I went through the forum link ownesleftfoot provided. However, the datadir in my.cnf is /var/lib/mysql, which is the default one.
I cannot find the my.ini file using the whereis command. Also could you be more specific as what parameters to set?
I am a total newbie to Linux so i guess there needs some time for me to wrap up some basic stuff.
Thanks!
I went through the forum link ownesleftfoot provided. However, the datadir in my.cnf is /var/lib/mysql, which is the default one.
I cannot find the my.ini file using the whereis command. Also could you be more specific as what parameters to set?
I am a total newbie to Linux so i guess there needs some time for me to wrap up some basic stuff.
Thanks!