#786 SQLSTATE[42S02]: Base table or view not found

[MikeH]

Since we upgraded from a 4.7.* version to 4.8.0 we see several errors like this on some pages:

Warning: PDO::query(): SQLSTATE[42000]: Syntax error or access violation: 1044 Access denied for user 'ehub'@'10.0.0.3' to database 'information_schema' in /var/www/html/adminer.php on line 185

This error appears after login. It's in the middle of the list of databases at the information_schema database.

Another error appeared, when I tried to execute this SQL:

show indexes from monitored_task

The error is:

Warning: PDO::query(): SQLSTATE[42S02]: Base table or view not found: 1146 Table 'ehub.STATISTICS' doesn't exist in /var/www/html/adminer.php on line 185

Our DB is called "ehub" and "monitored_task" is on of the tables there.

We can not modify the access rights of that user. I'm pretty sure, we did not see any errors in older versions.

We use the adminer docker image to run adminer.

[Jakub Vrána]

Which database system are you using?

[MikeH]

MySQL 5.7.30, running from the official docker image.

[Jakub Vrána]

Thanks, fixed.