how to fixed : Access denied for user 'da_admin'@'localhost'

[AhrimanSefid]

Hi All.
me very try to fixed error but not fix
plz help me.
thank you all

Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: YES)
Repair guide: http://help.directadmin.com/item.php?id=45

Giving mysqld a few seconds to start up...
Version check failed. Got the following error when calling the 'mysql' command line client
ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)
FATAL ERROR: Upgrade failed
/usr/bin/mysqlcheck: Got error: 1045: Access denied for user 'da_admin'@'localhost' (using password: YES) when trying to connect
cp: '/usr/lib/libmysqlclient.so' and '/usr/lib/mysql/libmysqlclient.so' are the same file

 

[zEitEr]

Hello,


I guess you already tried to follow the guide https://help.directadmin.com/item.php?id=45 ?

What mysql error log show at the bottom (10-30 lines) ?

 

[AhrimanSefid]

very try to fixed but not work.
yes see http://help.directadmin.com/item.php?id=45 not working.
centos 7 x64.

 

[zEitEr]

So, is MySQL running at all? Or it crashed?

If MySQL server is running and the question is only how to recover da_admin's password then you could try and use root's password and connect to MySQL. You can find it in /usr/local/directadmin/scripts/setup.txt

If MySQL crashed then we'd like to see log 10-30 lines from the bottom of mysql error.