Error connecting to MySQL

sarwhost

sarwhost

Verified User
Joined
May 6, 2013
Messages
35
hi
Please help :((
i m new install direct admin
I receive the following error in production databases

Error connecting to MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Error connecting to MySQL: Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
Click to expand...
 
Which Linux distro?
Also check your logs. If you have Centos 6.x try the following as root user:
Code: 
/etc/rc.d/init.d/portreserve stop
chkconfig portreserve off
/etc/rc.d/init.d/mysqld restart

Hope this will work for you.
 
Richard G said:
Which Linux distro?
Also check your logs. If you have Centos 6.x try the following as root user:
Code: 
/etc/rc.d/init.d/portreserve stop
chkconfig portreserve off
/etc/rc.d/init.d/mysqld restart

Hope this will work for you.
Click to expand...

ni im Used to linux centus 5.9
 
tokyosama said:
I have the same issue I follow this instructions that zEitEr posted

Here my results:View attachment 1556
Click to expand...

First of all you should change user to root, or use sudo before you try to start/restart MySQL server. Then a lot of typos on the screenshot I see. It should be

Code: 
cat /var/lib/mysql/`hostname`.err

but not /ver/lib/mysql/'hostname'.err
 
zEitEr said:
First of all you should change user to root, or use sudo before you try to start/restart MySQL server. Then a lot of typos on the screenshot I see. It should be

Code: 
cat /var/lib/mysql/`hostname`.err

but not /ver/lib/mysql/'hostname'.err
Click to expand...

I enter in /var/lib/mysql/`hostname`.err
command.png
 
zEitEr said:
type the following on Debian/ubuntu

Code: 
apt-get install libaio1 libaio-dev

On Redhat/Fedora/CentOS:

Code: 
yum install libaio


related: http://help.directadmin.com/item.php?id=368
Click to expand...

I enter in the commend it fully installed but i still get an email from my server

A new message or response with subject:

The service 'mysqld' on server server.streamanime.tv is currently down

has arrived for you to view.
Follow this link to view it:

http://server.streamanime.tv:2222/CMD_TICKET?action=view&number=000000032&type=ticket


======================================================
Automatically generated email produced by DirectAdmin 1.43.0

Do Not Reply.
 
I could check it and fix it in terms of a commerce service if you'd like it. Please send me a PM if you're interested.
 
You must log in or register to reply here.
Back
Top