mysql5.6下载和安装到centos7环境中的详细操作

拼搏现实的明天。 2022-02-05 07:07 139阅读 0赞

版本信息：

centos 7.4

mysql 5.6

连接Linux工具，xshell 6 ,xftp 6

### 一、下载mysql5.6安装包 ###

打开链接下载：[https://dev.mysql.com/downloads/mysql/][https_dev.mysql.com_downloads_mysql]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70][]

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 1][]

### 二、上传安装包到Linux环境中 ###

我这里使用的xftp将mysql安装包上传到Linux环境中。

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 2][]

### 三、安装mysql  ###

### 注意在安装过程中：不要配置 my.cnf文件,若/etc目录下存在my.cnf文件，则将该文件 重命名/删除 ###

1.首先centos7自带了mariadb的依赖，所以先将其删除

指令\# rpm -qa | grep -i mariadb![20190505102738518.png][]

2.移除mariadb的依赖

指令\# rpm -e --nodeps mariadb-libs-5.5.60-1.el7\_5.x86\_64  
![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 3][]

3.在centos7中找到mysql的安装包进行解压

指令\# tar -zxvf mysql-5.6.44-linux-glibc2.12-x86\_64.tar.gz

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 4][]

解压完成后指令\# mv ./mysql-5.6.44-linux-glibc2.12-x86\_64 /usr/local/mysql

4.**创建用户组和用户名**

[root@192-168-7-77 ~]# groupadd mysql
     [root@192-168-7-77 ~]# useradd -g mysql mysql -s /sbin/nologin

5.**进入mysql目录初始化数据**

[root@192-168-7-77 ~]# chown mysql.mysql -R /usr/local/mysql
    [root@192-168-7-77 ~]# cd /usr/local/mysql/scripts/
    [root@192-168-7-77 /usr/local/mysql/scripts]# ./mysql_install_db  --user=mysql  --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

** 6.配置环境变量**

指令\# vi /etc/profile

![20190505145620336.png][]

7.**启动MySQL，并设置开机自启**

[root@192-168-7-77 ~]# cp /usr/local/mysql/support-files/mysql.server /etc/rc.d/init.d/mysqld
     [root@192-168-7-77 ~]# chkconfig --add mysqld
     [root@192-168-7-77 ~]# chkconfig mysqld on
     [root@192-168-7-77 ~]# /etc/init.d/mysqld start

8.**设置数据库登录密码**

**此处设置的密码是 123456**

[root@192-168-7-77 ~]# mysqladmin -uroot password '123456'

**9.登录数据库**

[root@192-168-7-77 ~]# mysql -uroot -p'123456'

**10.设置远程连接**

**首先：**

GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'IDENTIFIED BY 'password' WITH GRANT OPTION;

再执行：

FLUSH PRIVILEGES;

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 5][]

开放防火墙端口：

执行指令开发8080端口   \# firewall-cmd --permanent --zone=public --add-port=3306/tcp

执行 \# firewall-cmd --reload使最新的防火墙设置规则生效(可以使用firewall-cmd --list-ports命令查看所有开放的端口)

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 6][]

远程连接测试：

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 7][]

[https_dev.mysql.com_downloads_mysql]: https://dev.mysql.com/downloads/mysql/
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70]: /images/20220205/e15fdf9c4e2d445dab1ec1b0bd7a6c77.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 1]: /images/20220205/879783ae40da40a4a4e91f5d97c31ffb.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 2]: /images/20220205/ee06f43df6bd419f96938aacb8e98590.png
[20190505102738518.png]: /images/20220205/739410ba187b45ffb1fb2824a8a300c5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 3]: /images/20220205/f6cc4493a21a499f9f17c812c95659c5.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 4]: /images/20220205/9a8b1639fb864f6fb6e286522f0e504c.png
[20190505145620336.png]: /images/20220205/955ff40f64974c20b146546d6817d21e.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 5]: /images/20220205/ddfd1526d4fa420bbaae7324dd7df241.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 6]: /images/20220205/62411d6b41ed478cbbe5cfb97403aaf9.png
[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L3N1cHJlemhlbmc_size_16_color_FFFFFF_t_70 7]: /images/20220205/32ada1bc1211450bbae4dff71794b564.png