linux原生安装mysql8.0.19

cd /usr/local

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

tar -xvf mysql-8.0.19-1.el7.x86_64.rpm-bundle.tar

检查是否默认安装了maiadb,有的话卸载

rpm -qa|grep mariadb

rpm -e --nodeps mariadb-libs

按以下顺序进行安装

解压后一共有8个安装包，依次执行rpm -ivh [安装包名称].rpm --nodeps --force命令安装。以下是我执行命令的顺序（安装了7个，测试包没有安装）

1、rpm -ivh mysql-community-common-8.0.19-1.el7.x86_64.rpm --nodeps --force

2、rpm -ivh mysql-community-libs-8.0.19-1.el7.x86_64.rpm --nodeps --force

3、rpm -ivh mysql-community-server-8.0.19-1.el7.x86_64.rpm --nodeps --force

4、rpm -ivh mysql-community-client-8.0.19-1.el7.x86_64.rpm --nodeps --force

5、rpm -ivh mysql-community-libs-compat-8.0.19-1.el7.x86_64.rpm --nodeps --force

6、rpm -ivh  mysql-community-embedded-compat-8.0.19-1.el7.x86_64.rpm --nodeps --force

7、rpm -ivh mysql-community-devel-8.0.19-1.el7.x86_64.rpm --nodeps --force

使用rpm -qa | grep mysql 查看已安装的mysql包

mysqld初始化

mysqld --initialize;
如果报错error while loading shared libraries: libaio.so.1: cannot open shared object file 则需要先执行
yum install -y libaio 安装libaio异步IO组件，然后初始化mysqld

启动mysqld

systemctl start mysqld.service
或者# service mysqld restart
如果启动报错“Job for mysqld.service failed because the control process exited with error code” 可以尝试删掉初始化信息# rm -rf /var/lib/mysql 然后启动（此处我没有验证，是不是可以跳过第六步直接启动）

查询临时密码凭证

cat /var/log/mysqld.log | grep password

进入mysql

mysql -u root -p

先修改临时凭证,后退出重新登录,修改密码难度,即可按需求进行设置

ALTER USER USER() identified by 'Root_12root';

重新登录,修改密码强度

 set global validate_password.policy=0;

 set global validate_password.length=1;

授权创建用户

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'xxx';

CREATE USER 'root'@'%' IDENTIFIED BY 'xxx'; 

ALTER USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'xxx';

grant all privileges on *.*  to  'root'@'%' ; 

flush privileges;