1130 ' 192.168.1.3 ' is This
Workaround:1。 Change the table method. It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer on the localhost, log in to MySQL, change"MySQL"In the database."User"of the table"Host"Items, from"localhost"Renamed"%"MySQL-U root-pvmwaremysql>use mysql;mysql>update userSetHost ='%' whereuser ='Root';mysql>SelectHost, user fromuser;2. Authorization law. For example, if you want to myuser use MyPassword to connect to a MySQL server from any host. GRANT all Privileges on*. * To'MyUser'@'%'Identified by'MyPassword'With GRANT OPTION, if you want to allow the user to MyUser from IP to 192.168.1the. 3 host connects to the MySQL server and uses mypassword as the password GRANT all privileges on*. * To'MyUser'@'192.168.1.3'identified by'MyPassword'With GRANT OPTION;
MySQL does not have a workaround from a remote connection