CentOs通过yum安装Mysql 5.7

记录

初始化以及安装

• Step1: 检测系统是否自带安装mysql

yum list installed | grep mysql

• Step2: 删除系统自带的mysql及其依赖

yum -y remove mysql.x86_64
yum -y remove mysql-libs.x86_64
yum -y remove mysql-server.x86_64
yum -y remove qt-mysql.x86_64

• Step3: 给CentOS添加rpm源，并且选择较新的源

wget dev.mysql.com/get/mysql-community-release-el6-5.noarch.rpm
yum localinstall mysql-community-release-el6-5.noarch.rpm
yum repolist all | grep mysql
yum-config-manager --disable mysql55-community
yum-config-manager --disable mysql56-community
yum-config-manager --enable mysql57-community-dmr
yum repolist enabled | grep mysql

• Step4:安装mysql 服务器

yum install mysql-community-server

初始化

service mysqld start

启动的时候会打印初始密码，通过grep password /var/log/mysqld.log查找初始密码

[root@virCentos mysql]# grep password /var/log/mysqld.log
2016-08-23T08:39:46.996250Z 1 [Note] A temporary password is generated for root@localhost: gy_wqal0cQsJ
2016-08-23T08:39:51.911861Z 0 [Note] Execution of init_file '/var/lib/mysql/install-validate-password-plugin.Sew6B5.sql' started.
2016-08-23T08:39:51.924512Z 0 [Note] Execution of init_file '/var/lib/mysql/install-validate-password-plugin.Sew6B5.sql' ended.

登录后修改密码，注意，密码长度8位，且包含数字、大小写字母、特殊符号

mysql> set password=password('Abcd1234%');
Query OK, 0 rows affected, 1 warning (0.00 sec)

修改密码策略(密码安全等级以及密码长度)

mysql> set global validate_password_policy=0;
Query OK, 0 rows affected (0.00 sec)
mysql> set global validate_password_length=4;
Query OK, 0 rows affected (0.00 sec)

查看密码是否有有效期限制，如果有，则改为永久

mysql> SHOW VARIABLES LIKE 'default_password%';
+---------------------------+-------+
| Variable_name             | Value |
+---------------------------+-------+
| default_password_lifetime | 0     |
+---------------------------+-------+
mysql> SET GLOBAL default_password_lifetime = 0;
Query OK, 0 rows affected (0.00 sec)

设置参数值

[mysqld]
default-storage-engine=MyISAM
character-set-server=gbk
collation-server=gbk_chinese_ci
[client]
default-character-set=gbk

变更数据文件位置

1 停止MySQL服务

service mysqld stop

2 创建新的数据目录

mkdir /home/mysqldata

3 拷贝数据目录到新目录（参数不要丢了，不然拷贝的路径用户权限会错误）

cp -R -p /var/lib/mysql /home/mysqldata

4 编辑/etc/my.cnf

#修改[mysqld]下面的datadir（如果没有，直接手动敲入）
datadir=/home/mysqldata/mysql/
#修改[client]和[mysqld]下面的socket，将其值修改为
socket=/home/mysqldata/mysql/mysql.sock

5 修改/etc/init.d/mysqld文件

#先备份，然后找到/var/lib/mysql，将其替换为新路径/home/mysqldata/mysql
cp /etc/init.d/mysqld /etc/init.d/mysqld.bak
sed -i 's/\/var\/lib\/mysql/\/home\/mysqldata\/mysql/g' /etc/init.d/mysqld

6 SELinux赋权

chcon -R -t mysqld_db_t /home/mysqldata/mysql

7 启动MySQL

service mysqld start

8 创建mysql.sock链接(mysql命令)

ln -s /home/mysqldata/mysql/mysql.sock /var/lib/mysql/mysql.sock

初始化

1. 登录数据库

mysql -uroot -p

1. 创建数据库

create database discuzx_mzh;

1. 新建用户

GRANT all privileges ON discuzx_mzh.* TO 'user'@'localhost' IDENTIFIED BY 'Abcd1234%' WITH GRANT OPTION;
flush privileges; --强制刷新内存授权表

参考文档

• CentOS 6.5/6.6 安装mysql 5.7 最完整版教程

• CentOS 7.2使用yum安装MYSQL 5.7.10

• 修改MySQL 5.7.9版本的root密码方法以及一些新变化整理

• CentOS 6.x下改变MySQL的datadir路径