1. 登录mysql
mysql -uroot -p (随后输入密码)
2. 设置允许远程访问
GRANT ALL PRIVILEGES ON *.* TO '账号'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
例如
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
3. 刷新权限
FLUSH PRIVILEGES;
1. 登录mysql
mysql -uroot -p (随后输入密码)
2. 设置允许远程访问
GRANT ALL PRIVILEGES ON *.* TO '账号'@'%' IDENTIFIED BY '密码' WITH GRANT OPTION;
例如
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'mysql' WITH GRANT OPTION;
3. 刷新权限
FLUSH PRIVILEGES;