参考 https://blog.csdn.net/weixin_44678261/article/details/102503018
1、下载mysql rpm安装包
https://dev.mysql.com/downloads/mysql/
# /usr/local/目录下 创建mysql目录
cd /usr/local
mkdir mysql
cd /usr/local/mysql
#解压缩指定目录下的mysql压缩文件到mysql目录下
tar -xvf /usr/local/mysql-8.0.22-1.el7.x86_64.rpm-bundle.tar
rpm文件名需要改为自己的文件名
#安装common
rpm -ivh mysql-community-common-8.0.22-1.el7.x86_64.rpm --nodeps --force
#安装libs-8.*
rpm -ivh mysql-community-libs-8.0.22-1.el7.x86_64.rpm --nodeps --force
#安装client-8.*
rpm -ivh mysql-community-client-8.0.22-1.el7.x86_64.rpm --nodeps --force
#安装server
rpm -ivh mysql-community-server-8.0.22-1.el7.x86_64.rpm --nodeps --force
查看已安装的mysql模块
rpm -qa | grep mysql
mysql 数据库的初始化和相关配置
mysqld --initialize;
报错
mysqld: error while loading shared libraries: libaio.so.1: cannot open shared object file: No such file or directory
解决方式:yum方式安装 libaio
yum install -y libaio
继续初始化mysql等:
# 初始化mysql
mysqld --initialize;
#
chown mysql:mysql /var/lib/mysql -R;
#
systemctl start mysqld.service;
#
systemctl enable mysqld;
# 查看安装的mysql初始密码
cat /var/log/mysqld.log | grep password
使用初始密码登录 - 修改初始密码:
#使用初始密码登录
mysql -uroot -p#5ksCfi8EwfG
#修改初始密码为123456
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '123456';
如果需要修改连接数:
2、对外开放当前mysql:
如果需要对外开放当前mysql,需要开通服务器的3306端口
阿里云找到 安全组规则,新增3306端口
选中ECS实例,加入安全组,选中对应的安全组