使用客户端等远程连接mysql数据库及php安装配置

虚拟机：

https://blog.youkuaiyun.com/pyrans/article/details/82389220

navicat远程连接mysql

https://www.cnblogs.com/liyafei/p/8335099.html

window下开启远程连接：

https://blog.youkuaiyun.com/c1481118216/article/details/53053036/

安装mysq、apach、php：

https://blog.youkuaiyun.com/galen2016/article/details/80778662?utm_medium=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-1.channel_param&depth_1-utm_source=distribute.pc_relevant.none-task-blog-BlogCommendFromBaidu-1.channel_param

 

向所有用户开放：
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
FLUSH PRIVILEGES;

向指定用户名、密码配置访问权限

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.200.14.103'IDENTIFIED BY 'denglaoshi' WITH GRANT OPTION;
FLUSH PRIVILEGES;