CentOS安装MySQL指定版本

商商-77

已于 2022-10-02 22:12:16 修改

阅读量704

点赞数

分类专栏： Linux 文章标签： mysql java 数据库

于 2022-06-27 21:57:52 首次发布

本文链接：https://blog.csdn.net/umgsai/article/details/125492618

版权

Linux 专栏收录该内容

20 篇文章 0 订阅

订阅专栏

首先在MySQL官网下载安装包 MySQL :: Download MySQL Community Server (Archived Versions)

这里下载 mysql-8.0.17-1.el7.x86_64.rpm-bundle.tar

wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.17-1.el7.x86_64.rpm-bundle.tar

### 解压缩
tar -xf mysql-8.0.17-1.el7.x86_64.rpm-bundle.tar

### 安装
yum install mysql-community-{client,common,devel,embedded,libs,server}-*

### 启动MySQL服务
systemctl start mysqld.service
### 重启
systemctl restart mysqld  
### 查看MySQL服务状态
service mysqld status

### 修改MySQL端口
vim /etc/my.cnf
在其中加上 port=13306

### 查询MySQL初始密码
grep "password" /var/log/mysqld.log 

### 登录MySQL
mysql -uroot -P13306 -p 

### 修改MySQL密码
ALTER USER 'root'@'localhost' IDENTIFIED BY 'new password'; 

### 开启远程访问
> UPDATE user SET Host='%' WHERE User='root' AND Host='localhost';          
//-Host='%'可以改为具体的ip地址，这样就是指定ip远程访问。    
> flush privileges;     --不重启刷新


### 创建只读用户
CREATE USER 'readonly_app'@'%' IDENTIFIED BY '123456';
GRANT SELECT ON testDB.* TO 'readonly_app'@'%';
FLUSH PRIVILEGES;

参考阿里云ECS的Centos7安装mysql8.0.17 - 掘金t

安装的时候遇到以下报错

---> Package mysql-community-server-debug.x86_64 0:8.0.30-1.el7 will be installed
--> Finished Dependency Resolution
Error: Package: mysql-community-server-8.0.30-1.el7.x86_64 (/mysql-community-server-8.0.30-1.el7.x86_64)
Requires: mysql-community-icu-data-files = 8.0.30-1.el7
You could try using --skip-broken to work around the problem
You could try running: rpm -Va --nofiles --nodigest

此时单独安装 mysql-community-icu-data-files即可

rpm -ivh mysql-community-icu-data-files-8.0.28-1.el7.x86_64.rpm