1 下载 Download
下载操作可能会很慢,所以最好用下载软件下载
download operation may be slow, so it's best to use download software to download.
# 1.1 下载repo
#Download repo
wget https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
# 1.2 下载软件安装集合
#Download software installation collection
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar
2 解压 Decompression
tar xvf mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar
3 安装 Install
# 安装时可能遇到mariadb的干扰,删掉即可
# you should to delete some mariadb component
yum remove -y mariadb*
# 安装时请务必按照以下顺序安装
# Install mysql should be in the following order
rpm -ivh mysql-community-common-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.19-1.el7.x86_64.rpm
4 配置
# 4.1 首先启动一下mysql
#First start mysql server
systemctl start mysqld
# 4.2 然后会在日志中生成一个非常复杂的密码,下面的指令可以拿到该密码
#Then mysql will make a very complex password in mysql log, and following commad can get the password.
grep 'temporary password' /var/log/mysqld.log
# 4.3 利用该秘密登录mysql,请注意,新版的mysql如果利用配置文件绕过密码登录,修改密码时会产生各种问题
# use this password to login mysql server. In the new version of MySQL, if you want to uses the configuration file to bypass the password login, there will be various problems when changing the password
mysql -u root -p
#4.4 mysql修改密码等操作
# Change password and other operation
SHOW VARIABLES LIKE 'validate_password%';
set global validate_password.policy=0;
set global validate_password.length=4;
alter user 'root'@'localhost' identified by '123456';
use mysql;
update user set host = '%' where user = 'root';
flush privileges;
5 mysql-workbanch
如果想更方便的操作,装个这个挺不错的
If you want more convenient operation, it's very good to install this one
wget https://dev.mysql.com/get/Downloads/MySQLGUITools/mysql-workbench-community-8.0.19-1.el7.x86_64.rpm
rpm -ivh mysql-workbench-community-8.0.19-1.el7.x86_64.rpm