Solution MySQL does not allow remote access to the method

Source: Internet
Author: User
Tags exit flush log connect mysql access
Solution MySQL does not allow remote access to the method

Workaround:

1. Change Table method.

Your account may not be allowed to log in remotely, only in localhost. This time as long as the computer in localhost, login mysql, change the "MySQL" Database in the "User" table in the "host" item, from "localhost" renamed "%"

Mysql-u root-pvmwaremysql>use MySQL;

Mysql>update User Set host = '% ' where user = ' root ';

Mysql>select host, user from user;

2. Authorization law.

For example, you want to myuser use MyPassword to connect to a MySQL server from any host.

Grant all privileges in *.* to ' myuser ' @ '% ' identified by ' MyPassword ' with GRANT OPTION;

FLUSH privileges;

If you want to allow the user to connect to the MySQL server from the IP-192.168.1.6 host, and use MyPassword as the password myuser

Grant all privileges in *.* to ' myuser ' @ ' 192.168.1.3 ' identified by ' MyPassword ' with GRANT OPTION;

FLUSH privileges;

If you want to allow users to MyUser from IP-192.168.1.6 hosts to the MySQL server's DK database and use MyPassword as a password

Grant all privileges in dk.* to ' myuser ' @ ' 192.168.1.3 ' identified by ' MyPassword ' with GRANT OPTION;

FLUSH privileges;

I used the first method, just started to find no, online check, less execution of a statement Mysql>flush Rivileges to make the changes effective. That's it.

Another method, but I did not personally tried, on the csdn.net look for, you can look.

Running on a MySQL-installed machine:

1, d:\mysql\bin\>mysql-h localhost-u root//This should be able to access the MySQL server

2. Mysql>grant all privileges in *.* to ' root ' @ '% ' with GRANT OPTION//give any host access to data

3. Mysql>flush Privileges//amendment effective

4. Mysql>exit//exit MySQL server

This allows you to log in as root on any other host!



Related Article

Alibaba Cloud 10 Year Anniversary

With You, We are Shaping a Digital World, 2009-2019

Learn more >

Apsara Conference 2019

The Rise of Data Intelligence, September 25th - 27th, Hangzhou, China

Learn more >

Alibaba Cloud Free Trial

Learn and experience the power of Alibaba Cloud with a free trial worth $300-1200 USD

Learn more >

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.