Details
-
Bug
-
Status: Closed (View Workflow)
-
Minor
-
Resolution: Fixed
-
2.3.7
-
None
-
MXS-SPRINT-85
Description
Any user can connect to an instance, also via maxscale, and change db to 'information_schema', seeing only his objects.
Nevertheless if 'information_schema' is specified upon connection the connection is denied with:
# mysql -ujack -p123 -h127.0.0.1 -P4009 -D information_schema
|
ERROR 1045 (28000): Access denied for user 'jack'@'127.0.0.1' (using password: YES) to database 'information_schema'
|
The same connection directly to the node will succeed.
A workaround is to add this line:
INSERT INTO mysql.db VALUES ('%','information_schema','jack','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N','N'); |
Attachments
Issue Links
- relates to
-
MXS-2621 Incorrect SQL if lower_case_table_names is used.
- Closed