mysql 手动安装_MySQL 5.7手动安装步骤

MySQL 5.7手动安装步骤

一，下载

1.1 下载地址

1.2 mysql主配置信息

内存：2-4G

二，安装配置

2.1 解压安装文件到/usr/local/

cd /usr/local/

tar xf mysql-5.7.29-linux-glibc2.12-x86_64.tar.gz -C /usr/local

mkdir /usr/local/mysql

unlink /usr/local/mysql

ln -fs /usr/local/mysql-5.7.29-linux-glibc2.12-x86_64 /usr/local/mysql

2.2 创建数据目录&mysql用户

mkdir -p /data/mysql/3306/{data,binlog,relaylog,dblog,tmp}

touch /data/mysql/3306/dblog/error.log

useradd mysql

chown -R mysql.mysql /data/mysql/3306

2.3 创建配置文件到

vim /data/mysql/3306/my.cnf

[client]

port = 3306

socket = /data/mysql/3306/mysql.sock

[mysql]

no-auto-rehash

#prompt = "\\u@\\d \\R:\\m> "

prompt = "\\u@\\h : \\d \\R:\\m:\\s> "

character-set-server = utf8mb4

# The MySQL server

#########Basic##################

[mysqld]

server-id = 883306

port = 3306

user = mysql

basedir = /usr/local/mysql

datadir = /data/mysql/3306/data

socket = /data/mysql/3306/mysql.sock

pid-file = /data/mysql/3306/mysql.pid

skip-external-locking

skip-name-resolve

default-storage-engine = InnoDB

character-set-client-handshake = FALSE

character-set-server = utf8mb4

init_connect='set names utf8mb4'

#wait_timeout = 200

#interactive_timeout = 200