set passwords in mysql





0
Date Submitted Mon. Oct. 13th, 2008 11:10 PM
Revision 1 of 1
Beginner jmardones
Tags mysql
Comments 0 comments
this snippet show how to set up passwords in a mysql console.


$ mysql -u root -p
mysql> USE mysql;
mysql> UPDATE user SET password=PASSWORD("NEWPASSWORD") WHERE User='my user';
mysql> flush PRIVILEGES;
mysql> quit

 

Juan Carlos Mardones

Comments

There are currently no comments for this snippet.

Voting

Votes Up


Newbie ixtf

Votes Down


Helper mceppi