MySQL权限设置

GRANT ALL PRIVILEGES ON *.* TO 'azurekiln_cn'@'127.0.0.1';
FLUSH PRIVILEGES;

# 查看同步用户权限
SHOW GRANTS FOR 'azurekiln_cn'@'127.0.0.1';

# 查看所有用户
SELECT user, host FROM mysql.user;

# 退出
exit

GRANT ALL PRIVILEGES ON *.* TO 'root'@'127.0.0.1' IDENTIFIED BY 'password' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'45.207.192.4' IDENTIFIED BY 'password' WITH GRANT OPTION;
FLUSH PRIVILEGES;