MySQL Open remote connection method

Solve MySQL methods that are not allowed from remote access

There are two major strides in opening MySQL's remote login account:

1. Determine that the firewall on the server does not block port 3306.

MySQL default port is 3306, need to determine the firewall does not block 3306 port, otherwise remote is unable to connect via 3306 port to MySQL.

If you specified a different port when you installed MySQL, open the port number that you specified for MySQL in the firewall.

If you don't know how to set up a firewall on your server, check with your server administrator.

2, add to allow remote connection to MySQL users and authorized.

1) First log in to MySQL with the root account

In the Windows Host, click Start menu, Run, enter "cmd", go to the console, MySQL Bin directory, and enter the following command.

In the Linux host, enter the following command at the command prompt line.

• > MySQL - Uroot - p123456

123456 is the root user's password.

• > grant all privileges on Discuz .*  To Ted @ ' 123.123.123.123 ' identified by ' 123456 ' ;
  

MySQL Open remote connection method