MySQL Settings Allow remote logins

1. Modify the Data sheet

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, the "MySQL" Database in the "User" table "Host" item, from "localhost" to "%",% means that all machines are allowed.

mysql> use MySQL

mysql> Update user set host= '% ' where user= ' root ';

2. Authorized rights

Allow any host to connect to the MySQL server using the "hzh1990" account and the "hzh1990" password.

Mysql> Grant all privileges on * * to ' hzh1990 ' @ '% ' identified by ' hzh1990 ' with GRANT OPTION;

3. Entry into force

mysql> FLUSH privileges;