Linux上安装MySQL(亲测详细实用版)

淡淡的烟草味﹌ 2023-06-17 10:57 35阅读 0赞

## **目录** ##

一:上传安装包

二:MySQL的安装

1:卸载Linux上自带的MySQL

2:解压安装包

3:安装服务端(64位,同Linux)

4:安装客户端

三:系统设置

四:常见连接报错处理

问题1::2003 Can't connect to mysql server on 192.168.27.141

问题2:1130: Host '192.168.27.1' is not allowed to connect to this mysql server

## 一:上传安装包 ##

安装包百度云下载地址

[https://pan.baidu.com/s/1KQGjdEPe\_Z6PLjfcugzIfA][https_pan.baidu.com_s_1KQGjdEPe_Z6PLjfcugzIfA]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70][]

## 二:MySQL的安装 ##

### 1:卸载Linux上自带的MySQL ###

rpm -qa | grep mysql

rpm -e --nodeps mysql-libs-5.1.71-1.el6.x86\_64

![20191128184949619.png][]

### 2:解压安装包 ###

tar -xvf MySQL-5.6.22-1.e16.i686.rpm-bundle.tar -C /training/MySQL5.25

tar -xvf MySQL-5.6.25-1.el6.x86\_64.rpm-bundle.tar -C /training/MySQL5.25

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 1][]

### 3:安装服务端(64位,同Linux) ###

rpm -ivh MySQL-server-5.6.25-1.el6.x86\_64.rpm

如果显示缺少依赖,需要安装依赖：

yum -y install libaio.so.1 libgcc\_s.so.1 libstdc++.so.6

### 4:安装客户端 ###

### 1: 安装rpm包 ###

rpm -ivh MySQL-client-5.6.25-1.el6.x86\_64.rpm

![20191128185209256.png][]

### 2:查看随机生成的密码 ###

cat /root/.mysql\_secret

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 2][]

### 3:以root用户登录 ###

注意:要启动MySQL服务后,才可以执行以下命令

service mysql start

mysql -u root -p

然后输出随机的密码 VOYRZhKAyrVCwpGl

### 4:设置密码 ###

set password=password('123456');

## 三:系统设置 ##

Mysql服务加入到系统服务并自动启动操作：

chkconfig --add mysql

自动启动：

chkconfig mysql on

查询列表,程序是否启动成功：

chkconfig

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 3][]

## 四:常见连接报错处理 ##

问题1::2003 Can't connect to mysql server on 192.168.27.141

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 4][]

解决方法:关闭防火墙

![20191128185507379.png][]

问题2:1130: Host '192.168.27.1' is not allowed to connect to this mysql server

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 5][]

解决方法:

原因是Linux上的mysql并没有开启远程访问方服务

1:给root用户的远程访问赋值,并设置密码为root

grant all privileges on \*.\* to 'root' @'%' identified by '你的root密码';

![20191128185531290.png][]

2:刷新权限

flush privileges;

![20191128185547533.png][]

3:防火墙打开3306端口

vi /etc/sysconfig/iptables

添加以下配置到该配置文件中

/sbin/iptables -I INPUT -p tcp --dport 3306 -j ACCEPT

/etc/rc.d/init.d/iptables save

/etc/init.d/iptables status

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 6][]

4:测试成功

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 7][]

[https_pan.baidu.com_s_1KQGjdEPe_Z6PLjfcugzIfA]: https://pan.baidu.com/s/1KQGjdEPe_Z6PLjfcugzIfA
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70]: https://img-blog.csdnimg.cn/20191128184901199.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz,size_16,color_FFFFFF,t_70
[20191128184949619.png]: https://img-blog.csdnimg.cn/20191128184949619.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 1]: https://img-blog.csdnimg.cn/20191128185154582.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz,size_16,color_FFFFFF,t_70
[20191128185209256.png]: https://img-blog.csdnimg.cn/20191128185209256.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 2]: https://img-blog.csdnimg.cn/2019112818540625.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 3]: https://img-blog.csdnimg.cn/20191128185440688.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 4]: https://img-blog.csdnimg.cn/20191128185451295.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz,size_16,color_FFFFFF,t_70
[20191128185507379.png]: https://img-blog.csdnimg.cn/20191128185507379.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 5]: https://img-blog.csdnimg.cn/20191128185519725.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz,size_16,color_FFFFFF,t_70
[20191128185531290.png]: https://img-blog.csdnimg.cn/20191128185531290.png
[20191128185547533.png]: https://img-blog.csdnimg.cn/20191128185547533.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 6]: https://img-blog.csdnimg.cn/20191128185556305.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz,size_16,color_FFFFFF,t_70
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz_size_16_color_FFFFFF_t_70 7]: https://img-blog.csdnimg.cn/20191128185610439.png?x-oss-process=image/watermark,type_ZmFuZ3poZW5naGVpdGk,shadow_10,text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3FxXzI2OTYzNDMz,size_16,color_FFFFFF,t_70