1.设置远程权限
登录mysql后:
mysql>grant all privileges on *.* to 'root'@'%' identified by '123456';
root = 账户
123456=密码
2.使远程权限立即生效
mysql> flush privileges;
3.在SQLyog上登录
1.设置远程权限
登录mysql后:
mysql>grant all privileges on *.* to 'root'@'%' identified by '123456';
root = 账户
123456=密码
2.使远程权限立即生效
mysql> flush privileges;
3.在SQLyog上登录