Install settings on Windows remote Access

Source: Internet
Author: User
Tags windows remote access

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

Related Article

Contact Us

The content source of this page is from Internet, which doesn't represent Alibaba Cloud's opinion; products and services mentioned on that page don't have any relationship with Alibaba Cloud. If the content of the page makes you feel confusing, please write us an email, we will handle the problem within 5 days after receiving your email.

If you find any instances of plagiarism from the community, please send an email to: info-contact@alibabacloud.com and provide relevant evidence. A staff member will contact you within 5 working days.

A Free Trial That Lets You Build Big!

Start building with 50+ products and up to 12 months usage for Elastic Compute Service

  • Sales Support

    1 on 1 presale consultation

  • After-Sales Support

    24/7 Technical Support 6 Free Tickets per Quarter Faster Response

  • Alibaba Cloud offers highly flexible support services tailored to meet your exact needs.