mysqldump error output: mysqldump: Got error: 1045: "Access denied for user 'da_admin'@'localhost' (using password: YES)" when trying to connect

N

needhelppp

Verified User
Joined
Jul 1, 2020
Messages
88
Hello, dear all.

Im in a bit of a pickle at the moment. Need to transfer accounts and websites with mail data from one DA server to other, and have to do it till tomorrow night. But having huge issues. Since wordpress backup restore does not work properly. Directadmin backups also dont work. Tried rebuilding stuff on that source server - installing CustomBuild (it was not there), messed up pureftpd (does not load anymore), and it seems everywhere I see same or similar database error (only difference is database name). This one is from making directadmin backups at user level:

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

The source server has very old mariadb 5.5 version and the websites work with 5.3 php version.

Even on wordpress level, somehow it seemed that backup was made, but restore had issues, and the website now also shows:
Access denied for user 'komentaras_db'@'localhost' (using password: YES)

I even tried to change da_admin password for mysql. Did not help. So im completely lost ;/

Is there any chance someone could help me? I don't think there is any other way to migrate all that data, only to fix the source server first...

Thank You.
 
Restored the original password for mysql root and da_admin again, things should be working again now.
 
Greetings

I am seeing the same issue when trying to backup a single user.
I have followed two posts but I am not clear on something that I hope someone can clarify.

If I run the command 'mysql -u da_admin -p' I can access mysql without a hassle. If I try the same with the user root then I get access denied.
What is the correlation between the da_admin user and the root user. The directadmin backup is run by the user da_admin, which should have full root privileges, so I do not understand where and how the error is occurring.

Also with the fact that I can login with the da_admin password correctly, I see no need to change the password.

The backup completes only the .sql file is empty. So the users files are backed up but not any database entries.
The next question is, is this a false positive where no database content should be backed up for the user?

Any suggestions or ideas how to resolve this issue.

Thanks
Lawrence
 
llamprec said:
Greetings

I am seeing the same issue when trying to backup a single user.
I have followed two posts but I am not clear on something that I hope someone can clarify.

If I run the command 'mysql -u da_admin -p' I can access mysql without a hassle. If I try the same with the user root then I get access denied.
What is the correlation between the da_admin user and the root user. The directadmin backup is run by the user da_admin, which should have full root privileges, so I do not understand where and how the error is occurring.

Also with the fact that I can login with the da_admin password correctly, I see no need to change the password.

The backup completes only the .sql file is empty. So the users files are backed up but not any database entries.
The next question is, is this a false positive where no database content should be backed up for the user?

Any suggestions or ideas how to resolve this issue.

Thanks
Lawrence
Click to expand...
In the meantime I did a restore of all the files that were backed up and when looking at each users profile, it seems that none of the databases have been backed up and as such not restored.

Lawrence
 
If you still have issues, please mind the following.

1.) Please don't quote full posts, (so don't use the reply button), to keep things clear.
2.) Please start a new fresh thread for your issue because it seems that is has a different cause because you can get into the database with the da_admin name and pass.
3.) Keep in mind that the mysql root is something else then the server root. And the mysql root has a different password (or at least had a different pass) then da_admin had. And indeed da_admin should have the same permissions.
 
Richard G said:
If you still have issues, please mind the following.

1.) Please don't quote full posts, (so don't use the reply button), to keep things clear.
2.) Please start a new fresh thread for your issue because it seems that is has a different cause because you can get into the database with the da_admin name and pass.
3.) Keep in mind that the mysql root is something else then the server root. And the mysql root has a different password (or at least had a different pass) then da_admin had. And indeed da_admin should have the same permissions.
Click to expand...
Sorry,

I will create a new thread.
Lawrence
 
You must log in or register to reply here.
Back
Top