centos7安装mysql教程详细二十四CentOS7安装配置MySQL

导读1.MySQL官网下载下载地址:https://dev.mysql.com/downloads/mysql/5.7.htmlMySQL官网2.SecureC....1.MySQL官网下载

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

MySQL官网

2.SecureCRT的SFTP上传

SFTP上传

3.解压安装包

[hadoop@node05 ~]$ tar -xf mysql-5.7.29-1.el7.x86_64.rpm-bundle.tar

4.卸载mariadb的依赖

# 查看mariadb依赖[hadoop@node05 ~]$ sudo rpm -qa|grep mariadb[sudo] password for hadoop: mariadb-libs-5.5.64-1.el7.x86_64# 卸载依赖[hadoop@node05 ~]$ sudo rpm -e --nodeps mariadb-libs-5.5.64-1.el7.x86_64

5.安装MySQL依赖

[hadoop@node05 ~]$ sudo yum -y install libaio perl

6.安装MySQL

# 1.安装common包[hadoop@node05 ~]$ sudo rpm -ivh mysql-community-common-5.7.29-1.el7.x86_64.rpm # 2.安装libs包[hadoop@node05 ~]$ sudo rpm -ivh mysql-community-libs-5.7.29-1.el7.x86_64.rpm # 3.安装client包[hadoop@node05 ~]$ sudo rpm -ivh mysql-community-client-5.7.29-1.el7.x86_64.rpm # 4.安装server包[hadoop@node05 ~]$ sudo rpm -ivh mysql-community-server-5.7.29-1.el7.x86_64.rpm

7.查看配置MySQL运行状态

# 查看MySQL运行状态[hadoop@node05 ~]$ sudo systemctl status mysqld# 启动MySQL[hadoop@node05 ~]$ sudo systemctl start mysqld# 设置MySQL开机启动[hadoop@node05 ~]$ sudo systemctl enable mysqld

8.修改MySQL初始密码

# 1.查看初始密码[hadoop@node05 ~]$ sudo cat /var/log/mysqld.log | grep password2020-06-25T05:09:36.887062Z 1 [Note] A temporary password is generated for root@localhost: pIkHp?T4x2y # 2.用初始密码登录本地的mysql[hadoop@node05 ~]$ mysql -u root -pEnter password: 【输入上步查看到初始密码】# 3.登录成功后修改本地root初始密码mysql> set password=password(您的新密码);ERROR 1819 (HY000): Your password does not satisfy the current policy requirements# 如果出现这个错误，说明你的密码案例策略太低# 此时有两种方法 (参考下面备注部分）# 1) 设置更强密码# 2）降低密码策略# 这里为了操作方便，我选择了第二种。mysql> set global validate_password_policy=0;

• MySQL密码案例策略

validate_password_policy配置： - 0: Low - 1: MEDIUM 默认是1，即MEDIUM，所以刚开始设置的密码必须符合长度，且必须含有数字，小写或大写字母，特殊字符。 - 2: Strong, 需要提供密码字典文件

9.开启MySQL远程连接

# 设置远程连接mysql> grant all privileges on *.* to root@% identified by Love88me with grant option;# 刷新权限mysql> flush privileges;

10.数据库字符集及相关配置

# 配置/etc/my.cnf里的[mysqld]下添加character_set_server=utf8max_allowed_packet = 500M

11.重启MySQL服务

[hadoop@node05 ~]$ sudo systemctl restart mysqld

12.Navicat远程测试

Navicat创建连接

成功连接

结束语

这里只是讲解单机版的MySQL安装配置，主要是为了后面学习Hive时作为Hive的元数据库。在以后的博文中会有专门的文章介绍MySQL集群、优化、高可用、高并发。