linux 安装 MySQL

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_

1. 安装包准备

  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
  1. 虚拟机卸载自带的 Mysql-libs

 rpm -qa | grep -i -E mysql\|mariadb | xargs -n1 sudo rpm -e --nodeps
  1. 阿里云服务器安装

 sudo yum remove mysql-libs
 sudo yum install libaio
 sudo yum -y install autoconf

2. 安装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.rpm
2. 安装mysql-client
 [@hadoop102 software]$ sudo rpm -ivh 04_mysql-community-client-5.7.16-1.el7.x86_64.rpm
3.安装mysql-server
 [@hadoop102 software]$ sudo rpm -ivh 05_mysql-community-server-5.7.16-1.el7.x86_64.rpm
4. 启动MySQL
 [@hadoop102 software]$ sudo systemctl start mysqld
5. 查看MySQL密码
 [@hadoop102 software]$ sudo cat /var/log/mysqld.log | grep password

3. 配置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 mysql
6. 修改user表,把Host表内容修改为%
 mysql> update user set host="%" where user="root";
7. 刷新
 mysql> flush privileges;


LICENSED UNDER CC BY-NC-SA 4.0
Comment