Details
-
Type:
New Feature
-
Status: Closed (View Workflow)
-
Priority:
Major
-
Resolution: Fixed
-
Affects Version/s: 1.2.0, 1.4.1
-
Fix Version/s: 2.1.0
-
Component/s: mariadbclient
-
Labels:None
-
Environment:Centos 7.1
-
Sprint:2017-25
Description
We have used the wildcard capability with grants in our current MySQL setup, using grants such as
grant all on `%user%`.* to 'user'@'%' identified by 'somepassword'; |
If we try this with the command line client pointed at a maxscale host, specifying a database gives us an 'access denied' failure.
mysql -h maxscale_host -u user -p user_db
|
whereas connecting to one of the Galera nodes directly works
mysql -h galera_host -u user -p user_db
|
If we explicitly set the grant for a specific database, then the client works
grant all on `user_db`.* to 'user'@'%' identified by 'somepassword'; |
In all cases, connecting without specifying the database and then choosing the database with a use statement works.