centos7如何远程连接Navicat数据库？

àì夳堔傛蜴生んèń 2024-03-26 16:28 80阅读 0赞

1、登录centos7，启动mysql服务

\[root@localhost ~\]\# systemctl start mysqld  
![a95943b8d8a44d9dbc730f834e740d8b.png][]

2、设置mysql服务开机自启

\[root@localhost ~\]\# systemctl enable mysqld  
\[root@localhost ~\]\# systemctl daemon-reload

![baac4c9c1245427895bd66eecda013f9.png][]

3、查看mysql服务状态

![84df1f29506943dcb99cda7f771d0716.png][]

4、若未更改初始密码，若已更改初始密码可以省略这一步。

1）查看初始密码：\[root@localhost local\]\# cat /var/log/mysqld.log | grep password

![331733df4766475e854eff1b1f22cba7.png][] 2）使用初始密码登录

\[root@localhost local\]\# mysql -u root -p

Enter password:（初始密码输入时是不显示的，直接输入密码就行）

![c65ad6a59ca346c5ac6e5873d15df4bc.png][]

3）修改初始密码：mysql> alter user 'root'@'localhost' identified by '123456';

用户名：'root'@'localhost'

密码：123456

![9054317db75045948730818bfa4de213.png][]

5、虚拟机上选择桥接网络，勾选复制物理网络连接状态

![b1fd254aa7a04064b2f66a2fcd40e571.png][]

6、查看你此时的电脑ip地址

\[root@localhost ~\]\# ip addr

![4a01ed9463534c6ab59a11547c984c55.png][]

7、输入ip、账号和密码即可

![f2e877d6ae66462fa243b20718efc562.png][]

8、只有是在同一网段的用户，让他们也输入这个ip地址也可以正常访问你的数据库。

![675733a15ea94bcea031af80c651871e.png][]

注意：每次centos7重启时，需要查看下ip地址是否变动了。若变动了，需要通知访问该数据库的用户改成最新的ip地址。也可以让运维把ip地址设置成固定ip。

希望对你有所帮助，谢谢~

[a95943b8d8a44d9dbc730f834e740d8b.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/b94afd0f97e54b59b8afd0cdec1d7d08.png
[baac4c9c1245427895bd66eecda013f9.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/5145a3ef53944075a30a0868dd3f5495.png
[84df1f29506943dcb99cda7f771d0716.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/51af8e1c93784eee8e6699171492df78.png
[331733df4766475e854eff1b1f22cba7.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/df32f92d93bf45c9b2f27c8c4f6ea6b0.png
[c65ad6a59ca346c5ac6e5873d15df4bc.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/86b30fb203194408bfed92f05670401b.png
[9054317db75045948730818bfa4de213.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/3f556d61e6e84f579320f2babd12e005.png
[b1fd254aa7a04064b2f66a2fcd40e571.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/b0d466e9b6664619b9574d75c6d45f1a.png
[4a01ed9463534c6ab59a11547c984c55.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/ac02d50acf14415c8f599886857f6261.png
[f2e877d6ae66462fa243b20718efc562.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/78dbc6bd1f4048bfa86d3765a045f846.png
[675733a15ea94bcea031af80c651871e.png]: https://image.dandelioncloud.cn/pgy_files/images/2024/03/26/7d2643e193de4dd8aeae7929237621e6.png