Backup wrong user problem

[falafel]

Hello,


While creating all accounts backup we got 3 errors:

User admin has been backed up.
Error while backing up database ALICE_base
mysqldump error output: /usr/local/mysql/bin/mysqldump: Got error: 1044:
Access denied for user 'BOB'@'localhost' to database 'ALICE_base' when
selecting the database

Error while backing up database CHARLES_base
mysqldump error output: /usr/local/mysql/bin/mysqldump: Got error: 1044:
Access denied for user 'BOB'@'localhost' to database 'CHARLES_base' when
selecting the database

Error while backing up database JOE_base
mysqldump error output: /usr/local/mysql/bin/mysqldump: Got error: 1044:
Access denied for user 'BOB'@'localhost' to database 'JOE_base'
when selecting the database

My user BOB backup all database

Any idea ?

 

[zEitEr]

As far as I know, directadmin when running mysqldump uses da_admin's credentials. Where did you get BOB user?

 

[falafel]

BOB is the first user whom I have create. His backup is correctly made, it’s normal. But I don ‘t understand why mysqldump use BOB for the backup of the others databases.

 

[SeLLeRoNe]

Directadmin should use AFAIK the login data present in

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

Check the file if username is da_admin and password is correct (test it with phpmyadmin for example.

Regards

 

[falafel]

Da_admin and password are correct, but what is the configuration file used by directadmin for the backup and who chooses the user DA_admin ?

 

[SeLLeRoNe]

the da_admin user is created by directadmin installation.

The admin backup at admin lever will use that file for backup.. well, i suppose.. the fact is using user BOB is strange to me, try to contact directadmin staff.

Regards

 

[zEitEr]

Check if /root/.my.cnf exists. If exists, you might want to delete it.


+ Check if /usr/local/directadmin/conf/my.cnf exists. It should have valid and actual da_admin's password. This file is used with mysql dumping.

 

[falafel]

I have four files in /usr/local/directadmin/conf/

directadmin.conf
license.key
my.cnf
mysql.conf
​

But no my.conf, i check with valid da_admin and password.

 

[zEitEr]

Sorry, i mistyped.

Make sure /usr/local/directadmin/conf/my.cnf contains da_admin's credentials to connect to MySQL:

user=da_admin
password=my_pass

 

[falafel]

yes,i contacted directadmin staff

 

[falafel]

The cause of the problem, a hidden file /root/.my.cnf

 

[zEitEr]

Oops, mistyped again in

Check if /root/my.cnf exists

http://www.directadmin.com/forum/showpost.php?p=202441&postcount=7

of course should be

Check if /root/.my.cnf exists

 

[dragonfly]

as i know a_admin and password are correct, but what is the configuration file used by directadmin for the backup and who chooses the user DA_admin ?

 

[zEitEr]

who chooses the user DA_admin ?

da_admin is used to connect to MySQL server. You can change it to anything you like, of course if you know, how to create a new mysql user with "root" privileges.