Centos7.6安装Mysql8.0.17

查询卸载系统mariadb

rpm -qa|grep mariadb
rpm -e --nodeps  mariadb-libs-5.5.60-1.el7_5.x86_64
           

下载mysql

wget -c https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.17-1.el8.x86_64.rpm-bundle.tar
tar -xvf mysql-8.0.17-1.el8.x86_64.rpm-bundle.tar
yum install -y libaio.x86_64 libaio-devel.x86_64 openssl-devel.x86_64 openssl.x86_64  perl.x86_64 perl-devel.x86_64   perl-JSON.noarch  autoconf
           

按顺序安装

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

接着按顺序安装

rpm -ivh mysql-community-libs-compat-8.0.17-1.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.0.17-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.17-1.el7.x86_64.rpm
rpm -ivh mysql-community-test-8.0.17-1.el7.x86_64.rpm
           

启动mysql修改密码

mysqld --initialize --console
systemctl start mysqld
查找默认密码
cat /var/log/mysqld.log | grep password
mysql -uroot -p
alter user 'root'@'localhost' identified by  'yourpassword';
远程设置
use mysql;
update user set host='%' where user='root';
授权用户名的权限，赋予任何主机访问数据的权限
grant all privileges on *.* to 'root'@'%' with grant option;
           

如果客户端连接提示

Client does not support authen.....

mysql -uroot -p
use mysql
alter user 'root'@'%' identified with mysql_native_password by 'yourpassword';