• notice
  • Congratulations on the launch of the Sought Tech site

Successfully realized Navicat access to MySQL database installed in Linux

Successfully realized Navicat access to MySQL database installed in Linux

1.Install MySQL and check if you are logged in normally

Successfully realized Navicat access to MySQL database installed in Linux

2.Enter mysql database to configure remote connection

#将所有数据库的所有表(*.*)的所有权限(all privileges),授予通过任何ip(%)访问的root用户,密码为123123,如果要限制只有某台机器可以访问,将其换成相应的IP即可
mysql> grant all privileges on *.*  to 'root'@'%' identified by ' ';

mysql> flush privileges #刷新

3.Exit mysql and restart mysql

4.Open 3306 port so that it can be accessed by remote connection

Install iptables-services

yum install -y iptables-services

Open port 3306

vim  /etc/sysconfig/iptables #编辑
#添加下面命令开启3306端口
-A INPUT -p tcp -m state --state NEW -m tcp --dport 3306 -j ACCEPT

Successfully realized Navicat access to MySQL database installed in Linux

5.Restart the firewall and set it to self-start after booting

service iptables restart            #重启防火墙
systemctl enable iptables.service   #设置开机自动启动

6.Test whether Navicat can connect to the database normally

Successfully realized Navicat access to MySQL database installed in Linux

7.At this time, you can verify whether you can access the synchronization by testing the creation of the library table file

Successfully realized Navicat access to MySQL database installed in Linux

Refresh the corresponding database table of Navicat

Successfully realized Navicat access to MySQL database installed in Linux


Tags

Technical otaku

Sought technology together

Related Topic

1 Comments

author

order atorvastatin for sale & lt;a href="https://lipiws.top/"& gt;lipitor 10mg drug& lt;/a& gt; buy atorvastatin 40mg for sale

Cpfokn

2024-03-07

Leave a Reply

+