set passwords in mysql





1
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

 

x y

Comments

There are currently no comments for this snippet.

Voting

Votes Up


Scripter elsevero
Newbie ixtf

Votes Down


Helper mceppi