Error: Connection to the database server failed: Operation CREATE USER failed for

[Adrian I]

I'm experiencing this issue when creating a mysql database and user together, or when adding a user to a database:
Error: Connection to the database server failed: Operation CREATE USER failed for 'db-user-name'@'localhost'

Probably related, if I try;
plesk repair mysql
from ssh, I get errors creating absent users for existing databases:
The user db-user-name is absent from the database server ........ [ERROR]
Recreate the user db-user-name with default permissions and default hosts? [Y/n] y
Recreating the user db-user-name .............................. [FAILED]
- Operation CREATE USER failed for 'some-db-name'@'%'

Can anybody shed light on either / both issues?

 

[abdi]

Look at the MySQL logs to see why MySQL is rejecting those actions.

 

[Adrian I]

Nothing is logged to the mysql error log or the general query log (which I temporarily enabled).
Nothing in sw-cp-server/error_log either.
Which is unhelpful, I know.

Adrian.

 

[UFHH01]

Hi Adrian I,

I suggest to use the option string "all" with the Plesk repair utility, after you switched on the debug - level -mode, described at:

How to enable/disable debug logging in Plesk 11.5 and up? ( Plesk Knowledge-Base article 120101 )
​

With the more verbose output you might investigate the issue(s)/error(s)/failure(s) or problem(s) much easier.