CentOS离线安装MySQL8

Author： JiuyeXD
发布时间：October 27, 2021
418 views
No comments
4278 words
Categories：技术杂谈闲言碎语

## 1. 下载安装MySQL

#### 1.1 去官网下载

```
cd /opt
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz
```

如果是完全离线的情况下要

<button class="btn m-b-xs btn-dark btn-addon" onclick='window.open("https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz","_blank")'><i class="glyphicon glyphicon-download-alt"></i>MySQL 8.0.27.tar.xz</button>

然后手动上传到 `/opt` 目录下

#### 1.2 检查并卸载系统自带Mariadb

```
# 查询
rpm -qa | grep mariadb
	[root@centos ~]# rpm -qa | grep mariadb
	mariadb-libs-5.5.68-1.el7.x86_64

# 卸载
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
	[root@centos ~]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

```

#### 1.3 检查并卸载系统自带的MySQL

```
# 查询
rpm -qa | grep mysql

# 卸载
rpm -e --nodeps 对应文件名
```

#### 1.4 安装MySQL

```
# 进入 /opt 文件夹
cd /opt

# 解压
tar -xvf mysql-*.tar.xz && rm -rf mysql-*.tar.xz

# 重命名
mv mysql-*-linux* mysql-8.0.27

# 进入文件夹
cd mysql*

# 新建文件夹
mkdir data && mkdir log && mkdir tmp
```

## 2. 配置MySQL

#### 2.1 创建 MySQL用户组和用户名

````
# 创建用户组
groupadd mysql

# 创建用户名并加入到MySQL用户组
useradd -g mysql mysql

# 给MySQL用户权限
chown mysql:mysql -R /opt/mysql-8.0.27
````

#### 2.2 配置 my.cnf 文件

```
[mysqld]
character-set-server=utf8
user=mysql
port=3306
basedir=/opt/mysql-8.0.27
datadir=/opt/mysql-8.0.27/data
socket=/tmp/mysql.sock

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/opt/mysql-8.0.27/mysqld.pid
 
[client]
port=3306
socket=/tmp/mysql.sock

```

#### 2.3 初始化数据库

```
# 进入目录
cd /opt/mysql*

# 执行初始化命令
bin/mysqld --initialize --user=mysql
```

