SELECT User, Password, Host FROM user; – 查看现有用户,密码及允许连接的主机
GRANT ALL PRIVILEGES ON . TO ‘root’@’116.231.135.93’ IDENTIFIED BY ‘ts1999#opw1’ WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ‘ts1999#opw1’ WITH GRANT OPTION;
flush privileges;