centos6.3安装mysql5.7_Centos下安装Mysql5.7

升级，建议完成后重启

yum -y update

卸载已安装的Mysql

yum -y remove mysql-libs

安装依赖

yum -y install numactl-libs

注意：版本号后面的el7表示Red Hat Enterprise Linux 7 / Oracle Linux 7，修改为6即表Red Hat Enterprise Linux 6 / Oracle Linux 6

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-common-5.7.19-1.el7.x86_64.rpm

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-libs-5.7.19-1.el7.x86_64.rpm

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-libs-compat-5.7.19-1.el7.x86_64.rpm

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-client-5.7.19-1.el7.x86_64.rpm

wget https://cdn.mysql.com//Downloads/MySQL-5.7/mysql-community-server-5.7.19-1.el7.x86_64.rpm

安装

rpm -ivh mysql-community-common-5.7.19-1.el7.x86_64.rpm --nosignature

rpm-ivh mysql-community-libs-5.7.19-1.el7.x86_64.rpm --nosignature

rpm-ivh mysql-community-libs-compat-5.7.19-1.el7.x86_64.rpm --nosignature

rpm-ivh mysql-community-client-5.7.19-1.el7.x86_64.rpm --nosignature

rpm-ivh mysql-community-server-5.7.19-1.el7.x86_64.rpm --nosignature

启动

service mysqld start

查看初始密码

grep "password" /var/log/mysqld.log

登录mysql后立即修改密码

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

此处可能提示密码不符合要求，输入下列语句后重新修改密码即可

set global validate_password_policy=0;

还可以使用下面的语句来强制用户使用SSL

alter user 'test'@'%' REQUIRE SSL;

设置开机自启

chkconfig mysqld on

修改mysql配置

vim /etc/my.cnf

修改为

[client]

port=3306

default-character-set=utf8mb4

[mysql]

default-character-set=utf8mb4

[mysqld]

port=3306

character-set-client-handshake=0

character-set-server=utf8mb4

collation-server=utf8mb4_unicode_ci

default-time-zone='+8:00'

lower_case_table_names=1

log-bin=mysql-bin

binlog-format=ROW

server_id=1