Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
None
-
None
-
maxscale host: ubuntu 16
database shards: mysql 5.5 and mysql 5.6
mysql client: php 5.5 / Zend 1.18 default mysql connector
Description
The following message is shown
SELECT command denied to user 'user'@'host' for table 'mysql_table'
|
when running one of the following queries
SHOW COLUMNS IN database.tablename IN database;
|
EXPLAIN database.tablename;
|
DESCRIBE database.tablename;
|
This happens when no default database is set or when connected to a default database that is not on the same shard as the database that contains the table.