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
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
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
7.At this time, you can verify whether you can access the synchronization by testing the creation of the library table file
Refresh the corresponding database table of Navicat
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