1. 安装包准备
将安装包和 JDBC 驱动上传到/opt/software,共计 6 个
01_mysql-community-common-5.7.16-1.el7.x86_64.rpm
02_mysql-community-libs-5.7.16-1.el7.x86_64.rpm
03_mysql-community-libs-compat-5.7.16-1.el7.x86_64.rpm
04_mysql-community-client-5.7.16-1.el7.x86_64.rpm
05_mysql-community-server-5.7.16-1.el7.x86_64.rpm
mysql-connector-java-5.1.27-bin.jar虚拟机卸载自带的 Mysql-libs
rpm -qa | grep -i -E mysql\|mariadb | xargs -n1 sudo rpm -e --nodeps阿里云服务器安装
sudo yum remove mysql-libs
sudo yum install libaio
sudo yum -y install autoconf2. 安装MySQL
1.安装MySQL依赖
[@hadoop102 software]$ sudo rpm -ivh 01_mysql-community-common-5.7.16-1.el7.x86_64.rpm
[@hadoop102 software]$ sudo rpm -ivh 02_mysql-community-libs-5.7.16-1.el7.x86_64.rpm
[@hadoop102 software]$ sudo rpm -ivh 03_mysql-community-libs-compat-5.7.16-1.el7.x86_64.rpm2. 安装mysql-client
[@hadoop102 software]$ sudo rpm -ivh 04_mysql-community-client-5.7.16-1.el7.x86_64.rpm3.安装mysql-server
[@hadoop102 software]$ sudo rpm -ivh 05_mysql-community-server-5.7.16-1.el7.x86_64.rpm4. 启动MySQL
[@hadoop102 software]$ sudo systemctl start mysqld5. 查看MySQL密码
[@hadoop102 software]$ sudo cat /var/log/mysqld.log | grep password3. 配置MySQL
配置只要是root用户 + 密码,在任何主机上都能登录MySQL数据库。
1. 用刚刚查到的密码进入MySQL(如果报错,给密码加单引号)
[@hadoop102 software]$ mysql -uroot -p'password'2.设置复杂密码(由于MySQL密码策略,此密码必须足够复杂)
mysql> set password=password("1022DSAF515.");3. 更改MySQL密码策略
mysql> set global validate_password_length=4;
mysql> set global validate_password_policy=0;4.设置简单好记的密码
mysql> set password=password("000000");5. 进入MySQL库
mysql> use mysql6. 修改user表,把Host表内容修改为%
mysql> update user set host="%" where user="root";7. 刷新
mysql> flush privileges;