You are here: Home / Technology / MySQL Command: Changing Root Password

MySQL Command: Changing Root Password

December 8, 2009 by admin · Leave a Comment 

This command is used to set the password to a user called: root

use mysql

UPDATE user SET Password=PASSWORD(’password’) WHERE user=’root’;

FLUSH PRIVILEGES;

quit

Filed under Technology · Tagged with

About admin

Speak Your Mind

Tell us what you're thinking...
and oh, if you want a pic to show with your comment, go get a gravatar!