MySQL remote connection cannot be enabled

1. Change the table. Use MySQL management tools, such as sqlyog Enterprise It may be that your account is not allowed to log on remotely, but only on localhost. At this time, you only need the computer on localhost.Use MySQL management toolsAfter logging on to MySQL, change the "host" entry in the "user" table in the "MySQL" database to "%" from "localhost" 2. Authorization method. A:If you want the MySQL account myuser to use the password mypassword to connect to the MySQL server from any host, enter: Grant all privileges on *. *'Myuser' @ '%'Identified by 'mypassword' with grant option; If the above command has not yet worked, use the following command! 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 *. *'Myuser' @ '192. 168.1.3'Identified by 'mypassword' with grant option;