MySql remote connection cannot be enabled solution 1. Change the table. Use the mysql management tool. For example, SQLyog Enterprise may not allow remote login from your account, but only on localhost. At this time, you only need to use the mysql management tool on the computer of localhost to log on to mysql and change the "host" entry in the "user" table in the "mysql" database, from "localhost" to "%" 2. authorization method. A: If you want mysql account myuser to use the password mypassword to connect to the mysql server from any host, enter grant all privileges on * in the mySQL command line *. * TO 'myuser' @ '%' identified by 'mypassword' with grant option; if the above command has not yet worked, use the following command, which must have been successful! If you want to allow the mysql account myuser to connect to the mysql server from the host whose ip address is 192.168.1.3 and use mypassword as the password, enter grant all privileges on * in the mySQL command line *. * TO 'myuser' @ '192. 168.1.3 'identified BY 'mypassword' with grant option;