DA 1.678: Access denied for user 'da_admin'@'127.0.0.1'

[jeefymirhdflc]

Hello,

After update Da to 1.678 we encouraged problem with connecting to sql at panel.


2025/06/18 23:47:00 error open mysql error=Error 1045 (28000): Access denied for user 'da_admin'@'127.0.0.1' (using password: YES) req-uri=/CMD_DB?domain=


mysql -uda_admin -p -h 127.0.0.1
Enter password:
ERROR 1045 (28000): Access denied for user 'da_admin'@'127.0.0.1' (using password: YES)

mysql -uda_admin -p -h localhost
Enter password:
Welcome to the MariaDB monitor. Commands end with ; or \g.
Your MariaDB connection id is 15320

Is something changed in update?

 

[zEitEr]

Hello,

Make sure you've got host=localhost in the file /usr/local/directadmin/conf/mysql.conf and/or missing in /usr/local/directadmin/conf/my.cnf:

# grep host= /usr/local/directadmin/conf/mysql.conf /usr/local/directadmin/conf/my.cnf
/usr/local/directadmin/conf/mysql.conf:host=localhost

 

[jeefymirhdflc]

I added line to files ,but after restart DA problem is still

~ # grep host= /usr/local/directadmin/conf/mysql.conf /usr/local/directadmin/conf/my.cnf
/usr/local/directadmin/conf/mysql.conf:host=localhost
/usr/local/directadmin/conf/my.cnf:host=localhost

 

[Richard G]

Can you check your /etc/hosts file that the localhost looks correct, should be like this:
127.0.0.1 localhost.localdomain localhost

 

[jeefymirhdflc]

127.0.0.1 localhost localhost.localdomain localhost4 localhost4.localdomain4

i added socket var to files , now panel connecting to database. But why this happend after upgrade?


cat /usr/local/directadmin/conf/my.cnf /usr/local/directadmin/conf/mysql.conf |grep socket
socket=/var/lib/mysql/mysql.sock
socket=/var/lib/mysql/mysql.sock

 

[zEitEr]

i added socket var to files , now panel connecting to database. But why this happend after upgrade?

Probably related to https://docs.directadmin.com/change...cture-better-integration-with-system-packages

Run and see:

mysql_config

MariaDB/MySQL installed from sources on AlmaLinux 9 for example uses:

--socket         [/tmp/mysql.sock]

by default.