mysql8.0安装命令与排错

#! /bin/bash
yum install wget -y
rpm -qa | grep mariadb
yum -y remove mariadb-*
rpm -qa | grep mysql
yum -y remove mysql-*
rpm -Uvh https://dev.mysql.com/get/mysql80-community-release-el7-3.noarch.rpm
yum --enablerepo=mysql80-community install mysql-community-server
service mysqld start
ervice mysqld status
grep "A temporary password" /var/log/mysqld.log
xk.Tca1Yiaq(

 

安装报错执行命令
gpg --export -a 3a79bd29 > 3a79bd29.asc
rpm --import 3a79bd29.asc
rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022

 

修改密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'qweasdzxc;
alter user 'root'@'localhost' identified by 'xk.Tca1Yiaq,';

开启远程访问

 

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