下载地址: 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
# 查看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
[hadoop@node05 ~]$ sudo yum -y install libaio perl
# 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
# 查看MySQL运行状态
[hadoop@node05 ~]$ sudo systemctl status mysqld
# 启动MySQL
[hadoop@node05 ~]$ sudo systemctl start mysqld
# 设置MySQL开机启动
[hadoop@node05 ~]$ sudo systemctl enable mysqld
# 1.查看初始密码
[hadoop@node05 ~]$ sudo cat /var/log/mysqld.log | grep password
2020-06-25T05:09:36.887062Z 1 [Note] A temporary password is generated for root@localhost: pIkHp?T4x2y
# 2.用初始密码登录本地的mysql
[hadoop@node05 ~]$ mysql -u root -p
Enter 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, 需要提供密码字典文件
# 设置远程连接
mysql> grant all privileges on *.* to 'root'@'%' identified by 'Love88me' with grant option;
# 刷新权限
mysql> flush privileges;
# 配置/etc/my.cnf里的[mysqld]下添加
character_set_server=utf8
max_allowed_packet = 500M
[hadoop@node05 ~]$ sudo systemctl restart mysqld
Navicat创建连接
成功连接
结束语这里只是讲解单机版的MySQL安装配置,主要是为了后面学习Hive时作为Hive的元数据库。在以后的博文中会有专门的文章介绍MySQL集群、优化、高可用、高并发。
,