centos6.9安装mysql5.7

在centos 6.9 上rpm安装MysqL

环境：

Linux:CentOS release 6.9 64bit

MysqL: mysq-5.7.18

1、在/home创建MysqL目录，下载如下四个软件包

http://mirrors.sohu.com/MysqL/MysqL-5.7/

wget http://mirrors.sohu.com/MysqL/MysqL-5.7/MysqL-community-client-5.7.18-1.el6.x86_64.rpm

wget http://mirrors.sohu.com/MysqL/MysqL-5.7/MysqL-community-common-5.7.18-1.el6.x86_64.rpm

wget http://mirrors.sohu.com/MysqL/MysqL-5.7/MysqL-community-libs-5.7.18-1.el6.x86_64.rpm

wget http://mirrors.sohu.com/MysqL/MysqL-5.7/MysqL-community-server-5.7.18-1.el6.x86_64.rpm

2、检查MysqL rpm相关的包是否安装并去除

[root@centos-6 MysqL]# rpm -qa | grep -i MysqL

MysqL-libs-5.1.73-8.el6_8.x86_64

[root@centos-6 MysqL]# rpm -e MysqL-libs-5.1.73-8.el6_8.x86_64

error: Failed dependencies:

libMysqLclient.so.16()(64bit) is needed by (installed) postfix-2:2.6.6-8.el6.x86_64

libMysqLclient.so.16(libMysqLclient_16)(64bit) is needed by (installed) postfix-2:2.6.6-8.el6.x86_64

MysqL-libs is needed by (installed) postfix-2:2.6.6-8.el6.x86_64

[root@centos-6 MysqL]#

将依赖包一并删除

[root@centos-6 MysqL]# yum remove -y MysqL-libs

再次查询是否删除干净

3、同时安装这四个rpm包

rpm -ivh MysqL-community-client-5.7.18-1.el6.x86_64.rpm MysqL-community-common-5.7.18-1.el6.x86_64.rpm MysqL-community-libs-5.7.18-1.el6.x86_64.rpm MysqL-community-server-5.7.18-1.el6.x86_64.rpm

4、出现缺少依赖包解决方式

[root@centos-6 home]# rpm -ivh MysqL-community-client-5.7.18-1.el6.x86_64.rpm MysqL-community-common-5.7.18-1.el6.x86_64.rpm MysqL-community-libs-5.7.18-1.el6.x86_64.rpm MysqL-community-server-5.7.18-1.el6.x86_64.rpm

warning: MysqL-community-client-5.7.18-1.el6.x86_64.rpm: Header V3 DSA/SHA1 Signature,key ID 5072e1f5: NOKEY

libnuma.so.1()(64bit) is needed by MysqL-community-server-5.7.18-1.el6.x86_64

libnuma.so.1(libnuma_1.1)(64bit) is needed by MysqL-community-server-5.7.18-1.el6.x86_64

libnuma.so.1(libnuma_1.2)(64bit) is needed by MysqL-community-server-5.7.18-1.el6.x86_64

[root@centos-6 home]# yum install -y numactl

service MysqLd stop

MysqLd_safe --skip-grant-tables &

MysqL -uroot -p

>use MysqL;

> update user set authentication_string=PASSWORD("root") where user="root";

update user set host='%' where user="root";

FLUSH PRIVILEGES;

service MysqLd restart

MysqL -uroot -proot

SET PASSWORD = PASSWORD('root');