Host is not allowed to connect to this mysql server

原因確認:

sudo i

mysql

>select user,host from mysql.user;

User権限確認:

+---------+------------+

| user     | host       |

+---------+------------+

| root     | localhost |
|            | 127.0.0.1 |

+---------+------------+

sudo vim /etc/mysql/my.cnf
# bind-address = 127.0.0.1

User権限:
GRANT ALL PRIVILEGES ON *.* TO user@'192.168.%' IDENTIFIED BY 'password' WITH GRANT OPTION;