数据库命令:
mysql -u root -p
查看现有用户权限:
SELECT User, Host FROM mysql.user;
授予远程访问权限:
允许从任何 IP 地址访问:
GRANT ALL PRIVILEGES ON *.* TO 'youruser'@'%' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;
允许从特定 IP 地址访问:
GRANT ALL PRIVILEGES ON *.* TO 'youruser'@'113.65.80.163' IDENTIFIED BY 'yourpassword' WITH GRANT OPTION;
FLUSH PRIVILEGES;