centos6.6中安装mysql 5.7.23

1.Linux版本

 cat /etc/issue

2.下载mysql包，本次安装的是5.7.23

 https://dev.mysql.com/downloads/mysql/5.6.html#downloads

 

3.解压到/usr/local/目录下

tar -zxvf /home/omc/mysql-5.7.23-linux-glibc2.12-x86_64.tar.gz -C /usr/local/

 

4. 改名

mv mysql-5.7.23-linux-glibc2.12-x86_64/ mysql/

 

5. 创建data目录

mkdir mysql/data

6. 创建用户和用户组

groupadd mysql

useradd -r -s /sbin/nologin -g mysql mysql -d /usr/local/mysql

chown -R mysql.mysql /usr/local/mysql/

7.初始化mysql

7.1 初始化mysql

bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/usr/local/mysql/data

7.2 初始化报错，依赖缺失

yum -y install libaio

yum -y install numactl

7.3 配置163镜像

无法连接镜像，下载163镜像CentOS6-Base-163.repo，将其copy到/etc/yum.repos.d/中

mv /etc/yum.repos.d/CentOS-Base.repo /etc/yum.repos.d/CentOS-Base.repo.bak

回到7.2安装libaio和numactl

初始化成功后，最后为root密码

8. 配置文件

8.1 my.cnf修改

vi /etc/my.cnf

socket=/tmp/mysql.sock

[mysqld]

 

basedir=/usr/local/mysql

datadir=/usr/local/mysql/data

socket=/tmp/mysql.sock

character_set_server=utf8

user=mysql

port = 3306

# Disabling symbolic-links is recommended to prevent assorted security risks

symbolic-links=0

 

[mysqld_safe]

log-error=/usr/local/mysql/data/error.log

pid-file=/usr/local/mysql/data/mysql.pid

tmpdir = /tmp

 

 

8.2把mysql放到本地系统服务中

vi /etc/init.d/mysqld

 

9.启动mysql

service mysqld start

登录mysql,输入密码（操作7中最后一步）

bin/mysql -uroot -p

重置root密码

SET PASSWORD FOR 'root'@localhost=PASSWORD('123456'); 

更改为可远程连接访问

update user set host='%' where user='root' limit 1;

flush privileges;

10 .使用windows的SQLyog客户端来连接