Modify the method of mysql to allow host access

How to modify mysql to allow host access? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

Users who default to mysql do not have remote access, so when the program is not on the same server as the database, we need to enable remote access to mysql.

Enable remote access to mysql

The user who defaults to mysql does not have remote access, so when the program is not on the same server as the database, we need to enable remote access to mysql.

There are two mainstream methods, the table change method and the authorization law.

Relatively speaking, the table change method is relatively easy, and individuals are more inclined to use this method, so only the meter change method is posted here.

1. Log in to mysql

Mysql-u root-p

2. Modify the user table of the mysql library and change the host entry from localhost to%. % here means that arbitrary host access is allowed. If only one ip access is allowed, it can be changed to the corresponding ip. For example, the localhost can be changed to 192.168.1.123, which means that only 192.168.1.123 ip of the local area network is allowed to access the mysql remotely.

Mysql > use mysql; mysql > update user set host ='% 'where user =' root'; mysql > select host, user from user; mysql > flush privileges

Firewall opens port 3306

Thank you for reading! After reading the above, do you have a general idea of how to modify mysql to allow host access? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.