授权
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;
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;