MySql 允许远程用户登录访问

Zony 2 years ago (2016-12-25 21:54) MySql

# mysql -u root -proot 
mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;

之后刷新权限即可。

FLUSH PRIVILEGES

服务器记得打开3306端口。