Issue WordPress cloning attempt fails with 'mysqlcheck: Got error: 1045'

[Steg]

Server operating system version

Ubuntu 22.04

Plesk version and microupdate number

Obsidian 18.0.50.2

I'm trying to clone a site into a new subdomain and am getting the following error:

mysqlcheck: Got error: 1045: Access denied for user 'xxxx'@'localhost' (using password: YES) when trying to connect

I wasn't able to locate any threads or KB articles on this. Anyone got any ideas?

 

[Peter Debik]

I could not find anything specific on this situation, but recently there have been some threads that discussed issues when "skip-name-resolve" in /etc/my.cnf was on, because in that case "localhost" cannot be resolved to "127.0.0.1", and if the necessary permission sets in the "user" table of the database are missing for "localhost" as a name, but only refer to "127.0.0.1", access will be denied. You can test if it works by setting "skip-name-resolve = 0" and restarting the database afterwards. If it works, fine, if it does not work, revert to the previous setting.

 

[Steg]

Looks like the main file is actually in /etc/mysql/. However, I don't see skip-name-resolve in any of the .conf files.

 

[Steg]

Anyone got any other ideas?

 

[Peter Debik]

Could you please add skip_name_resolve = off to my.cnf and restart the database? Does the issue persist?

 

[Steg]

The suggested change did not fix the error. Any other ideas?

 

[Steg]

Anyone got another theory?

Would it be easier if I had the client submitted an official support ticket?

 

[Peter Debik]

Yes, please. It has something to do with permissions, but if it is not the host name resolution, it needs to be checked on the server what it is.