centos7如何远程连接Navicat数据库? àì夳堔傛蜴生んèń 2024-03-26 16:28 13阅读 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
还没有评论,来说两句吧...