MySQL Remote Access

"Error 1130: Host '192. 168.1.3 'is not allowed to connect to this MySQL Server"
Solution: the host column in the User table indicates the computer name that the user can log on.

1. Change the table
On the computer of localhost, after logging on to MySQL, change the "host" item of the corresponding user in the "user" table in the "MySQL" database, and rename it "%" from "localhost ";
2. Authorize ----- Similarly, myuser logs in from any location
Grant all privileges on *. * To 'myuser' @ '%' identified by 'mypassword' with grant option;
----- Or, similarly, myuser can only log in from '192. 168.1.3'
Grant all privileges on *. * To 'myuser' @ '192. 168.1.3 'identified by 'mypassword' with grant option;

Posted onReading by ruima software Studio (...) Comment (...) EDIT favorites

Refresh comment refresh page Back to Top

Blog homepage blog news flash programmer recruitment Knowledge Base

Copyright 2013 ruima software studio powered by: blog Park template: Hujiang blog

Enter your search term
Submit a search form

Web
Rapidhorse.cnblogs.com
Www.rapidhorse.com