经验 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

再次查询是否删除干净

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

[root@centos-6 mysql]#

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

error: Failed dependencies:

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

5、mysql数据库设置

service mysqld stop

进入安全模式操作
mysqld_safe --skip-grant-tables &

mysql -uroot -p

>use mysql;

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

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

FLUSH PRIVILEGES;

exit;
退出安全模式
启动mysql
service mysqld restart
登录mysql
mysql -uroot -proot
第一次登录后必须重置密码，并且默认的安全策略中要求密码至少8位，同时包含大小写、数字和特殊字符
SET PASSWORD = PASSWORD("rootWJW@123456");

创建远程登录用户

use mysql;

GRANT ALL PRIVILEGES ON *.* TO test@"%" IDENTIFIED BY "rootABC@123456";

其中test为登录名，"%"表示任何主机都可以远程登录到该服务器上访问。如果要限制只有某台机器可以访问，将其换成相应的IP即可。

从mysql数据库的grant表中重新加载权限数据

FLUSH PRIVILEGES;

exit;

退出即可