You cannot link to a database configuration on a Linxu system by using the Remote Link database tool 1045

1. Connect the Linux system remotely to ensure that the Linux system is installed on the MySQL database. Log in to the database. Mysql-uroot-p (password).

2.

Create a user to connect remotely

GRANT all privileges on * * to ' itoffice ' @ ' percent ' identified by ' Itoffice ' with GRANT OPTION;

(The first itoffice represents the user name,% means that all computers can connect, you can set an IP address to run the connection, and the second itoffice represents a password).

3. Implementation of the flush privileges; order immediate effect

4. SELECT DISTINCT CONCAT (' User: ', user, ' ' @ ', host, '; ') as query from Mysql.user;

5.

Exit MySQL using the exit command

Then open vim/etc/mysql/my.cnf.

Will bind-address = 127.0.0.1

Set to Bind-address = 0.0.0.0 (device address)

Reboot (command below):

/etc/init.d/mysql stop

/etc/init.d/mysql start

6., show global variables like ' port ';

7. Set the Navicat connection.

You cannot link to a database configuration on a Linxu system by using the Remote Link database tool 1045