Skip to content

Change a User’s Password in MySQL

Log in to the database as root and do the following:


mysql> USE mysql;
mysql> UPDATE user SET password = password('newpassword')
WHERE User='username';
mysql> FLUSH PRIVILEGES;

Post a comment — Trackback URI RSS 2.0 feed for these comments This entry (permalink) was posted on Thursday, January 15, 2009, at 1:51 pm by admin. Filed in Applications and tagged .

Post a Comment

Your email is never published nor shared. Required fields are marked *
*
*