[SOLVED] Upgrade MariaDB and ERROR 1045 (28000): Access denied for user da_admin

drego85

New member
Joined
Aug 8, 2019
Messages
2
Hello,
I want to share with you how I solved a problem while updating MariaDB.

Using the guide (https://help.directadmin.com/item.php?id=240) when I want to build the new version, this error appeared to me serveral times:

ERROR 1045 (28000): Access denied for user 'da_admin'@'localhost' (using password: YES)

To resolve, simply delete the file my.cnf in the root folder:

Code:
# rm /root/.my.cnf

This file contains authentication information that has priority over what is indicated in the build script.

Also check that these files contain the correct credentials of the mysql user "da_admin":

/usr/local/directadmin/conf/mysql.conf
/usr/local/directadmin/conf/my.cnf

Just delete a file and everything is resolved, unfortunately I didn't find this indication anywhere. And I lost 3h of time ;)

Andrea
 
/root/.my.cnf does not come with DA by default. I'm happy to hear you've found the solution! :)
 
Back
Top