Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.5.5
-
None
-
MXS-SPRINT-121
Description
As per subject, on MaxScale 2.5.5 (not on 2.4.11) see example.
Worth noting the grants use a wildcard for the schema.
A somewhat similar issue has been fixed in 2.5.7 (https://jira.mariadb.org/browse/MXS-3303)
[root@centos71 ~]# mariadb -u myuser -p123 -h 127.0.0.1 -P 4006 sales-main |
ERROR 1044 (42000): Access denied for user 'myuser'@'127.0.0.1' to database 'sales-main' |
|
|
[root@centos71 ~]# mariadb -u myuser -p123 -h 127.0.0.1 -P 4006 |
Welcome to the MariaDB monitor. Commands end with ; or \g.
|
|
|
MariaDB [(none)]> use sales-main
|
Database changed
|
|
|
MariaDB [sales-main]> show tables;
|
+-------------------+
|
| Tables_in_sales-main |
|
+-------------------+
|
| t1 |
|
+-------------------+
|
1 row in set (0.003 sec) |
|
|
MariaDB [sales-main]> show grants;
|
+---------------------------------------------------------------------------------------------------------+
|
| Grants for myuser@% | |
+---------------------------------------------------------------------------------------------------------+
|
| GRANT USAGE ON *.* TO `myuser`@`%` IDENTIFIED BY PASSWORD '*password' | |
| GRANT ALL PRIVILEGES ON `sales-%`.* TO `myuser`@`%` |
|
+---------------------------------------------------------------------------------------------------------+
|
2 rows in set (0.002 sec) |