Page 1 of 1

Changing a MySQL User's Password

New postPosted: Thu Mar 27, 2008 10:49 pm
by Ranman
Code: [Select all] [Expand/Collapse] [Download] (Untitled)
# In this example of changing a MySQL user's password
# we will use username 'norma' and new password 'DMRNWIMA'.
#
mysql -u root -p

USE mysql;
UPDATE user SET Password=PASSWORD('DMRNWIMA') WHERE user='norma';
FLUSH PRIVILEGES;