problem with database, stops working

I think it is a very similar problem like this one.
http://www.directadmin.com/forum/showthread.php?s=&threadid=2676

except it's related to the database because the forum and anything related with the database like the photo gallery and classifieds section will stop working.

The way I fix it is that I have to reboot the server and type this.

kill `cat /home/mysql/35111.pid`
mysqld_safe --skip-grant-tables &

So I suppose the problem is with some kind of permission that gets reset with the tally? How can it be fixed so the database stops going down.

Thank you.

Turbo M said:

I think it is a very similar problem like this one.
http://www.directadmin.com/forum/showthread.php?s=&threadid=2676

except it's related to the database because the forum and anything related with the database like the photo gallery and classifieds section will stop working.

The way I fix it is that I have to reboot the server and type this.

kill `cat /home/mysql/35111.pid`
mysqld_safe --skip-grant-tables &

So I suppose the problem is with some kind of permission that gets reset with the tally? How can it be fixed so the database stops going down.

Thank you.

Click to expand...

mysqld_safe --skip-grant-tables

This will cause mysql to ignore all Rights for the database. It will open up you're Mysql for everyone!

You probaly messed some permissions on the tables, so I would recommend you to reset all permissions correctly using phpmyadmin as root (da_admin).

As of now, anyone can access the "users" table in you're mysql.

I can't even log into phpmyadmin. It just happened again.

it's like it moves somewhere because even if i try to run this command kill `cat /home/mysql/35111.pid`
it won't even work. It will say invalid directory. I have to reboot and then run that command again to work.