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)]>
|