mySQL: Password setup - Set up passwords from the mysql console.

Quick Search:

mySQL: Password setup

Jump to:

Category: >> mySQL >> Password setup

<< last

next >>

Snippet Name: Password setup

Description: Set up passwords from the mysql console.

Comment: (none)

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