da_admin password reset isn't working

[Maartenz]

In the control panel I get the error "MySQL: Access denied for user 'da_admin'@'localhost' (using password: YES)", so I tried to fix it by following this guide: http://help.directadmin.com/item.php?id=45

Unfortunately, it didn't work. I made sure there is no .my.cnf in /root, the password in /usr/local/directadmin/conf/my.cnf is the password I used in the guide. I keep getting the error.

 

[smtalk]

You should edit /usr/local/directadmin/conf/mysql.conf, and not /usr/local/directadmin/conf/my.cnf

 

[Maartenz]

mysql.conf contains the same password. I can't login with PhpMyAdmin or command line (mysql -uda_admin -p) either.

 

[Richard G]

Try login it as root with that password.
mysql -uroot -p
and then your da_admin password.

I'm under the impression that you might have changed the mysql root password instead of the da_admin password.

 

[Maartenz]

I can't login with the password on root.

I tried to change the password again and I noticed that It says "0 rows affected"
mysql> GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY '<password>' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

 

[Maartenz]

Any help please? I'm not able to do anything now

 

[zEitEr]

If this guide does not work for you http://help.directadmin.com/item.php?id=45 nobody could guess what wrong you do. So you need someone to do it for it. Someone here (including me) offers a commerce service of solving issues with Linux servers, so feel free to PM those of us who you trust the most for a quote.