Home • Database • MySQL Nov 27th, 2021 at 10:33 AM

Change MySQL user password

Method1 For MySQL server version 5.7.6 or newer:

ALTER USER 'jahid'@'localhost' IDENTIFIED BY '******';

Method2 For MySQL server version 5.7.5 or older:

SET PASSWORD FOR 'jahid'@'hostname' = PASSWORD('*****');

SET PASSWORD FOR 'jahid'@'localhost' = '*****'

Method3 For current user:

SET PASSWORD = '*****';

Note: to see current user:

SELECT CURRENT_USER();

/25

Comment

About Author

Mohammad Towhidul Islam