mysql-远程连接
2018-03-05 本文已影响0人
知孺
1.修改my.cnf 配置 更改bind-ip 为 0.0.0.0
2.配置mysql
登陆:
mysql -u root -p"youpassword"
配置权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
刷新配置:
FLUSH PRIVILEGES;
1.修改my.cnf 配置 更改bind-ip 为 0.0.0.0
2.配置mysql
登陆:
mysql -u root -p"youpassword"
配置权限
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'youpassword' WITH GRANT OPTION;
刷新配置:
FLUSH PRIVILEGES;