MySQL in window10 version does not work after setting remote access permission

One 、 background

MySQL The database is installed locally Window10 On the computer , So that all virtual machines can call the same database together . Suddenly found that the virtual machine cannot connect to the local database .

Two 、 Causes of problems and corresponding solutions

1、 Database operation user has not set remote connection permission

• View all users and permissions , Observe whether the user to be connected has access to the Internet 【%】：

  SELECT DISTINCT CONCAT('User: ''',user,'''@''',host,''';') AS query FROM mysql.user;
  

  
• If the user who needs to connect does not have access to the Internet , You can set... As needed using the following commands

  --  newly build MySQL user ：
  create user  user name  identified by ' The login password ';
  
  --  Authorize the specified user to access the specified database ：
  grant all on  Database name .* to ' user name '@'%';
  
  --  Delete user authorization 
  drop user " user name "@"%";
  
  --  Delete the specified user ：
  DELETE FROM mysql.user WHERE User=" user name ";
  
  --  Refresh the permissions ：
  flush privileges;
  

2、Window10 The corresponding port is not opened

• open Window10 Security Center
  

• Click on Firewall and network protection , Click on Advanced settings Options
  

• Pop up a new window to select Inbound rules > New rules

• Pop up a new window to select port > next step
  

• Fill in the required open port number , Click next ：
  

• Keep clicking back next step button , Last name Fill in as you like , Click on complete