centos下安装mysql8

一、mysql下载地址

https://downloads.mysql.com/archives/community/

二、上传到centos的/opt/software下

三、解压

tar -xvf mysql-8.x.x-xxx.tar

四、卸载mariadb

4.1先查看下是否有安装

rpm -qa | grep mariadb

4.2强制下载

sudo rpm -e --nodeps mariadb-libs

五、安装

以8.0.30版本为例，安装顺序不能变！

sudo rpm -ivh mysql-community-common-8.0.30-1.el7.x86_64.rpm 
sudo rpm -ivh mysql-community-client-plugins-8.0.30-1.el7.x86_64.rpm 
sudo rpm -ivh mysql-community-libs-8.0.30-1.el7.x86_64.rpm 
sudo rpm -ivh mysql-community-client-8.0.30-1.el7.x86_64.rpm 
sudo rpm -ivh mysql-community-icu-data-files-8.0.30-1.el7.x86_64.rpm 
sudo rpm -ivh mysql-community-server-8.0.30-1.el7.x86_64.rpm 

六、初始化

sudo mysqld --initialize --console

如果需要忽略大小写，在上面语句中加上如下参数

--lower-case-table-names=1

七、给mysql用户访问/var/lib/mysql权限

sudo chown -R mysql:mysql /var/lib/mysql

八、启动mysqld服务

systemctl start mysqld

九、查看初始化时临时密码

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

复制冒号后面的密码

十、登录

mysql -u root -p

粘贴临时密码

十一、改密码

alter user 'root'@'localhost' identified by '自定义密码';

十二、修改root可以任意ip登录

update user set host = '%' where user = 'root';

十三、修改后刷新权限

flush privileges;