[系统运维]centos7 - mysql 离线安装

一、前言
mysql版本：5.7.11
mysql官方下载地址：https://dev.mysql.com/downloads/mysql/
需要的安装包 ：
libaio-0.3.109-13.el7.x86_64.rpm
mysql-community-devel-5.7.22-1.el7.x86_64.rpm
mysql-connector-python-8.0.11-1.el7.x86_64.rpm
mysql-5722.tar.gz
mysql-community-libs-5.7.22-1.el7.x86_64.rpm
MySQL-python-1.2.5-1.el7.x86_64.rpm
mysql-community-client-5.7.22-1.el7.x86_64.rpm
mysql-community-libs-compat-5.7.22-1.el7.x86_64.rpm
net-tools-2.0-0.22.20131004git.el7.x86_64.rpm
mysql-community-common-5.7.22-1.el7.x86_64.rpm
mysql-community-server-5.7.22-1.el7.x86_64.rpm

二、安装

#查看系统版本
lsb_release
#查看系统位数
getconf LONG_BIT

#检查是否已有mysql 若已有，则需要先删除旧的
#查看mysql依赖
rpm -qa | grep mysql
#删除mysql依赖
rpm -e --nodeps `rpm -qa | grep mysql`

#安装mysql 
#安装命令
sudo rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm mysql-community-libs-5.7.22-1.el7.x86_64.rpm mysql-community-server-5.7.22-1.el7.x86_64.rpm mysql-community-client-5.7.22-1.el7.x86_64.rpm mysql-community-devel-5.7.22-1.el7.x86_64.rpm mysql-connector-python-8.0.11-1.el7.x86_64.rpm libaio-0.3.109-13.el7.x86_64.rpm
#启动服务
sudo service mysqld start 


#配置mysql
#获取mysql登录root的初始密码
grep "temporary password" /var/log/mysqld.log
#利用初始密码登录
mysql -u root -p
#改密
alter user 'root'@'localhost' identified by 'Td@123456'
#更改用户登录ip为所有ip（%表示不做限制，或者改成固定ip，限制登录ip）
grant all privileges on *.* to 'root'@'%' identified by 'Td@123456' with grant option ;
#刷新配置设置
flush privileges;


#如果密码复杂度不够，需要设置mysql密码参数
set global validate_password_policy=0;
set global validate_password_length=5;

三、问题解决

问题一：安装mysql 过程中报错

#执行如下命令时报错
rpm -ivh mysql-community-common-5.7.22-1.el7.x86_64.rpm mysql-community-libs-5.7.22-1.el7.x86_64.rpm mysql-community-server-5.7.22-1.el7.x86_64.rpm mysql-community-client-5.7.22-1.el7.x86_64.rpm mysql-community-devel-5.7.22-1.el7.x86_64.rpm mysql-connector-python-8.0.11-1.el7.x86_64.rpm MySQL-python-1.2.5-1.el7.x86_64.rpm libaio-0.3.109-13.el7.x86_64.rpm

#报错信息：
警告：mysql-community-common-5.7.22-1.el7.x86_64.rpm: 头V3 DSA/SHA1 Signature, 密钥 ID 5072e1f5: NOKEY
错误：依赖检测失败：

mariadb-libs 被 mysql-community-libs-5.7.22-1.el7.x86_64 取代
mariadb-devel 被 mysql-community-devel-5.7.22-1.el7.x86_64 取代

问题二：密码丢失

#文件添加 skip-grant-tables
sudo vi /etc/my.cnf
service mysqld restart
mysql -u root -p
update mysql.user set authentication_string=password('Td@123456') where user='root' ;

#文件注掉 skip-grant-tables
sudo vi /etc/my.cnf
service mysqld restart