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?
service mysql start
from a root terminal/var/log/mysql/error.log
. cat it and see if you find anything useful.