[MXS-2502] Specifying 'information_schema' as default schema upon connection gives 'access denied' Created: 2019-05-22  Updated: 2019-08-02  Resolved: 2019-07-05

Status: Closed
Project: MariaDB MaxScale
Component/s: Authenticator
Affects Version/s: 2.3.7
Fix Version/s: 2.3.10

Type: Bug Priority: Minor
Reporter: Claudio Nanni Assignee: Marko Rajala (Inactive)
Resolution: Fixed Votes: 1
Labels: None

Issue Links:
Relates
relates to MXS-2621 Incorrect SQL if lower_case_table_nam... Closed
Sprint: 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');


Generated at Thu Feb 08 04:14:36 UTC 2024 using Jira 8.20.16#820016-sha1:9d11dbea5f4be3d4cc21f03a88dd11d8c8687422.