TreeviewCopyright © aleen42 all right reserved, powered by aleen42
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;
As the plugin is integrated with a code management system like GitLab or GitHub, you may have to auth with your account before leaving comments around this article.
Notice: This plugin has used Cookie to store your token with an expiration.