Category: >> mySQL >> Password setup Bookmark and Share

<< lastnext >>

Snippet Name: Password setup

Description: Set up passwords from the mysql console.

Comment: (none)

Author: CoderZone
Language: MYSQL
Highlight Mode: MYSQL
Last Modified: March 01st, 2009

mysql -u root -p
mysql> USE mysql;
mysql> UPDATE user SET password=PASSWORD("NEWPASSWORD") WHERE User='some_user';
mysql> flush PRIVILEGES;
mysql> quit
There haven't been any comments added for this snippet yet. You may add one if you like.  Add a comment 
© | users online: 11