Why mySQL restart?

[dannygoh]

Hello,

What operation that cause of mySQL restart?

For eg. add table, add mysql users?

 

[Mik3yZ]

As far as i know none of those commands should cause mysql to reboot.

explain what happends please
- Mike

 

[dannygoh]

Mysql is restart frequent on my server?

Check on phpmyadmin, mysql uptime is not long compare to server uptime.

wondering what happen compare to it?

 

[Marshall]

Try doing this:

cat /var/log/mysqld.log

and read what errors it is putting out, if any. If the file does not exist then do this:

touch /var/log/mysqld.log
chown mysql:root /var/log/mysqld.log (substitute mysql for whichever user you have set to run mysql)

then next time your mysql restarts check the log to see if it is outputting any errors along with it. MySQL does not originally create this file and you must create it yourself but after it is created it will report errors here.