mysql8 安装

下载mysql8链接: https://pan.baidu.com/s/1BC9DEch_Uw8DQKJSej75Hg  密码: ta6n

tar -xvf mysql-8.0.27-1.el7.x86_64.rpm-bundle.tar
rpm -ivh mysql-community-client-8.0.27-1.el7.x86_64.rpm --nodeps --force						
rpm -ivh mysql-community-client-plugins-8.0.27-1.el7.x86_64.rpm --nodeps --force											
rpm -ivh mysql-community-common-8.0.27-1.el7.x86_64.rpm --nodeps --force												
rpm -ivh mysql-community-devel-8.0.27-1.el7.x86_64.rpm --nodeps --force																
rpm -ivh mysql-community-embedded-compat-8.0.27-1.el7.x86_64.rpm --nodeps --force																	
rpm -ivh mysql-community-libs-8.0.27-1.el7.x86_64.rpm --nodeps --force														
rpm -ivh mysql-community-libs-compat-8.0.27-1.el7.x86_64.rpm --nodeps --force																	
rpm -ivh mysql-community-server-8.0.27-1.el7.x86_64.rpm --nodeps --force																				
rpm -ivh mysql-community-test-8.0.27-1.el7.x86_64.rpm --nodeps --force								

mysqld --initialize;
chown mysql:mysql /var/lib/mysql -R;
systemctl start mysqld.service;
systemctl enable mysqld;

创建一个超级管用户'root'@'localhost‘。超级用户设置的密码被保存在错误日志文件中，可以通过以下命令查看：
shell> sudo grep 'temporary password' /var/log/mysqld.log
USE mysql;
CREATE USER 'root'@'%' IDENTIFIED WITH mysql_native_password BY 'root@123@CTL';
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'root@123@CTL';
GRANT ALL PRIVILEGES ON *.* TO 'root'@'%'  WITH GRANT OPTION;
FLUSH PRIVILEGES;
 
vi/etc/my.cnf
在[mysqld]下面加上一行 skip-grant-tables