MySQL not working

[TheLG]

Hello, I am now on this forum and I need help with my MySQL Server which is on my VPS with Ubuntu 12.10 Server.

Everything was fine 'till today, when I tried to login to PhpMyAdmin (as root) and I got theese two errors:

#2002 Cannot log in to the MySQL server
Connection for controluser as defined in your configuration failed

So I googled for the solution, found something and commented theese lines in phpmyadmin config:

$cfg['Servers']['$i']['controluser'] and $cfg['Servers']['$']['controlpass']

Now the error I was getting changed to

#2003 Cannot log in to the MySQL server

So I tried to access mysql from my VNC Client, I logged in as root and typed

$ mysql

and I got this error:

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

I checked and I couldn't find that file!
I tried creating it with touch, but didn't work..

Then I tried to start/restart mysql service but when I type service mysql stop/start/restart I get:

Job failed to start!

I also tried reinstalling mysql, php and apache2 and nothing worked!!
Please help me, my MC servers can't work without MySQL!

P.S.
Today I changed ServerName in apache config because I was getting an error when I typed service apache restart:

Could not reliably determine the server’s fully qualified domain name, using 127.0.1.1 for ServerName

I'm not sure does that have anything to do with my MySQL problem.

And there is one little thing I did in sudoers (by typing visudo):
I wanted to execute commands from php as root so I added this line at the end of the file:

www-data ALL=NOPASSWD: ALL

Unfortunately, it didn't work so I removed that line..

Please help A.S.A.P.!

Thank you very much,
Leon Grdic

[d4m1r]

Is it a paid VPS? In that case, you should have the option to basically nuke it and start over if even a reinstall hasn't helped...SolusVM control panel comes to mind.

[jonobr]

Hello



try and find the sock file using

sudo find / -name *.sock

check your my.cnf file and ensure that matches whats in there

my.cnf should be in /etc/mysql

e.g

# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

[TheLG]

Is it a paid VPS? In that case, you should have the option to basically nuke it and start over if even a reinstall hasn't helped...SolusVM control panel comes to mind.

Yes, it's paid host, but if I reinstall I would loose all databases!

[Wim Sturkenboom]

Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)

indicates that the server is not started. So you will not be able to connect anyway. Check the mysql error logs to find pointers as to why the service does not start.

[TheLG]

Hello



try and find the sock file using

sudo find / -name *.sock

check your my.cnf file and ensure that matches whats in there

my.cnf should be in /etc/mysql

e.g

# Remember to edit /etc/mysql/debian.cnf when changing the socket location.
[client]
port = 3306
socket = /var/run/mysqld/mysqld.sock

Thank you very much for your reply!
After typing sudo find / -name *.sock i got only /run/proftpd.sock!
Nothing else was found..

[TheLG]

indicates that the server is not started. So you will not be able to connect anyway. Check the mysql error logs to find pointers as to why the service does not start.

But where can I find logs?
And I think that there is no reason for checking logs because mysql socket is missing!

[Wim Sturkenboom]

No, the socket file is created by the mysql daemon when the mysql deamon is started. If it fails to start (or when you stop the service), the socket file is removed again.

The log can be found in the directory /var/log/mysql (if you have a standard setup)

[TheLG]

No, the socket file is created by the mysql daemon when the mysql deamon is started. If it fails to start (or when you stop the service), the socket file is removed again.

The log can be found in the directory /var/log/mysql (if you have a standard setup)

Thank you for your reply, I opened error.log located in that folder but it's empty.. There are also some files named error.log.1.gz but when I open it with nano it's empty...
Also, mysql on my server does not create a socket..

Thank you..

[btindie]

Type the following to see if it's actually running

ps -p $(pgrep -x mysqld) -f

You can check the status of the daemon with

sudo service mysql status

If it's appears to not be running then try starting it manually with

sudo service mysql start

it should provide output indicating if it started OK or not.

You can run the first two commands again to confirm it's running and also

ls -l /var/run/mysqld/mysqld.sock

to check that it's created the UNIX domain socket.