Set MySQL to allow extranet access

Root default is remote login is not supported, with extranet connection you have to give permission? Grant all privileges in *.* to ' username ' @ '% ' identified by ' password ' with GRANT OPTION; you first create a remote login account and give it permission to log on remotely.

MySQL root account, I usually use the connection is localhost or 127.0.0.1, the company's test server mysql is also localhost so I want access to inaccessible, test paused.

The workaround is as follows:

1, modify the table, login MySQL database, switch to the MySQL database, use SQL statements to view "select Host,user from User;" Mysql-u root-pvmwaremysql>use MySQL; Mysql>update User Set host = '% ' where user = ' root '; Mysql>select host, user from user; Mysql>flush privileges; Note: The last sentence is important in order for the changes to take effect. If it is not written, you still cannot connect remotely.

2, authorized user, you want root to use password to connect from any host to MySQL server grant all privileges on *.* to ' root ' @ '% ' identified by ' admin123 ' with GRANT OPTION; Flush privileges; If you want to allow user root to connect from IP to 192.168.1.104 host to MySQL server GRANT all privileges on *.* to ' myuser ' @ ' 192.168.1.104 ' identified by ' Admin123 ' with GRANT OPTION; Flush privileges;

Router extranet access MySQL database

1. The following conditions are met

Public IP regardless of dynamic or static static better dynamic if trouble can use DDNS services such as peanut shells

2. Open port

Whether you are routing in or dialing into a routing need to do 3306-port mapping in the router dial-up broadband requires 3306-port access in the firewall. Can be tested with telnet command

3.MYSQL User rights (more important here)

When installing MySQL is root default is the only local access permission localhost can be changed at installation time to the last step of remote TelePresence installation There is a checkbox to tick this is the version of Windows if the Linux version with the command plus permissions

If you create a new user, you must have% remote permissions to

4 test

Test mysql-h (IP address)-u username-P (password) in the command line if the mysql> appears