ubuntu阿里云服务器上安装mysql并开启远程连接
1.先用以下指令安装mysql的服务器和客服端
> apt-get install mysql-server mysql-client
> apt-get install libmysqld-dev
2.安装完成后,修改mysqld.cnf文件
> vim /etc/mysql/mysql.conf.d/mysqld.cnf
![在这里插入图片描述](https://img-blog.csdnimg.cn/20210406003220163.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDYwOTY1Ng==,size_16,color_FFFFFF,t_70)
3.重启服务器
> reboot
4.在阿里云服务器上开启3306端口
![在这里插入图片描述](https://img-blog.csdnimg.cn/2021040600362154.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDYwOTY1Ng==,size_16,color_FFFFFF,t_70)
5.接下来就可以用navicat工具连接mysql了。
![在这里插入图片描述](https://img-blog.csdnimg.cn/20210406003922610.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3dlaXhpbl80NDYwOTY1Ng==,size_16,color_FFFFFF,t_70)