Ubuntu – How to start thesql server in ubuntu 12.04

MySQLnetworkingUbuntu

I have problems after updating ubuntu from 11.10 to 12.04 with mysql – before upgrade everything worked fine after upgrade – mysql cannot start mysql server properly. Any ideas? This is my error message:

SQL Error: Can't connect to MySQL server on '127.0.0.1' (111)

Also where can I enable errors from mysql? I did not find it anywhere. Thank you all.

When I do:

ps -ef |grep mysql

It shows me this:

root      6849  5758  0 00:44 pts/4    00:00:00 grep --color=auto mysql

Best Answer

It simply looks like your server isn't running and you are trying to connect to the server before starting it first. It might be that your init scripts are somehow messed up. What command are you using to start the server manually, if you have tried this at all?

  1. Try service mysql start from a root terminal
  2. The error log is at /var/log/mysql/error.log. cat it and see if you find anything useful.