MySQL errors in DirectAdmin

wdeboer · Apr 3, 2007

Since we updated our webserver to Debian 3.1 I encountered the following error in the panel of customers in user level:

Code:

Error connecting to MySQL: Access denied for user 'da_admin'@'localhost' (using password: YES)

How can I fix this problem? The error also occurs when trying to install RoundCube.

jackc · Apr 3, 2007

you might want to reset mysql password for da_admin
http://help.directadmin.com/item.php?id=45

wdeboer · Apr 3, 2007

I tried that. I tried to change the password to the one as specified in the mysql.conf file. Only when I do that I am getting:

mysql> GRANT ALL PRIVILEGES ON *.* TO da_admin@localhost IDENTIFIED BY 'pass4directadmin' WITH GRANT OPTION;
Query OK, 0 rows affected (0.00 sec)

If I know do something like below it works fine. But from with the directadmin pages it keeps saying the password is incorrect! See:

Error creating the database

Details

Invalid Password

mysql -u da_admin -p

I am using:
mysql Ver 14.7 Distrib 4.1.10, for pc-linux-gnu (i686)

Marshall · Apr 4, 2007

When you copy paste the password from the mysql.conf file it lets you login? Make sure it is exactly the same, caps and all.