How to enable Navicat with remote accessing database Back

• By default, server will only allow local accessing mysql server, which will cause the problem of Navicat connection.

Solution

i. Configure the mysql of your server

# vim /etc/mysql/my.cnf

[mysqld]
# ...
# add comment for bind-address and add skip-networking after it.
# bind-adress    = 127.0.0.1
# skip-networking

ii. Store and restart the service

service mysql restart

iii. Allow access with IP 10.10.50.127

GRANT ALL PRIVILEGES ON *.* TO 'root'@'10.10.50.127' IDENTIFIED BY "password" WITH GRANT OPTION;
FLUSH PRIVILEGES;

iv. Allow access with different IP

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY "password" WITH GRANT OPTION;
FLUSH PRIVILEGES;