Navicat连接阿里云远程MySQL5.7数据库

navicat连接远程数据库

步骤一:放行3306端口

步骤二:在宝塔中新建数据库

步骤三:任务管理器打开本地mysql服务

步骤四:Navicat新建连接

步骤五:点击连接测试

步骤六:可能出现的错误 如果是第一次搞这些的话,权限可能会没有打开

解决方案:在mysql安装目录的bin文件夹下,启动命令行,按以下步骤就能解决

步骤七:小结 如果还有其他错误,那还可能是防火墙等问题。 如果没有问题,其他步骤和正常的Navicat操作一致 ···········································································································································································································································································有问题可以聊聊,别喷我

经验分享 程序员 微信小程序 职场和发展