mysql8.1创建数据库_数据库学习之路（一）MySQL8安装

# useradd mysql

2、创建数据和日志目录

# mkdir -p /data/mysql/data_3306 # mkdir -p /data/mysql/binlog_3306

3、下载安装包并安装

# cd /usr/local/

# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz

# tar xf mysql-8.0.16-linux-glibc2.12-x86_64.tar.xz

# ln -s mysql-8.0.16-linux-glibc2.12-x86_64 mysql8

# yum install libaio libaio-devel -y

4、设置环境变量

# vim /etc/profile

export PATH=/usr/local/mysql8/bin:$PATH

# source /etc/profile

5、权限设置

# chown -R mysql.mysql /data /usr/local/mysql*

6、初始化

# mysqld --initialize-insecure --user=mysql --basedir=/usr/local/mysql57 --datadir=/data/mysql/data_3306

7、启动数据库

# yum remove -y mariadb-libs

# more /etc/my.cnf

[mysqld]

user=mysql

basedir=/usr/local/mysql57

datadir=