centOS安装mysql5.7

1 .卸载自带的MariaDB

#查找本地已安装的MariaDB包
[root@CentOS01 ~]# rpm -qa | grep maria
mariadb-libs-5.5.68-1.el7.x86_64
#强制卸载
[root@CentOS01 ~]# rpm -e --nodeps  mariadb-libs

2.下载并安装MySQL官方的 Yum Repository

[root@CentOS01 ~]# wget -i -c http://dev.mysql.com/get/mysql57-community-release-el7-10.noarch.rpm

3.安装mysql

[root@CentOS01 ~]# yum -y install mysql57-community-release-el7-10.noarch.rpm
#导入MySQL GPG最新密钥，然后安装MySQL服务器
[root@CentOS01 ~]# rpm --import https://repo.mysql.com/RPM-GPG-KEY-mysql-2022
[root@CentOS01 ~]# yum -y install mysql-community-server
#启动MySQL并设置开机自启动
[root@CentOS01 ~]# systemctl start mysqld
[root@CentOS01 ~]# systemctl enable mysqld

4.获取初始密码

[root@CentOS01 ~]# grep "password" /var/log/mysqld.log
2022-05-04T14:54:15.761959Z 1 [Note] A temporary password is generated for root@localhost: liWoIam<!0/5

5.连接数据库

[root@CentOS01 ~]# mysql -uroot -p

6.修改新密码

mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password';
mysql> flush privileges;

7.开启MySQL远程访问

#创建一个admin远程账户
mysql> grant all on *.* to admin@'%' identified by '123456' with grant option;
mysql> flush privileges;

#打开3306端口
[root@CentOS01 ~]# firewall-cmd --permanent --add-port=3306/tcp
success
[root@CentOS01 ~]# firewall-cmd --reload
success

8.常用操作

#显示数据库列表
show databases;
#创建、删除数据库
create database 数据库名;
drop database 数据库名;
#显示库中的数据表
use mysql;
show tables;
#显示数据表结构
describe 数据表名;