Error then creating database

[AlexEwp]

When I try to create new database I get this error.

Original error:

Error inserting host: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Unable to set privileges for debtntc on debtntc_test1: Can't find any matching row in the user table Unable to revoke privileges for debtntc on debtntc_test1: There is no such grant defined for user 'debtntc' on host '213.252.247.112' Error inserting host: View 'mysql.user' references invalid table(s) or column(s) or function(s) or definer/invoker of view lack rights to use them Unable to set privileges for debtntc_test1 on debtntc_test1: Can't find any matching row in the user table Unable to revoke privileges for debtntc_test1 on debtntc_test1: There is no such grant defined for user 'debtntc_test1' on host '213.252.247.112' Your database has been setup. Use the following values:

On Directadmin panel I can see the database but I can't login in to it with PhpMyAdmin. Any help would be appreciated.
Thanks in advance

 

[mariusslo]

To follow up on the case I've done some more digging into this issue. So i connected with root access user to phpmyadmin to check the users and found this. Old databases had 4 users for each database, while the new one has only 2. Also we are using a remote MySQL Server.

The old detabases were structured like this:
|host | user |
|localhost | user |
|localhost | db_user |
|DA Server IP | user |
|DA Server IP | db_user |

while the newly created ones were structured like this:
|host |user |
|localhost |user |
|localhost |db_user |

Perhaps after an update some settings were overridden?