強哥的部落格

mysql -u root -p
mysql> SET PASSWORD FOR 'john'@'localhost' = PASSWORD('john123');
mysql> flush privileges;

mysql -u root -p
mysql> use mysql;
mysql> UPDATE user SET Password=PASSWORD("john123") WHERE User='john';
mysql> flush privileges;