How does MySQL turn on remote connections? Sometimes we have to see the database on the server in real time because of the work, then we need to open the remote connection of the database, then how do we open the remote connection of MySQL? The following small series for everyone to open the MySQL remote connection method.
In the Linux environment, 3306-Port remote connection is closed by default, we need to open, in the MySQL database to open 3306 on OK.
MySQL account is not allowed to log on remotely by default. Login MySQL, change the "MySQL" Database in the table "host" item, "localhost" renamed "%". This allows for remote connections.