mysql8.014安装_MySQL8.0安装详解

一、安装系统配置

到公有云上申请一个ECS，测试使用，规格可以随意，磁盘空间100G。

操作系统镜像：CentOS7.4

内核版本： 3.10.0-327.36.3.el7.x86_64

MySQL8.0各个安装包的用途。

Package name

用途

mysql-community-client

MySQL client applications and tools

mysql-community-common

common files for server and client libraries

mysql-community-devel

development header files and libraries for mysql   database client applications

mysql-community-embedded-compat

mysql server as an embedded library with compatibility   for applications using version 18 of the library

mysql-community-libs

shared libraries for mysql database client applications

mysql-community-libs-compat

shared compatibility libraries for previous mysql   installations

mysql-community-server

database server and related tools

mysql-community-test

test suite for the mysql server

mysql-8.0.14-1.el7.x86_64.rpm-bundle.tar

二、安装MySQL8.0

1. 准备工作

a. 先创建分区

fdisk /dev/vdb

创建出两个分区，一个70G用于存在mysql数据，一个30G，用于放软件等资料。

b. 格式化文件系统：

mkfs.ext4 /dev/vdb1

mkfs.ext4 /dev/vdb2

c. 创建挂载点

mkdir -p /var/lib/mysql

mkdir -p /var/software

echo '/dev/vdb1 /var/lib/mysql ext4 rw,nosuid,nodev,exec,auto,nouser,async 0 0' >> /etc/fstab

echo '/dev/vdb2 /var/software ext4 rw,nosuid,nodev,exec,auto,nouser,async 0 0' >> /etc/fstab

mount -a

2. 上传Mysql安装包

mysql-8.0.14-1.el7.x86_64.rpm-bundle.tar

3. 解压安装包和卸载冲突的安装包

tar -xvf mysql-8.0.14-1.el7.x86_64.rpm-bundle.tar

4. 安装

a. rpm -ivh mysql-community-common-8.0.14-1.el7.x86_64.rpm

b.卸载冲突包

rpm -e mariadb-libs-5.5.56-2.el7.x86_64 --nodeps

c. rpm -ivh mysql-community-libs-8.0.14-1.el7.x86_64.rpm

d. rpm -ivh mysql-community-client-8.0.14-1.el7.x86_64.rpm

e. rpm -