Mysql connect failed for da_admin

[defiancenl]

OK ive got a very weird problem over here.
Ive read the KB articles but they are no help sadly.

the following is happening, when i do a admin backup/transfer the backup failed with the error :

Error while backing up database blablabla: The sql file is 0 bytes in size: /home/admin/admin_backups/blablabla/backup/blablabla_bla.sql
mysqldump error output: mysqldump: Got error: 1045: Access denied for user 'da_admin'@'localhost' (using password: YES) when trying to connect

Now the strange stuff.

The passwd in

/usr/local/directadmin/conf/mysql.conf

Is CORRECT.

user=da_admin
passwd=dDE@#D32

Logging in as root with the above passwd.

bla:/usr/local/directadmin/conf# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 96
Server version: 5.0.81 MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Logging in as da_admin with the above password.

bla:/usr/local/directadmin/conf# mysql -uda_admin -p
Enter password:
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 98
Server version: 5.0.81 MySQL Community Server (GPL)

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>

Logging in on phpMyAdmin also works. :/
And i can access the db's with da_admin and above password.

so i have verified that the passwd works :/

Any help appreciated !

 

[floyd]

Here is a thought. I do not recall seeing DA use special characters like that in the passwords they generate but I could be wrong. Did you change the password to something else after the initial install? Whatever the case I would try changing to something without the special characters and see what happens. Change it in mysql.conf and in mysql itself. Perhaps the backup script has trouble with certain special characters.

 

[streamservice]

OK ive got a very weird problem over here.
Ive read the KB articles but they are no help sadly.

the following is happening, when i do a admin backup/transfer the backup failed with the error :


Now the strange stuff.

The passwd in


Is CORRECT.



Logging in as root with the above passwd.


Logging in as da_admin with the above password.


Logging in on phpMyAdmin also works. :/
And i can access the db's with da_admin and above password.

so i have verified that the passwd works :/

Any help appreciated !

First: change your password (you did publish it online)

Also change the password to contain no '#', this is probably the issue. See also http://www.directadmin.com/forum/showthread.php?t=34665