1、下载并上传MySQL rpm安装包
下载地址:https://dev.mysql.com/downloads/mysql/
使用xftp上传MySQLrpm安装包
(关于如何使用xshell、xftp请自行搜索)
2、检测本地是否有MySQL已存在的包
rpm -qa | grep mysql
若查询出文件,用一下指令删除
rpm -e --nodeps 查询出的文件名
3、解压安装包
tar -xvf mysql-5.7.33-1.el7.x86_64.rpm-bundle.tar -C /root/workstation/soft
-目标文件夹:以 /root/workstation/soft 为例
4、查询并卸载的Mariadb
rpm -qa | grep mariadb
rpm -e --nodeps 查询出的文件名
5、安装
rpm -ivh mysql-community-common-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-devel-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-compat-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.33-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.33-1.el7.x86_64.rpm
若出现报错如下:
安装numactl,输入一下命令再重新安装即可
yum -y install numactl
6、启动服务
查看mysql服务是否启动
service mysqld status
启动服务:
systemctl start mysqld
7、查询临时密码
grep "password" /var/log/mysqld.log
8、登录MySQL
mysql -u roor -p?3pcNyGpPa0z
9、修改密码及更改密码长度及策略
设置密码策略为LOW,此策略只检查密码的长度
set global validate_password_policy=LOW;
设置密码最小长度
set global validate_password_length=6;
修改mysql的root用户,本地登陆的密码为123456
ALTER USER 'root'@'localhost' IDENTIFIED BY '123456';
10、开启mysql的远程连接权限
grant all privileges on *.* to 'root'@'%' identified by '123456' with grant option;
flush privileges;
11、Navicat连接MySQL数据库
再Navicat中:文件->新建连接->MySQL…
成功连接
12、其他相关指令
systemctl start mysqld.service //启动MySQL服务
systemctl stop mysqld.service //关闭MySQL服务
systemctl restart mysqld.service //重启MySQL服务
systemctl status mysqld.service //查看MySQL状态