CentOS 7.3下安装MySQL 5.7

1、 下载

下载地址：
https://dev.mysql.com/downloads/mysql/

选择你需要安装的版本，这里我的电脑是CentOS7.3 64位

然后下载 RPM Bundle，这个是几个程序的合集包。

然后开始下载。。。。

2、 解压安装包

解压mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar

 #tar -xvf mysql-5.7.20-1.el7.x86_64.rpm-bundle.tar

mysql-community-client-5.7.20-1.el7.x86_64.rpm
mysql-community-common-5.7.20-1.el7.x86_64.rpm
mysql-community-devel-5.7.20-1.el7.x86_64.rpm
mysql-community-embedded-5.7.20-1.el7.x86_64.rpm
mysql-community-embedded-compat-5.7.20-1.el7.x86_64.rpm
mysql-community-embedded-devel-5.7.20-1.el7.x86_64.rpm
mysql-community-libs-5.7.20-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.20-1.el7.x86_64.rpm
mysql-community-minimal-debuginfo-5.7.20-1.el7.x86_64.rpm
mysql-community-server-5.7.20-1.el7.x86_64.rpm
mysql-community-server-minimal-5.7.20-1.el7.x86_64.rpm
mysql-community-test-5.7.20-1.el7.x86_64.rpm

#ls

-rw-r--r-- 1 7155 31415  25090196 Sep 14 23:44 mysql-community-client-5.7.20-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415    278300 Sep 14 23:44 mysql-community-common-5.7.20-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   3778120 Sep 14 23:44 mysql-community-devel-5.7.20-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  46238924 Sep 14 23:44 mysql-community-embedded-5.7.20-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  24077232 Sep 14 23:44 mysql-community-embedded-compat-5.7.20-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415 128440800 Sep 14 23:44 mysql-community-embedded-devel-5.7.20-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   2238604 Sep 14 23:44 mysql-community-libs-5.7.20-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415   2115892 Sep 14 23:44 mysql-community-libs-compat-5.7.20-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  55538708 Sep 14 23:44 mysql-community-minimal-debuginfo-5.7.20-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415 171597916 Sep 14 23:45 mysql-community-server-5.7.20-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415  15256460 Sep 14 23:45 mysql-community-server-minimal-5.7.20-1.el7.x86_64.rpm
-rw-r--r-- 1 7155 31415 118609776 Sep 14 23:45 mysql-community-test-5.7.20-1.el7.x86_64.rpm

3、安装

卸载已安装的mysql-libs

# rpm -qa | grep -i mysql
mysql-libs-5.1.73-8.el6_8.x86_64

#yum remove mysql-libs

安装

 rpm -ivh  mysql-community-common-5.7.20-1.el7.x86_64.rpm
 rpm -ivh  mysql-community-libs-5.7.20-1.el7.x86_64.rpm
 rpm -ivh  mysql-community-libs-compat-5.7.20-1.el7.x86_64.rpm
 rpm -ivh  mysql-community-client-5.7.20-1.el7.x86_64.rpm
 rpm -ivh  mysql-community-server-5.7.20-1.el7.x86_64.rpm
 rpm -ivh  mysql-community-devel-5.7.20-1.el7.x86_64.rpm 

MySQL 的配置文件位于：/etc/my.cnf ，根据需求修改配置
默认的datadir=/var/lib/mysql

启动mysql

# systemctl start mysqld

4、初始化

这种方式安装好后，会在mysqld.log文件中自动生成一个密码，执行看一下吧：

# cat /var/log/mysqld.log | grep password
 2017-05-13T05:39:44.497086Z 1 [Note] A temporary password is generated for root@localhost: pKsO:Jin<4f%

密码就是这么复杂，复制吧，不然手输还容易出错。

登陆：

#mysql -u root -p
Enter password:pKsO:Jin<4f%

mysql>

输入初始密码后，就可以登录了；
登录后需要重置密码，如果不重置，则不让操作

mysql> show databases;
ERROR 1820 (HY000): You must SET PASSWORD before executing this statement 

这里可以直接使用命令修改root用户密码

SET PASSWORD = PASSWORD('passwd');

5、创建用户

登录

# mysql -u root -p 
Enter password: 
mysql>

创建数据库，指定编码utf-8：

mysql> CREATE DATABASE db182915 DEFAULT CHARACTER SET utf8 COLLATE utf8_general_ci;

添加用户 test：

mysql> GRANT ALL PRIVILEGES ON db182915.* TO 'test'@'192.168.%' IDENTIFIED BY 'test123#' WITH GRANT OPTION;
mysql> flush privileges;