阿里云服务器 mysql 8.0.18安装（通用linux安装mysql）

首先，卸载mariadb。
rpm -qa | grep mariadb 命令查看

[root@al3 mysql]# rpm -qa | grep mariadb
mariadb-libs-5.5.60-1.el7_5.x86_64

rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64 卸载mariadb

安装 net-tools 工具，安装 perl，否则会出现缺少依赖的错误

[root@al3 mysql]# yum install net-tools
[root@al3 mysql]# yum install perl

在清华大学开源软件镜像站下载 mysql的rpm包

https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el7-x86_64/

其中el是Red Hat E nterprise L inux（EL）的缩写。

el6是Red Hat 6.x，CentOS 6.x和CloudLinux 6.x的下载。
el5是Red Hat 5.x，CentOS 5.x和CloudLinux 5.x的下载。
el7是Red Hat 7.x，CentOS 7.x和CloudLinux 7.x的下载。

x86_64代表 64位x86架构机器
全部mysql安装包如下
mysql-community-embedded-版本-1.el7.x86_64.rpm
mysql-community-libs-compat-版本-1.el7.x86_64.rpm
mysql-community-devel-版本-1.el7.x86_64.rpm
mysql-community-embedded-compat-版本-1.el7.x86_64.rpm
mysql-community-libs-版本.el7.x86_64.rpm
mysql-community-test-版本-1.el7.x86_64.rpm
mysql-community-common-版本-1.el7.x86_64.rpm
mysql-community-embedded-devel-版本-1.el7.x86_64.rpm
mysql-community-client-版本-1.el7.x86_64.rpm
mysql-community-server-版本-1.el7.x86_64.rpm

这里我只下载安装了主要组件
mysql-community-client-8.0.18-1.el7.x86_64.rpm
mysql-community-common-8.0.18-1.el7.x86_64.rpm
mysql-community-libs-8.0.18-1.el7.x86_64.rpm
mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm
mysql-community-server-8.0.18-1.el7.x86_64.rpm

下载命令

wget https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el7-x86_64/mysql-community-client-8.0.18-1.el7.x86_64.rpm
wget https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el7-x86_64/mysql-community-common-8.0.18-1.el7.x86_64.rpm
wget https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el7-x86_64/mysql-community-libs-8.0.18-1.el7.x86_64.rpm
wget https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el7-x86_64/mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm
wget https://mirrors.tuna.tsinghua.edu.cn/mysql/yum/mysql-8.0-community-el7-x86_64/mysql-community-server-8.0.18-1.el7.x86_64.rpm

安装顺序如下：

mysql-community-common
mysql-community-libs
mysql-community-libs-compat
mysql-community-client
mysql-community-server

安装命令

rpm -ivh mysql-community-common-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-8.0.18-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.18-1.el7.x86_64.rpm

报错与解决

[root@al3 mysql]# rpm -ivh mysql-community-libs-8.0.18-1.el7.x86_64.rpm 
warning: mysql-community-libs-8.0.18-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
	mariadb-libs is obsoleted by mysql-community-libs-8.0.18-1.el7.x86_64

卸载 mariadb即可

[root@al3 mysql]# rpm -ivh mysql-community-server-8.0.18-1.el7.x86_64.rpm
warning: mysql-community-server-8.0.18-1.el7.x86_64.rpm: Header V3 DSA/SHA1 Signature, key ID 5072e1f5: NOKEY
error: Failed dependencies:
	libaio.so.1()(64bit) is needed by mysql-community-server-8.0.18-1.el7.x86_64
	libaio.so.1(LIBAIO_0.1)(64bit) is needed by mysql-community-server-8.0.18-1.el7.x86_64
	libaio.so.1(LIBAIO_0.4)(64bit) is needed by mysql-community-server-8.0.18-1.el7.x86_64

yum install libaio 即可

启动mysql

[root@al3 mysql]# systemctl start mysqld

mysql临时密码
root@localhost：后面 ocscmsYd-5.e

[root@al3 mysql]# cat /var/log/mysqld.log 
2020-07-02T10:54:16.708766Z 0 [System] [MY-013169] [Server] /usr/sbin/mysqld (mysqld 8.0.18) initializing of server in progress as process 11413
2020-07-02T10:54:21.084341Z 5 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: ocscmsYd-5.e
2020-07-02T10:54:24.812239Z 0 [System] [MY-010116] [Server] /usr/sbin/mysqld (mysqld 8.0.18) starting as process 11462
2020-07-02T10:54:25.651940Z 0 [Warning] [MY-010068] [Server] CA certificate ca.pem is self signed.
2020-07-02T10:54:25.683193Z 0 [System] [MY-010931] [Server] /usr/sbin/mysqld: ready for connections. Version: '8.0.18'  socket: '/var/lib/mysql/mysql.sock'  port: 3306  MySQL Community Server - GPL.
2020-07-02T10:54:25.720554Z 0 [System] [MY-011323] [Server] X Plugin ready for connections. Socket: '/var/run/mysqld/mysqlx.sock' bind-address: '::' port: 33060

如果要使用简单密码要修改密码强度验证：

MySql取消密码强度验证功能
修改MySql配置文件（my.cnf）
一般情况下，MySql的配置文件 my.cnf 会在 /etc/ 目录下，如果没有，可以使用以下命令查找位置：
find / -name my.cnf
编辑配置文件：
vim /etc/my.cnf
在文件末尾添加以下内容：
plugin-load=validate_password.so
validate-password=OFF
保存退出
systemctl restart mysqld 重启mysql服务

使用默认密码登陆：
mysql -u root -p

进入命令行后,首先修改密码
alter user ‘root’@‘localhost’ identified by ‘Root!!2018’;

开启远程访问
https://blog.csdn.net/myembedded/article/details/100162451