1.创建远程登陆账户 root 密码root
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
2.允许ip:192168.249.199 机器 通过用户名root 密码root 远程访问 guang_test下的所有表。
grant all privileges on guang_test.* to root@'192.168.249.199' identified by 'root'with grant option;
3.使生效
flush privileges;