How to set the mysql port open on the server

How to open the mysql port on the server: 1. Find the mysql database and change localhost to [%]; 2. Open the firewall; 3. Write [bind-address: 0.0 in the my.cnf of the database .0.0】Open port 3306.

How to set the mysql port open on the server:

1: Modify in mysql,

Log in to the database and find the mysql database

Select user, host from user

Find the user name and the corresponding host. If the host value is localhost, only local access is allowed

Change it to %

2: Open Firewall

Find the firewall setting location. Please refer to the online tutorial for details. When pasting the code line, you need to paste it in front of a certain line. If you don’t know, just paste

3 under port 22: Write

bind-address: 0.0.0.0

# in my.cnf of the database. ##Open port 3306

Finally, just connect remotely. When connecting on my machine, the password must be quoted with double quotes, otherwise it will be rejected

More related free learning recommendations: mysql tutorial(Video)

The above is the detailed content of How to set the mysql port open on the server. For more information, please follow other related articles on the PHP Chinese website!