TurnKey Linux Virtual Appliance Library

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

 

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's picture

Try from the commandline

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's picture

One more thought...

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.

Web Admin Error:Solution

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

The content of this field is kept private and will not be shown publicly. If you have a Gravatar account, used to display your avatar.
  • Web page addresses and e-mail addresses turn into links automatically.
  • Allowed HTML tags: <a> <p> <span> <div> <h1> <h2> <h3> <h4> <h5> <h6> <img> <map> <area> <hr> <br> <br /> <ul> <ol> <li> <dl> <dt> <dd> <table> <tr> <td> <em> <b> <u> <i> <strong> <font> <del> <ins> <sub> <sup> <quote> <blockquote> <pre> <address> <code> <cite> <strike> <caption>

More information about formatting options

Leave this field empty. It's part of a security mechanism.
(Dear spammers: moderators are notified of all new posts. Spam is deleted immediately)