problem with database, stops working

Turbo M

Verified User
Joined
Sep 9, 2004
Messages
11
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.
 

fusionictnl

Verified User
Joined
Jun 22, 2004
Messages
1,053
Location
Netherlands
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.
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.
 

Turbo M

Verified User
Joined
Sep 9, 2004
Messages
11
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.
 
Top