Resolved After upgrade to MariaDB 10.6 (from 10.5) Backup results in error

[Jürgen_T]

Server operating system version

Ubuntu 20.04.4 LTS

Plesk version and microupdate number

Plesk Obsidian v18.0.44

After upgrade from MariaDB 10.5 to 10.6 the Plesk-Backup does not get access to the DB. It shows the following error message:

Unable to make database dump. Error: Failed to exec mysqldump: Exit code: 2: WARNING: Forcing protocol to TCP due to option specification. Please explicitly state intended protocol. mysqldump: Got error: 1045: "Access denied for user 'admin'@'127.0.0.1' (using password: YES)" when trying to connect

I followed already a related post:

https://support.plesk.com/hc/en-us/articles/213364309-Unable-to-access-Plesk-GUI-Access-denied-for-user-admin-localhost-using-password-YES-

but without success.

Is there any idea how to solve this?

 

[Jürgen_T]

I found a solution but I am not sure how good it is. I checked the existig user in my DB and found admin@localhost . Obviously this should be sufficient to get access as user admin at 107.0.0.1 but it did not. So I created a 2nd user admin@107.0.0.1 - both with same passwords and now the backup works again.

If somebody has an idea for a seperate solution so I could get rid of one of the 2 admin-accounts I would be glad to hear.

 

[mow]

Do you have name resolution off?

 

[Jürgen_T]

Do you have name resolution off?

Do you mean name resolve ? If yes, name resolve is on.

 

[Jürgen_T]

The comment by mow finally helped. I found two entries in the jungle of all relevant conf-files for MariaDB where I only tested one with on/off i.e. without leading # and with #. Now I tested to get rid of both entries skip-name-resolve, dropped the 2nd user admin@127.0.0.1 again and ... everything works without problems.

So the issue is solved!