MySQL open remote link (2014.12.12)

Source: Internet
Author: User

MySQL default is to turn off remote links, only through the localhostAccess the local database if it is not local access you need to open MySQL remote connection; The basic steps are simple: 1. Go to MySQL

2. Run the following command (Yellow for command) in turn:mysql>Use MySQL;
mysql> select Host,user,password from user;
mysql> Update user set host= '% ' where user= ' root ';mysql> flush Privileges;mysql> quit;
3, through the CMD, into the MySQL installation directory, restart MySQL (bold for the installation directory, yellow for the command): D:\Program files\mysql-5.5.25\bin> net stop mysql The MySQL service is stopping.The MySQL service has stopped successfully. D:\Program files\mysql-5.5.25\bin> net start MySQLThe MySQL service is starting.The MySQL service has started successfully.
4. Go to MySQL and run the following command (yellow for the command, where YourPassword is replaced with your MySQL password):mysql> Grant all privileges on * * to ' root ' @ '% ' identified by 'YourPassword ' with GRANT option;mysql> flush Privileges;

to successfully open the MySQL remote link feature! (Note: I'm sure you can all see if the command is performing properly, so don't add the command when it's running ...) )Reference:http://jingyan.baidu.com/article/60ccbceb05804164cab1978c.html

From for notes (Wiz)

MySQL open remote link (2014.12.12)

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.