异地登录mysql数据库配置

七海恋空 2019-04-26 浏览(0 评论(0

异地登录mysql需要授权,先授权,后提交。

用命令行登录sql
cd切换到mysql的bin目录下
mysql -u root -p

mysql>GRANT ALL PRIVILEGES ON *.* TO 'root'@'192.168.0.17'IDENTIFIED BY 'trsadmin' WITH GRANT OPTION;
mysql>FLUSH PRIVILEGES;