MySQL用户授权与密码修改

Tue 08 October 2013
By dqw

授权

GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.56.%';
FLUSH PRIVILEGES;

密码修改

USE mysql
UPDATE mysql.user SET Password=PASSWORD('111111') WHERE User='bob' AND Host='%.example.org';
FLUSH PRIVILEGES;