一、下载MySQL
进入MySQL官网:https://www.mysql.com/
点击DOWNLOADS
滑到最下面有个社区版,点击进去
点击MySQL Community Server
点击Archives下载历史版本
选择自己需要的版本(CentOS7也可以用Red Hat的,这里选择MySQL5.7.25)
选择有Bundle的
下载完后上传到Linux服务器
二、正式安装
安装前先检查有没有mysql或者mariadb
rpm -qa | grep mysql
rpm -qa | grep mariadb
有就删掉
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
新建mysql文件夹,并解压mysql5.7
mkdir -p /usr/local/mysql
tar -xvf mysql-5.7.25-1.el7.x86_64.rpm-bundle.tar -C /usr/local/mysql/
安装顺序:
- mysql-community-common
- mysql-community-libs
- mysql-community-devel
- mysql-community-libs-compat
- mysql-community-client
- mysql-community-server
所以依次执行命令:
rpm -ivh mysql-community-common-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.25-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.25-1.el7.x86_64.rpm
yum install net-tools #安装server需要net-tools
rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm
若最后一个命令安装失败,则加强制安装的后缀:
rpm -ivh mysql-community-server-5.7.25-1.el7.x86_64.rpm --force --nodeps
三、验证安装成功
查看mysql状态
systemctl status mysqld
启动mysql
systemctl start mysqld
查看服务与进程
netstat -tunlp
ps -ef | grep mysql
MySQL已启动成功
四、MySQL基本设置
(1)设置开机启动
systemctl enable mysqld
(2)设置密码
查看临时密码
cat /var/log/mysqld.log | grep password
# 下面是输出结果,密码为#=rdmBh!<3KY
2022-08-20T14:31:07.931479Z 1 [Note] A temporary password is generated for root@localhost: #=rdmBh!<3KY
登录mysql
mysql -uroot -p
(然后输入临时密码)
设置密码最低长度
set global validate_password_length=4;
设置密码安全等级
set global validate_password_policy=LOW;
设置密码为123456
set password = password('123456');
开启权限
grant all on *.* to 'root'@'%'identified by '123456';
刷新权限
flush privileges;
使用Navicat连接成功