MySQL Set remote access

MySQL remote access settings allow remote connection to local database.

1. Go to the local MySQL installation directory under bin , log in to MySQL,

2. Switch the database to the built-in database named "MySQL" and you can see a table named "User" below.

3. Execute SQL statement: select Host,user,password from User;

You can see all the user names, passwords and corresponding hosts that can be logged into this database. The default is local access only.

4. Modify settings for remote access.

Execute statement: GRANT all privileges on * * to ' root ' @ '% ' identified by '123456' with GRANT OPTION; (Note: The red place should be modified to the local database login password)

Execute statement: FLUSH privileges; (Refresh MySQL's system permissions related table)

Complete.

The settings are complete to see the effects. Root user access to host is no longer restricted. You can now complete the remote connection.

PS: If you do not have normal access at this time.

Note Modify the local firewall settings. Go to the Control Panel and locate the firewall settings---Control Panel \ All Control Panel items \ Windows firewall \ Allowed programs, check public.

Connect again and try again.