本文介绍使用rpm方式安装Mysql
1.下载安装包
Mysql下载链接:https://downloads.mysql.com/archives/community/
选择下载RPM Bundle,此压缩包包含了Mysql所有组件
卸载系统自带的mariadb
检查系统是否自带了mariadb,不卸载安装Mysql会报错
rpm -qa|grep mariadb
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
如图:
解压安装包
tar xf mysql-5.7.31-1.el7.x86_64.rpm-bundle.tar
如图:
安装Mysql
# 以下4个包为必须安装,必须按照以下顺序安装
rpm -ivh mysql-community-common-5.7.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-libs-5.7.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-client-5.7.31-1.el7.x86_64.rpm
rpm -ivh mysql-community-server-5.7.31-1.el7.x86_64.rpm
#以下四个为非必须安装
rpm -ivh mysql-community-libs-compat-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-embedded-compat-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-devel-8.0.16-2.el7.x86_64.rpm
rpm -ivh mysql-community-test-8.0.16-2.el7.x86_64.rpm
如果安装报错缺少依赖
直接yum安装依赖,再安装mysql
yum install libaio
yum install -y net-tools
初始化mysql
mysqld --initialize --user=mysql
启动Mysql服务
# 启动Mysql
systemctl start mysqld.service
# 查看Mysql状态
systemctl status mysqld.service
Mysql正常启动
查看初始密码
mysql第一次会生成初始密码,并且保存在日志文件中,我们查询一下初始密码
grep "password" /var/log/mysqld.log
登录Mysql
# 注意 u和root p和密码之间无空格
mysql -uroot -p密码
修改密码
# 修改root账户的密码
ALTER USER 'root'@'localhost' IDENTIFIED BY '新密码';
设置连接白名单
# 白名单IP填%代表允许所有IP连接
GRANT ALL PRIVILEGES ON *.* TO 'root'@'白名单IP' IDENTIFIED BY '你的密码' WITH GRANT OPTION;
## 刷新后生效
FLUSH PRIVILEGES;
安装完成
使用Navcat连接数据库即可,如果没开防火墙的别忘了开防火墙,云服务器还需要开通端口权限