mysql.sock 初始化_mysql8.0 部署、初始化和创建实例

环境信息：

centos 7.4.1708

mysql 8.0.11

1.下载解压缩mysql包

cd /usr/local/

wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz

tar xzvf mysql-8.0.11-linux-glibc2.12-x86_64.tar.gz

mv mysql-8.0.11-linux-glibc2.12-x86_64 mysql

2.初始化mysql基础环境信息

vim /etc/profile

PATH=/opt/mysql/bin:/opt/mysql/lib:$PATH

export PATH

export MYSQL_HOME="/opt/mysql"

export ms="/opt/mysql"

3.初始化配置实例配置文件

mkdir -p /opt/mysql/data/mcdb

vi /opt/mysql/data/my.cnf

[client]

port = 3311

socket = /opt/mysql/data/mcdb/mysql.sock

[mysql]

no-auto-rehash

[mysqld]

user = mysql

port = 3311

socket = /opt/mysql/data/mcdb/mysql.sock

basedir = /opt/mysql

datadir = /opt/