Help My Server

Hello all, this is my first post ,i'm a newbie in linux, my problem is that i have a dedicated server, after restarting the server i have this problem when i try to start mysql :

..failed or took more than 6s.

Please take a look at the syslog.

/usr/bin/mysqladmin: connect to server at 'localhost' failed

error: 'Can't connect to local MySQL server through socket '/var/run/mysqld/mysqld.sock' (2)'

Check that mysqld is running and that the socket: '/var/run/mysqld/mysqld.sock' exists!


Can't make it work, is good to know that i have 2 IPs for my server

The syslog sais, something like this :

Also in etc/mysql/my.cnf i have this :

If i change the user to root :

user = root , the mysql server starts but second IP still doesn't work properly and the domain isn't working too

Can anyone teach me what to do ? hope to understand , thanks very very much

 

anyone ? even 1 opinion ?

 

Which distribution are you using?

Please switch back to user = mysql in your my.cnf.

What are the outputs of

Code:

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

and

Code:

netstat -tap

?

 

CentOs 5 outside but the chroot where i am now is Debian Sarge :


first question :

second :

 

i see this now in syslog, many many times :

Maybe this will be interesting, the DNS Server is Power DNS , when i type :

receive :

 

What's the output of

Code:

ls -la /var/run?

 

this is the output:

 

Can you uncomment these two lines in my.cnf and restart MySQL?

Code:

pid-file = /var/run/mysqld/mysqld.pid
socket = /var/run/mysqld/mysqld.sock

 

i paid someone and solved the problem for me , thanks anyway , good tutorials here