MySQL error when changing Admin password through AD Admin GUI

[joelserrano]

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:

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,

 

[zbahadir]

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

 

[joelserrano]

Worked perfectly...

Thank you very much!

Best regards,