UbuntuServer16.04LTS中安装Mysql并配置远程访问

た入场券 2023-10-18 22:37 90阅读 0赞

## 场景 ##

Linux-安装 Ubuntu Server 16.04 X64（图文教程详细版）：  
[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/93790806][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_93790806]  
Linux-Ubuntu中使用apt进行软件的安装与卸载：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/95248991][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_95248991]

## 实现 ##

### 安装 ###

输入安装命令

apt-get install mysql-server

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70][]

然后会提示需要多少安装空间，是否继续，输入y，继续。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1][]

然后会提示输入root账户密码

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2][]

输完后回车，会再次确认密码

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 3][]

安装完成后，不知道Mysql的安装位置，输入：

whereis mysql

![20190730222120739.jpg][]

所以在usr/bin下有个mysql的可执行文件，usr/share下有个mysql的配置。

### 配置远程连接 ###

#### 修改配置文件 ####

进入到/etc/mysql/mysql.conf.d下

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 4][]

然后编辑配置文件，输入：

vi mysql.conf

找到绑定地址位置，如下：

![20190730222145544.jpg][]

这里默认只能本机访问，所以将其注释或者将其修改为0.0.0.0

![20190730222152179.jpg][]

关于编辑器的操作，参照如下

Linux-编辑器vim与nano的使用：

[https://blog.csdn.net/BADAO\_LIUMANG\_QIZHI/article/details/95241274][https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_95241274]

#### 重启mysql服务 ####

修改完配置文件后需要重启mysql服务，输入：

service mysql restart

#### ![20190730222204712.jpg][] ####

#### 授权 ####

登录root账户授权允许所有人连接

root账户登录

mysql -u root -p

输入root账户密码。

![2019073022221994.jpg][]

然后输入授权命令

grant all privileges on *.* to 'root'@'%' identified by '123456';

其中最后面是你的root账户密码。

授权成功后

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 5][]

### 配置连接 ###

这里使用Navicat连接。

新建mysql连接

![20190730222254999.png][]

其中主机就是服务器的ip,可在服务器上通过输入：

ifconfig

获取。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 6][]

连接成功

![20190730222310430.jpg][]

[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_93790806]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/93790806
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_95248991]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/95248991
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20190730222032423.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20190730222038331.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/20190730222058574.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20190730222106265.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[20190730222120739.jpg]: https://img-blog.csdnimg.cn/20190730222120739.jpg
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20190730222131181.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[20190730222145544.jpg]: https://img-blog.csdnimg.cn/20190730222145544.jpg
[20190730222152179.jpg]: https://img-blog.csdnimg.cn/20190730222152179.jpg
[https_blog.csdn.net_BADAO_LIUMANG_QIZHI_article_details_95241274]: https://blog.csdn.net/BADAO_LIUMANG_QIZHI/article/details/95241274
[20190730222204712.jpg]: https://img-blog.csdnimg.cn/20190730222204712.jpg
[2019073022221994.jpg]: https://img-blog.csdnimg.cn/2019073022221994.jpg
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20190730222249600.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[20190730222254999.png]: https://img-blog.csdnimg.cn/20190730222254999.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/2019073022230513.jpg?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L0JBREFPX0xJVU1BTkdfUUlaSEk=,size_16,color_FFFFFF,t_70
[20190730222310430.jpg]: https://img-blog.csdnimg.cn/20190730222310430.jpg