MySQL can connect with localhost, but can not use IP connection problem, LAN 192.168.*.* cannot connect MySQL

Source: Internet
Author: User

The reason is that the permission is not opened

1. The command line enters MySQL (assuming root user's password is also root) Mysql–uroot–proot 2. Use MySQL database using MySQL; 3. Grant all privileges on * * to ' root ' @ '% ' identified by ' root ', or grant all privileges on * * to ' root ' @ '% ' IdentiFi ED by ' password ' with GRANT OPTION;

where * * means all libraries. All tables, ' root ' @ '% ' identified by ' root ' the previous root is the username,% refers to all access IP, and the latter root means the password
This is certainly a rough man's empowerment method, a quiet woman should write her beautiful and specific, such as:

Grant all privileges the MDB.MTBL to ' beautiful ' @ ' 10.38.62.233 ' identified by ' woman ';

4. Refresh permissions (effective without restarting) flush privileges;

I heard that the actual implementation is to put the user and Privilige table things into memory.

5. Restart the MySQL service

MySQL can connect with localhost, but can not use IP connection problem, LAN 192.168.*.* cannot connect MySQL

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.