Forum: 

Web Admin Error: MySQL is not running on your system - database list could not be retrieved.

will craig's picture

 

Hi all can you help me out, i reset my micro server and now i cant access my db anymore, the proccess is no longer running, i have tried to start it but it still offline, the the web admin it says bellow

 

MySQL is not running on your system - database list could not be retrieved. 

Click this button to start the MySQL database server on your system with the command /etc/init.d/mysql start >/dev/null 2>&1 &. This Webmin module cannot administer the database until it is started.

but nothing happends 

Jeremy Davis's picture

Either use Webshell (accessed via port 12320) or SSH (if in Windows using a client like PuTTY - my preference). Then try typing:

service mysql start

And see what happens. It probably won't work but it may throw an error that will give you a clue (try googling it). If it doesn't actually give you anything useful check the MySQL logs. They should be found here:

/var/log/mysql.log
/var/log/mysql.err

Assuming you are using Windows, my preference is to read them with Notepad++ via Filezilla (makes doing google searches easier). Otherwise you can read them from the commandline using cat (displays the whole file) or tail (displays just the last bit) or less (lets you go through it page by page or line by line) eg cat /var/log/mysql.err

Jeremy Davis's picture

In my travels on the forums I came across a thread from a while ago which talked about corrupted log files causing problems. Perhaps if you didn't shut down your server cleanly something like that has happened. I wouldn't just delete logs randomly hoping it will work, but this post may be of help if it seems that there is corruption of you INODB logs.

Aman's picture

Try to do it : 

nano /etc/mysql/my.cnf

check your port number : it should be 3306 

it may be described two times in this same file . you need to edit on both places.

thanks 

Post new comment