两步实现 mysql 远程连接

第一步：打开电话防火墙 TCP 3306 端口

 

 

第二步：在mysql命令例界面输入以下内容

让所有人以myuser,mypassword登录 

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

 

IP为192.168.1.105以myuser,mypassword登录 

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

 

搞定

转载于:https://blog.51cto.com/cclosh/1149074