Got a problem, mySQL won't start. It gives me an error saying
" Can't open user.MYD "
I shutdown the server with mysqladmin -u root -p shutdown.
mysql started
/usr/local/libexec/mysqld: Can't open file: 'user.MYD''. (errno: 145)
mysql ended
this ocurs when using the sysV init script.
if I simply use
#/usr/local/bin/safe_mysqld --user=mysql &
(which is what the init script is doing)
I get the same problem
mysql version is 3.23.38
How to fix this will muchly depend on what platform you're running - on Mandrake 7.2 the file /etc/rc.d/init.d/mysql contains various variables you can set, including the location of the data directory.
On my machine, it's at /var/lib/mysql
If you have the locate command available, try doing a 'locate user.MYD' to find out if the file is actually on your machine, and then at least you'll know where to start looking ;)
I followed your advice, then I also got to doing some other research of my own and well when I shut the server down I think something messed up on the grant tables so what I did is restart the server without the grant tables. Using this command
% safe_mysqld --skip-grant-tables
Then I flushed privileges with this command
% mysqladmin flush-privileges
Well, thanks for the help I would not have known where to start without it. :)
