Common problems with MySQL Permissions

The following article describes the remote MySQL permissions, if you are a fan of MySQL. The following article will be of great help to you. The following is a detailed description of the relevant content, hoping to help you in this regard.

A few people have asked me the same question recently. I installed MySQL and then used telnet ip 3306. The port then reported BHost '123. 0.0.1 'is not allowed to connect to this MySQL serverConnection closed by foreign host. Although I have encountered it before and solved it later, I think it is worth posting, it is estimated that many people will have encountered the same problem by posting a solution:

 
 


  
  
MySQL> UPDATE MySQL. user SET Host = '%' WHERE Host = 'localhost ';

  
  
MySQL> GRANT ALL PRIVILEGES

 
 

The above content is an introduction to the problem of remote MySQL permissions. I hope you will get some benefits.
 

The above content is a description of the problem that the old user wants to obtain the remote MySQL permission. I hope it will help you in this regard.