5. CentOS 7.6 Mysql 8的安装

一、卸载mariadb数据库

#查看mariadb数据库
rpm -qa | grep mariadb

#卸载mariadb数据库: rpm -e --nodeps  mariadb文件名, 如：
rpm -e --nodeps mariadb-libs-5.5.60-1.el7_5.x86_64

二、卸载已安装的mysql

 #查看 mysql 数据库
rpm -qa | grep -i mysql 

#卸载 mysql 数据库
rpm -e mysql文件名
   
# 如果有关联文件，不能直接卸载。可以用一下命令强制卸载：rpm -e --nodeps mysql文件名）
rm /etc/my.cnf 

 #删除etc目录下的my.cnf文件
rm /etc/my.cnf 

三、安装libaio依赖并重启

yum install -y libaio
reboot

四、从MySQL官网上下载最新rpm包到/usr/local目录下


五、解压mysql的tar包

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

#解压完成后，会得到若干个rpm包
#mysql-community-server-8.0.15-1.el7.x86_64.rpm
#mysql-community-client-8.0.15-1.el7.x86_64.rpm
#mysql-community-common-8.0.15-1.el7.x86_64.rpm
#mysql-community-libs-8.0.15-1.el7.x86_64.rpm
#mysql-community-devel-8.0.15-1.el7.x86_64.rpm
#mysql-community-test-8.0.15-1.el7.x86_64.rpm
#mysql-community-libs-compat-8.0.15-1.el7.x86_64.rpm
#mysql-community-embedded-compat-8.0.15-1.el7.x86_64.rpm

六、按照下面的顺序依次安装rpm包

rpm -ivh mysql-community-common-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-8.0.15-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.15-1.el7.x86_64.rpm

七、修改MySQL的my.cnf配置文件

vim /etc/my.cnf
#修改如下
[mysqld]
port=3306
max_connections=4000

default-authentication-plugin=mysql_native_password

datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock

log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid

八、启动mysql服务

systemctl start mysqld.service

九、得到初始密码

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

十、利用初始密码修改数据库密码

#登录数据库
mysql -uroot -p+OAZhk/yo8ty

#降低密码策略
SET GLOBAL validate_password.policy=0;

#设置新密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'YOUR_PASSWORD';

#提交
flush privileges;

#退出并重启重启mysql
systemctl restart mysqld.service 

十一、添加远程访问权限

#登录数据库
mysql -uroot -pYOUR_PASSWORD

mysql> use mysql;
mysql> update user set host='%' where user='root';
mysql> select host,user from user;
mysql> flush privileges;
mysql> exit;

#退出并重启重启mysql
systemctl restart mysqld.service 

附: navicat无限试用方法
https://www.cnblogs.com/sunyangCoder/p/9060454.html