How to Reset User Password in MySQL/MariaDB

<<Back to MySQL & MariaDB How To Page

How to Reset User Password in MySQL 5

set password for user 'user'@'hostname' =   PASSWORD ('New Password');
mysql> set password for 'atiwari'@'test.com'  =  PASSWORD ('XXXXXXX');
Query OK, 0 rows affected (0.01 sec)

If you already know the encrypted Password

set password for user 'user'@'hostname'  =   'Encrypted Password';

mysql> set password for 'atiwari'@'test.com'  =  'DEAAAAAFXDHGU3248DGHFDGSYE';

Query OK, 0 rows affected (0.01 sec)

mysql> flush privileges;

How to Reset User Password in MariaDB or MySQL 8

ALTER USER 'user'@'hostname' IDENTIFIED BY 'MyNewPass';
MariaDB [(none)]> alter user 'atiwari'@'test.com' IDENTIFIED BY 'MyNewPassword';
Query OK, 0 rows affected (0.00 sec)