Centos7中安装MySQL5.7记录

由于时不时会安装MySQL数据库，在大数据hive的学习中，也需要更换元数据Metastore存储数据库Derby为MySQL，下面记录下在Centos7中安装MySQL，并开启MySQL数据库的远程连接，本文参考文末博文和老王，主要方便自己查看用。

启动Centos7，切换root用户

在Centos7中默认安装MariaDB，这个是MySQL的分支，但为了方便使用，需要在root用户下，在系统中安装MySQL，而且安装完成之后可以直接覆盖掉原始的MariaDB。切换Derby为MySQL的主要原因是Derby是单线程的，MySQL却可以支持多个会话，在元数据的使用方面，显然存储在后者更有实际意义。

下载安装MySQL官方的yum源

使用root用户在Centos7服务器的/kkb/soft路径下执行以下命令。

# 切换安装目录
cd /kkb/soft/
# 安装
yum -y install wget
# 以下三条命令一起执行
# -i代表可以下载多个文件，-c代表可以断点续传
wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm
# 直接安装，-y代表无需手动点YES确认
yum -y install mysql57-community-release-el7-10.noarch.rpm
yum -y install mysql-community-server

安装完成后就会覆盖掉之前的mariadb。

mysql数据库的设置

首先启动MySQL。

# 查看mysql启动状态
systemctl status mysqld.service
# 执行以下命令启动mysql服务
systemctl start mysqld.service

当MySQL显示active状态，说明已经开始正常运行，要想进入MySQL还得先找出此时root用户下自动生成的密码，通过如下命令可以在日志文件中找出，使用临时密码，进入mysql客户端，然后更改密码。

# 在日志文件中查找password关键字
grep "password" /var/log/mysqld.log

以下是操作记录。

# 执行以下命令启动mysql服务
[root@node01 /kkb/install]# systemctl start mysqld.service
You have new mail in /var/spool/mail/root
# 查看mysql启动状态
[root@node01 /kkb/install]# systemctl status mysqld.service
● mysqld.service - MySQL Server
   Loaded: loaded (/usr/lib/systemd/system/mysqld.service; enabled; vendor preset: disabled)
   Active: active (running) since Mon 2019-10-14 20:45:30 CST; 13s ago
     Docs: man:mysqld(8)
           http://dev.mysql.com/doc/refman/en/using-systemd.html
  Process: 5024 ExecStart=/usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid $MYSQLD_OPTS (code=exited, status=0/SUCCESS)
  Process: 4974 ExecStartPre=/usr/bin/mysqld_pre_systemd (code=exited, status=0/SUCCESS)
 Main PID: 5028 (mysqld)
   CGroup: /system.slice/mysqld.service
           └─5028 /usr/sbin/mysqld --daemonize --pid-file=/var/run/mysqld/mysqld.pid

Oct 14 20:45:25 node01 systemd[1]: Starting MySQL Server...
Oct 14 20:45:30 node01 systemd[1]: Started MySQL Server.
# 查看自动生成的密码
[root@node01 /kkb/install]# grep "password" /var/log/mysqld.log
# 复制临时密码
2019-10-14T12:45:27.671407Z 1 [Note] A temporary password is generated for root@localhost: dkeDtqF)O1*E
You have new mail in /var/spool/mail/root
# 使用临时密码登录
[root@node01 /kkb/install]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 2
Server version: 5.7.28

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.
# 密码校验策略只校验密码长度，只要长度跟validate_password_length一样即可
mysql> set global validate_password_policy=LOW;
Query OK, 0 rows affected (0.00 sec)
# 设置密码长度
mysql> set global validate_password_length=6;
Query OK, 0 rows affected (0.00 sec)
# 设置密码，长度需要和上面设置的一致
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '2688';
ERROR 1819 (HY000): Your password does not satisfy the current policy requirements
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
Query OK, 0 rows affected (0.00 sec)
# 开启mysql的远程连接权限
mysql> grant all privileges  on  *.* to 'root'@'%' identified by '123456' with grant option;
Query OK, 0 rows affected, 1 warning (0.00 sec)
# 刷新权限
mysql> flush privileges;
Query OK, 0 rows affected (0.01 sec)

mysql> exit
Bye
You have new mail in /var/spool/mail/root
# 使用新密码登录
[root@node01 /kkb/install]# mysql -uroot -p
Enter password:
Welcome to the MySQL monitor.  Commands end with ; or g.
Your MySQL connection id is 3
Server version: 5.7.28 MySQL Community Server (GPL)

Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.

mysql> show databases;
+--------------------+
| Database           |
+--------------------+
| information_schema |
| mysql              |
| performance_schema |
| sys                |
+--------------------+
4 rows in set (0.00 sec)

mysql的卸载

上面我在MySQL当中已经安装好了5.7版本的MySQL服务，如果以后不需要MySQL了，或者MySQL安装失败了需要重新安装，那么我们就可以把MySQL给卸载掉。

step1:停止mysql服务并卸载rpm的包。

# 停止MySQL服务
systemctl stop mysqld.service
# 查询所有安装的mysql
rpm -qa | grep -i mysql 
yum list install mysql*
# yum卸载
yum remove mysql mysql-server mysql-libs compat-mysql51
yum remove mysql-community-release
# rpm卸载，--nodeps就是不验证文件的依赖关系，直接删除
rpm -e --nodeps mysql57-community-release-el7-10.noarch mysql-community-common-5.7.27-1.el7.x86_64 

step2：删除mysql残留文件夹。

whereis mysql 
rm -rf /usr/share/mysql/
find / -name mysql
rm -rf /var/lib/mysql/
rm -rf /root/.mysql_history

参考博文

（1）https://www.cnblogs.com/youngchaolin/p/11713079.html rpm和yum

（2）https://blog.csdn.net/wltsysterm/article/details/79649484 mysql密码校验策略