MySQL is installed on Windows, how to set up remote access, and the program to connect to the database:
Enter the installation directory such as: C:\Program files\mysql\mysql Server 5.7\bin
Open a command window under this directory
Input: mysql-u root-p Enter the password into the database
Log in to MySQL, and then enter:
Mysql>use MySQL;
Mysql>grant all privileges on * * to [e-mail protected] identified by ' 123456 ' with GRANT option;
Add a user root and authorize access via local machine (localhost), password "123456".
Mysql>grant all privileges on * * to [e-mail protected] "%" identified by ' 123456 ' with GRANT option;
Add a user root and authorize access that can originate from any other host (wildcard%). You can use this statement.
Then refresh database permissions
Mysql>flush privileges;
You can now connect to the MySQL database on this server by using any of the MySQL management tools on other machines.
Install settings on Windows remote Access