Centos7.2安装Mysql5.6.39

1.从官网下载MySQL5.6.39压缩包

2.进行解压使用 

tar -zxvf MySQL-5.6.39-1.el7.x86_64.rpm-bundle.tar

3.解压出来有7个文件，需要安装只有3个分别是client、devel和server

rpm -ivh MySQL-client-5.6.39-1.el7.x86_64.rpm

rpm -ivh MySQL-devel-5.6.39-1.el7.x86_64.rpm 

rpm -ivh MySQL-server-5.6.39-1.el7.x86_64.rpm

4.复制my-default.cnf到/etc目录下

cp /usr/share/mysql/my-default.cnf /etc/my.cnf

5.初始化并运行数据库

/usr/bin/mysql_install_db

service mysql start

6.MySQL5.6.39安装完成后查看密码并修改

cat /root/.mysql_secret

mysql -u username -p password 

SET PASSWORD = PASSWORD('yourpassword');

7.允许远程登录

use mysql;

update user set host='%' where user='root' and host='localhost';

flush privileges;

exit;

8.设置开机启动

chkconfig mysql on

chkconfig --list | grep mysql

mysql           0:off   1:off   2:on    3:on    4:on    5:on    6:off

9.修改字符集

[client]   
port=3306  
default-character-set=utf8  
[mysqld]  
port=3306  
character_set_server=utf8  
character_set_client=utf8  
collation-server=utf8_general_ci  
#(注意linux下mysql安装完后是默认：表名区分大小写，列名不区分大小写； 0：区分大小写，1：不区分大小写)  
lower_case_table_names=1  
#(设置最大连接数，默认为 151，MySQL服务器允许的最大连接数16384; )  
max_connections=200
[mysql]  
default-character-set = utf8

other

（1）默认安装位置信息

/var/lib/mysql/            #数据库目录
/usr/share/mysql           #配置文件目录
/usr/bin                   #相关命令目录
/etc/init.d/mysql          #启动脚本

（2）安装server时报错

 libnuma.so.1()(64bit) is needed by MySQL-server-5.6.39-1.el7.x86_64.rpm
        libnuma.so.1(libnuma_1.1)(64bit) is needed by MySQL-server-5.6.39-1.el7.x86_64.rpm
        libnuma.so.1(libnuma_1.2)(64bit) is needed by MySQL-server-5.6.39-1.el7.x86_64.rpm

  执行yum install numactl  即可

也可以从https://download.youkuaiyun.com/download/dearfinance/10277348下载 点击打开链接