服务器安装mysql后配置远程访问权限

#登录mysql

mysql -uroot -p；

use mysql；

#所有ip能访问

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'%' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

#设置某个ip能访问

GRANT ALL PRIVILEGES ON *.* TO 'myuser'@'192.168.1.3' IDENTIFIED BY 'mypassword' WITH GRANT OPTION;

转载于:https://my.oschina.net/tianshuhao/blog/1550925