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
success
[root@CentOS01 ~]# firewall-cmd
success
8.常用操作
show databases;
create database 数据库名;
drop database 数据库名;
use mysql;
show tables;
describe 数据表名;