Use sqlyog to connect to ubuntu mysql server Error solution, sqlyogubuntu

Use sqlyog to connect to ubuntu mysql server Error solution, sqlyogubuntu

Currently, many services are deployed in the linux environment, but in the development stage, the use of windows Remote connection tools is intuitive, which is more friendly to developers.

The following is a problem I encountered when I used mysql-server in ubuntu16.04 and the solution to this problem.

1. Error 2003

ERROR 2003: Can't connect to MySQL server on 'localhost' (0)

Because the bind-address Configuration address (default) in the mysql configuration file is 127.0.0.1

Vim/etc/mysql. conf. d/mysqld. cnf

Change bind-address to 0.0.0.0

Restart mysql:/etc/init. d/mysql restart

2. Error 1130

ERROR 1130: Host 192.168.3.100 is not allowed to connect to this MySQL server

I have adopted the following solutions

Mysql-u root-p

Mysql> use mysql;

Mysql> select 'host' from user where user = 'root ';

Mysql> update user set host = '%' where user = 'root ';

Mysql> flush privileges;

Mysql> select 'host' from user where user = 'root ';

Then restart the mysql service.