Connection to remote database error 2003 solution __ Database

Source: Internet
Author: User
mysql the default profile of the database My.cnf (Linux) bind-address defaults to 127.0.0.1, so even if you create a user that can remote access, 
You also can not use the mysql-h command to access, if the access will have problems, because at this time MySQL only accept localhost, so need to put bind-address shielding. MY.CNF is generally under/etc/mysql, if the locate MY.CNF lookup is not used, the MY.CNF profile before the modification is: MY.CNF profile code before modification # Instead of skip-networking the Defaul 
"T is" now "listen Only" # localhost which is more compatible and isn't less secure. bind-address = 127.0.0.1 # Instead of skip-networking ' The default is ' now ' to ' listen Only ' # localhost which is-more co
Mpatible and is not less secure. Bind-address = 127.0.0.1 What we need to do is block this bind-address code, after shielding code is: After shielding my.cnf configuration file code # Instead of skip-networking of the default 
are now to listen only on # localhost which are more compatible and are not less secure. #bind-address = 127.0.0.1 # Instead of skip-networking ' The default is ' now ' to ' listen Only ' # localhost which is-more C
Ompatible and is not less secure. #bind-address = 127.0.0.1 Now you can use the mysql-h command to do what you want to do. 

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.