Details
-
Bug
-
Status: Closed (View Workflow)
-
Major
-
Resolution: Fixed
-
2.2.15
-
None
-
RHEL 7.x MariaDB 10.3.x
-
MXS-SPRINT-69
Description
MariaDB SET PASSWORD saves the password in mysql.user.authentication_string field and MaxScale is looking at mysql.user.password field for authentication.
MariaDB [(none)]> select user, password, authentication_string from mysql.user; |
+------------+-------------------------------------------+-----------------------+ |
| user | password | authentication_string | |
+------------+-------------------------------------------+-----------------------+ |
| root | | |
|
| root | | |
|
| root | | |
|
| root | | |
|
| | | |
|
| | | |
|
| migration | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | |
|
| migration | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | |
|
| migration | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | |
|
| las | *9677B3E0EA32E863BCE766756E363CF03A6C7E4C | |
|
| las | *9677B3E0EA32E863BCE766756E363CF03A6C7E4C | |
|
| eclaimsadm | *9677B3E0EA32E863BCE766756E363CF03A6C7E4C | |
|
+------------+-------------------------------------------+-----------------------+ |
12 rows in set (0.000 sec) |
|
|
MariaDB [(none)]> SET PASSWORD FOR las@'%' = PASSWORD('test'); |
Query OK, 0 rows affected (0.000 sec) |
|
|
MariaDB [(none)]> select user, password, authentication_string from mysql.user; |
+------------+-------------------------------------------+-------------------------------------------+ |
| user | password | authentication_string | |
+------------+-------------------------------------------+-------------------------------------------+ |
| root | | |
|
| root | | |
|
| root | | |
|
| root | | |
|
| | | |
|
| | | |
|
| migration | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | |
|
| migration | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | |
|
| migration | *2470C0C06DEE42FD1618BB99005ADCA2EC9D1E19 | |
|
| las | *9677B3E0EA32E863BCE766756E363CF03A6C7E4C | |
|
| las | | *94BDCEBE19083CE2A1F959FD02F964C7AF4CFC29 |
|
| eclaimsadm | *9677B3E0EA32E863BCE766756E363CF03A6C7E4C | |
|
+------------+-------------------------------------------+-------------------------------------------+ |
12 rows in set (0.000 sec) |
|
|
MariaDB [(none)]>
|
Attachments
Issue Links
- is caused by
-
-
- Closed
-