MySQL Telnet authorization

1. Change the table method.

Please use MySQL management tools such as: SQLyog Enterprise

It may be that your account is not allowed to log on remotely, only on localhost. This time, as long as the computer in localhost using the MySQL management tool to log in to MySQL, the "MySQL" Database in the "User" table "host" item, from "localhost" renamed "%"

2. Authorization law.

A: If you want the MySQL account myuser to connect to the MySQL server using the password mypassword from any host, then enter it at the MySQL command line:
GRANT all privileges on * * to ' myuser ' @ ' percent ' identified by ' MyPassword ' with GRANT OPTION;

If the above command has not worked, then use the following command, must be successful!

if you want to allow MySQL account myuser to connect to the MySQL server from the IP 192.168.1.3 host and use MyPassword as the password, enter it at the MySQL command line: GRANT all privileges on * * to ' myuser ' @ ' 192.168.1.3 ' identified by ' MyPassword ' with GRANT OPTION;

MySQL Telnet authorization