![result.png](https://old.qwq.ro/usr/uploads/2021/10/2733124408.png)

初始化密码为: `KVhXBl3tx,jK`

#### 2.4 安装加密算法

```
bin/mysql_ssl_rsa_setup
```

#### 2.5 注册数据库服务

```
# 进入目录
cd /opt/mysql*

# 复制文件至 init.d 并注册
cp support-files/mysql.server /etc/init.d/mysqld && chmod +x /etc/init.d/mysqld && chkconfig --add mysqld && chkconfig mysqld on

# 创建软连接
ln -s /opt/mysql* /usr/local/mysql

```

#### 2.6 启动MySQL服务

````
service mysqld start

[root@centos mysql-8.0.27]# service mysqld start
	Starting MySQL.Logging to '/opt/mysql-8.0.27/data/centos.err'.
	. SUCCESS!

````

#### 2.7 修改环境变量

```
# 编辑profile
vim /etc/profile
# 在文件末尾插入
export PATH=$PATH:/opt/mysql-8.0.27/bin
# 重载profile文件
source /etc/profile
```

#### 2.8 修改root用户密码

```
mysql -uroot -p

mysql> set password = '密码';
```

#### 2.9 配置远程连接

````
update mysql.user set host='%' where user='root';
exit
````

#### 2.10 重启MySQL服务

```
service mysqld restart
```

![image.png](https://old.qwq.ro/usr/uploads/2021/10/3516043016.png)

使用工具已可以成功连接

## 3. 遇到的问题

#### 3.1 mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory

````bash
[root@MiWiFi-RA72-srv mysql-8.0.27]# mysql -uroot -p
mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory
````

今天使用自己笔记装MYSQL的时候无法远程提示 libtinfo.so.5 缺失

```bash
# 进入目录
cd /opt/mysql-8.0.27/bin
# 查询依赖关系
ldd mysql
	[root@MiWiFi-RA72-srv bin]# ldd mysql
	        linux-vdso.so.1 (0x00007ffe5e1c0000)
	        libpthread.so.0 => /lib64/libpthread.so.0 (0x00007fab2c6f2000)
	        libdl.so.2 => /lib64/libdl.so.2 (0x00007fab2c4ee000)
	        libcrypto.so.1.1 => /opt/mysql-8.0.27/bin/./../lib/private/libcrypto.so.1.1 (0x00007fab2c03c000)
	 	       libssl.so.1.1 => /opt/mysql-8.0.27/bin/./../lib/private/libssl.so.1.1 (0x00007fab2bdac000)
	        libresolv.so.2 => /lib64/libresolv.so.2 (0x00007fab2bb95000)
	        librt.so.1 => /lib64/librt.so.1 (0x00007fab2b98d000)
	        libtinfo.so.5 => not found
	        libstdc++.so.6 => /lib64/libstdc++.so.6 (0x00007fab2b5f8000)
	        libm.so.6 => /lib64/libm.so.6 (0x00007fab2b276000)
	        libgcc_s.so.1 => /lib64/libgcc_s.so.1 (0x00007fab2b05e000)
	        libc.so.6 => /lib64/libc.so.6 (0x00007fab2ac99000)
	        /lib64/ld-linux-x86-64.so.2 (0x00007fab2c912000)

```

<button class="btn m-b-xs btn-dark btn-addon" onclick='window.open("https://old.qwq.ro/usr/uploads/2022/06/4274938658.5","_blank")'><i class="glyphicon glyphicon-download-alt"></i>libtinfo.so.5</button>

将文件放入系统中即可

或者直接输入

```bash
# 安装缺失依赖
dnf install ncurses-compat-libs
```

Last modification：June 27, 2022

感谢大佬投喂啾咪~

CentOS离线安装MySQL8

JiuyeXD • 2021 年 10 月 27 日

## 1. 下载安装MySQL

#### 1.1 去官网下载

```
cd /opt
wget https://dev.mysql.com/get/Downloads/MySQL-8.0/mysql-8.0.27-linux-glibc2.12-x86_64.tar.xz
```

如果是完全离线的情况下要

然后手动上传到 `/opt` 目录下

#### 1.2 检查并卸载系统自带Mariadb

```
# 查询
rpm -qa | grep mariadb
	[root@centos ~]# rpm -qa | grep mariadb
	mariadb-libs-5.5.68-1.el7.x86_64

# 卸载
rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64
	[root@centos ~]# rpm -e --nodeps mariadb-libs-5.5.68-1.el7.x86_64

```

#### 1.3 检查并卸载系统自带的MySQL

```
# 查询
rpm -qa | grep mysql

# 卸载
rpm -e --nodeps 对应文件名
```

#### 1.4 安装MySQL

```
# 进入 /opt 文件夹
cd /opt

# 解压
tar -xvf mysql-*.tar.xz && rm -rf mysql-*.tar.xz

# 重命名
mv mysql-*-linux* mysql-8.0.27

# 进入文件夹
cd mysql*

# 新建文件夹
mkdir data && mkdir log && mkdir tmp
```

## 2. 配置MySQL

#### 2.1 创建 MySQL用户组和用户名

````
# 创建用户组
groupadd mysql

# 创建用户名并加入到MySQL用户组
useradd -g mysql mysql

# 给MySQL用户权限
chown mysql:mysql -R /opt/mysql-8.0.27
````

#### 2.2 配置 my.cnf 文件

```
[mysqld]
character-set-server=utf8
user=mysql
port=3306
basedir=/opt/mysql-8.0.27
datadir=/opt/mysql-8.0.27/data
socket=/tmp/mysql.sock

[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/opt/mysql-8.0.27/mysqld.pid
 
[client]
port=3306
socket=/tmp/mysql.sock

```

#### 2.3 初始化数据库

```
# 进入目录
cd /opt/mysql*

# 执行初始化命令
bin/mysqld --initialize --user=mysql
```

![result.png](https://old.qwq.ro/usr/uploads/2021/10/2733124408.png)

初始化密码为: `KVhXBl3tx,jK`

#### 2.4 安装加密算法

```
bin/mysql_ssl_rsa_setup
```

#### 2.5 注册数据库服务

```
# 进入目录
cd /opt/mysql*

# 复制文件至 init.d 并注册
cp support-files/mysql.server /etc/init.d/mysqld && chmod +x /etc/init.d/mysqld && chkconfig --add mysqld && chkconfig mysqld on

# 创建软连接
ln -s /opt/mysql* /usr/local/mysql

```

#### 2.6 启动MySQL服务

````
service mysqld start

[root@centos mysql-8.0.27]# service mysqld start
	Starting MySQL.Logging to '/opt/mysql-8.0.27/data/centos.err'.
	. SUCCESS!

````

#### 2.7 修改环境变量

```
# 编辑profile
vim /etc/profile
# 在文件末尾插入
export PATH=$PATH:/opt/mysql-8.0.27/bin
# 重载profile文件
source /etc/profile
```

#### 2.8 修改root用户密码

```
mysql -uroot -p

mysql> set password = '密码';
```

#### 2.9 配置远程连接

````
update mysql.user set host='%' where user='root';
exit
````

#### 2.10 重启MySQL服务

```
service mysqld restart
```

![image.png](https://old.qwq.ro/usr/uploads/2021/10/3516043016.png)

使用工具已可以成功连接

## 3. 遇到的问题

#### 3.1 mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory

````bash
[root@MiWiFi-RA72-srv mysql-8.0.27]# mysql -uroot -p
mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory
````

今天使用自己笔记装MYSQL的时候无法远程提示 libtinfo.so.5 缺失

```

将文件放入系统中即可

或者直接输入

```bash
# 安装缺失依赖
dnf install ncurses-compat-libs
```

CentOS离线安装MySQL8

Leave a Comment Cancel reply

Hello World

记个糊涂账 API

Minecraft | [1.12.2] 核电工艺模拟器 1.2.25 —— 汉化版

dispatcher-servlet.xml文件配置模板

修改Docker容器默认存储路径

Spring 依赖注入(DI)

SpringMVC 数据回显(域)

记一次华硕RT-N66U/R路由器DDNS实现方法

CentOS8修改镜像源 | Error: Failed to download metadata for repo 'appstream': Cannot prepare internal mirrorlist: No URLs in mirrorlist

修改Docker容器默认存储路径

CentOS离线安装MySQL8