|
MariaDB server version : 10.3.9
|
MariaDB [(none)]> create user 'test123'@'localhost' identified by 'test123';
|
Query OK, 0 rows affected (0.000 sec)
|
|
MariaDB [(none)]> set password for test123@localhost=password('test123');
|
Query OK, 0 rows affected (0.000 sec)
|
|
MariaDB [(none)]> select user,host,password from mysql.user where user='test123';
|
+---------+-----------+----------+
|
| user | host | password |
|
+---------+-----------+----------+
|
| test123 | localhost | |
|
+---------+-----------+----------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> set password for 'test123'@'localhost'=password('test1234');
|
Query OK, 0 rows affected (0.000 sec)
|
|
MariaDB [(none)]> select user,host,password from mysql.user where user='test123';
|
+---------+-----------+----------+
|
| user | host | password |
|
+---------+-----------+----------+
|
| test123 | localhost | |
|
+---------+-----------+----------+
|
1 row in set (0.000 sec)
|
|
MariaDB [(none)]> alter user 'test123'@'localhost' identified by 'test1234';
|
Query OK, 0 rows affected (0.000 sec)
|
|
MariaDB [(none)]> select user,host,password from mysql.user where user='test123';
|
+---------+-----------+-------------------------------------------+
|
| user | host | password |
|
+---------+-----------+-------------------------------------------+
|
| test123 | localhost | *3D3B92F242033365AE5BC6A8E6FC3E1679F4140A |
|
+---------+-----------+-------------------------------------------+
|
1 row in set (0.000 sec)
|
|
While checking with previous MariaDB server version : 10.2.14 its working fine.
|
|
MariaDB [(none)]> create user 'test123'@'localhost' identified by 'test123';
|
Query OK, 0 rows affected (0.01 sec)
|
|
MariaDB [(none)]> set password for test123@localhost=password('test123');
|
Query OK, 0 rows affected (0.00 sec)
|
|
MariaDB [(none)]> select user,host,password from mysql.user where user='test123';
|
+---------+-----------+-------------------------------------------+
|
| user | host | password |
|
+---------+-----------+-------------------------------------------+
|
| test123 | localhost | *676243218923905CF94CB52A3C9D3EB30CE8E20D |
|
+---------+-----------+-------------------------------------------+
|
1 row in set (0.00 sec)
|
|
|