linux windows 开启远程连接Mysql

linux windows 开启远程连接

1. root用户登录mysql

   mysql -uroot -p你的密码
   

2. 授权远程连接

   GRANT ALL PRIVILEGES ON *.* TO '用户名'@'%' IDENTIFIED BY '你的密码' WITH GRANT OPTION;
   
   例如: GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY 'root' WITH GRANT OPTION;
   

3. 生效

   FLUSH PRIVILEGES;
   

4. 重启mysql

   windows环境：
   windows + r   
   services.msc
   找到mysql 重启mysql
   

   linux环境输入命令：
   service  mysql restart