MySQL Open remote connection

The simplest way is to reconfigure the configuration file, and in the step of setting the password, tick allow remote connection . If not, you can try the following methods

1, change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change the "MySQL" Database in the "User" table "host", from "localhost" to "%"

SQL code

1. Mysql-u root-pvmwaremysql>use MySQL;
2. mysql>update user set host = '% ' where user = ' root ' ;
3. mysql>Select Host, user from user;

3. If you want to allow users to connect to the MySQL server myuser from the IP-192.168.1.6 host, and use MyPassword as the password

SQL code

1. GRANT  All Privileges on * * to ' myuser '@ ' 192.168.1.3 ' identified by
2. ' MyPassword '  with GRANT OPTION;
3. FLUSH privileges;

SQL code

1. grant  all   privileges   on  dk.*  to   @ ' 192.168.1.3 '  identified    Span style= "color: #7f0055;" >with   grant   option ;    
2. flush    privileges ;   

Note that the authorization must be flush privileges, otherwise it will not take effect immediately.

Another method:

Run on the machine where MySQL is installed:
1. d:\mysql\bin\>mysql-h Localhost-u Root
This should allow access to the MySQL server
2, Mysql>grant all privileges on * * to ' root ' @ '% ' with GRANT OPTION
Give any host access to data
3, Mysql>flush privileges
Changes take effect
4, Mysql>exit
Log out of MySQL server
This will allow you to log in as root on any other host!

MySQL Open remote connection