CentOS环境下的MYSQL8安装

MySQL 安装

参考连接：https://www.cnblogs.com/jasonx1an/p/16690866.html

下载

下载网址：https://dev.mysql.com/downloads/mysql/

卸载 mariadb

1. 查看 mariadb

   rpm -qa|grep mariadb
   

   

2. 卸载 mariadb

   rpm -e mariadb-libs-5.5.68-1.el7.x86_64 --nodeps
   

3. 再次查看

   rpm -qa|grep mariadb
   

安装

将软件安装包上传到linux根目录下

创建文件夹

mkdir /usr/local/mysql

解压

tar -xvf mysql-8.0.33-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql

安装

cd /usr/local/mysql

rpm -ivh mysql-community-common-8.0.33-1.el7.x86_64.rpm --nodeps --force

rpm -ivh mysql-community-libs-8.0.33-1.el7.x86_64.rpm --nodeps --force

rpm -ivh mysql-community-client-8.0.33-1.el7.x86_64.rpm --nodeps --force

rpm -ivh mysql-community-server-8.0.33-1.el7.x86_64.rpm --nodeps --force

查看mysql安装包

rpm -qa | grep mysql

初始化数据库

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

设置用户

生成数据库临时密码

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

进入数据库，输入临时密码

mysql -uroot -p

设置密码

ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '1234';

退出，使用设置的新密码登录

exit;
mysql -u root -p 1234

设置远程连接

create user 'root'@'%' identified with mysql_native_password by '1234';

grant all privileges on *.* to 'root'@'%' with grant option;

flush privileges;

注意：需要关闭防火墙

通过连接工具连接