centos7.5安装mysql5.6_CentOS7.5二进制安装MySQL-5.6.40

安装依赖

yum install -y gcc gcc-c++ automake autoconf

yum -y install cmake bison-devel ncurses-devel libaio-devel

mysql-5.6.40二进制包下载地址

https://downloads.mysql.com/archives/get/file/mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz

1.下载MySQL-5.6.40二进制包

[[email protected] ~]# wget https://downloads.mysql.com/archives/get/file/mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz

2.解压缩mysql二进制包到/usr/local

[[email protected] ~]# tar xf mysql-5.6.40-linux-glibc2.12-x86_64.tar.gz -C /usr/local

3.修改名称、做软连接

[[email protected] ~]# cd /usr/local

[[email protected] local]# mv mysql-5.6.40-linux-glibc2.12-x86_64 mysql-5.6.40

[[email protected] local]# ln -s mysql-5.6.40 mysql

4.创建mysql用户和组

//创建mysql组

[[email protected] local]# groupadd mysql

//创建mysql用户

[[email protected] local]# useradd -g mysql -s /bin/false mysql

5.拷贝主配置文件

//备份/etc/my.cnf

[[email protected] local]# mv /etc/my.cnf /etc/my.cnf.old

//拷贝主配置文件

[[email protected] ~]# cp /usr/local/mysql/support-files/my-default.cnf /etc/my.cnf

6.拷贝启动脚本

[[email protected] ~]# cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

7.初始化mysql

//进入/usr/local/mysql/scripts

[[email protected] ~]# cd /usr/local/mysql/scripts

//初始化前安装依赖包

[[email protected] scripts]# yum -y install autoconf

//初始化mysql

[[email protected] scripts]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

--user #指定mysql用户

--basedir #指定mysql安装目录

--datadir #指定mysql数据目录

初始化报错

[[email protected] scripts]# ./mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

FATAL ERROR: please install the following Perl modules before executing ./mysql_install_db:

Data::Dumper

原因：缺少autoconf依赖包

解决方法

[[email protected] scripts]# yum -y install autoconf

8.添加mysql命令环境变量

//导出mysql命令环境变量

[[email protected] scripts]# echo "export PATH=/usr/local/mysql/bin:$PATH" > /etc/profile.d/mysql.sh

//使配置生效

[[email protected] scripts]# source /etc/profile

9.配置systemd管理mysql

[[email protected] scripts]# vim /etc/systemd/system/mysqld.service

[Unit]

Description=MySQL Server

Documentation=man:mysqld(8)

Documentation=http://dev.mysql.com/doc/refman/en/using-systemd.html

After=network.target

After=syslog.target

[Install]

WantedBy=multi-user.target

[Service]

User=mysql

Group=mysql

ExecStart=/usr/local/mysql/bin/mysqld --defaults-file=/etc/my.cnf

LimitNOFILE = 5000

10.启动mysql、检查启动

//启动mysql

[[email protected] scripts]# systemctl start mysqld ; systemctl enable mysqld

[[email protected] scripts]# netstat -ntpl | grep 3306

tcp6 0 0 :::3306 :::* LISTEN 31349/mysqld

11.进入mysql并设置密码

//设置mysql密码

mysql> set password=password('123');

Query OK, 0 rows affected (0.00 sec)

mysql> flush privileges;

Query OK, 0 rows affected (0.01 sec)