查询卸载系统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';