MySQL is one of the commonly used databases. When we use the database, we don't just use it in our computer, so it is necessary to access it remotely. So how do you open MySQL port 3306? Look at the following tutorial and see the specific steps.

The specific method is as follows:

1, first enter the console, as shown below, I use putty tool to realize remote control;

Then enter "netstat-an|grep3306" to see if it is turned on. As shown in the figure below, only displaying listen means it is not turned on;

2. Enter the etc/mysql directory through the cd command. Then enter the ls command to view the files in the directory;

3. You will see my.cnf in the file. Enter the editing state through the "vimy.cnf" command;

4. Comment out "bind-address =127.0.0.1"or replace it with an ip address that requires remote connection, or simply delete this sentence;

5. Then, save it.

Method 2:

1, that is, change the permissions of the folder by command, enter the file name sudochomd 666+, and backtest, so as to improve the permissions of the file (if it is a folder, you need to add-LD at the back);

2. Find it under etc/mysql through the folder. (enter this directory by selecting filesystem, etc, mysql);

3. Select the my.cnf file, click Open, and then comment out "bind-address =127.0.0.1"or replace it with an ip address that requires remote connection, or delete this sentence directly;

4. Click Close and save.

The above is to share with you the method of opening MySQL port 3306 in win7 system. Is it simple? I hope this tutorial can help you.