MySQL error when changing Admin password through AD Admin GUI

joelserrano

Verified User
Joined
Aug 29, 2013
Messages
7
Hi everybody,

I'm trying to change another Admin's password through the DA Admin GUI:

Admin Level / Server Management / Change Passwords:

When I type the user and the new password twice I get the following error:

Code:
Error changing password

Click here to return to the main page

Details

Error connecting to MySQL: Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)
Unable to connect to the database

I've checked and MySQL is running, and other operations work perfectly.


Any ideas what I'm doing wrong? How can I specify the socket to /var/run/mysqld/mysqld.sock or use TCP port 3306?


Thank you in advanced.

Best regards,
 
Determine the location of the MySQL socket.
ps ax | grep mysqld

If you have a line like this = /var/run/mysqld/mysqld.sock?

Add the following line to the file mysql.conf

way:
/usr/local/directadmin/mysql.conf

socket=/var/run/mysqld/mysqld.sock

example mysql.conf
user=da_admin
passwd=xxxx
socket=/var/run/mysqld/mysqld.sock

http://www.directadmin.com/features.php?id=140
 
Last edited:
Back
Top