mysql装载数据_mysql8安装记录

1.下载官方打包好的二进制安装包：

#wget https://cdn.mysql.com//Downloads/MySQL-8.0/mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

可以看到这个版本采用了tar.xz的打包压缩方式，文件只有350M左右，下载还是满方便的。

du -sh mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

339M mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz

2.解压文件：

#tar -xJvf mysql-8.0.12-linux-glibc2.12-x86_64.tar.xz -C /usr/local/

mv /usr/local/mysql-8.0.12-linux-glibc2.12-x86_64/ /usr/local/mysql

3.配置参数文件：

cat /etc/my.cnf

[mysqld]

server-id = 1

port = 3306

mysqlx_port = 33060

mysqlx_socket = /tmp/mysqlx.sock

datadir = /data/mysql

socket = /tmp/mysql.sock

pid-file = /tmp/mysqld.pid

log-error = error.log

slow-query-log = 1

slow-query-log-file = slow.log

long_query_time = 0.2

log-bin = bin.log

relay-log = relay.log

binlog_format =ROW

relay_log_recovery = 1

character-set-client-handshake = FALSE

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

init_connect =‘SET NAMES utf8mb4‘

innodb_buffer_pool_size = 1G

join_buffer_size = 128M

sort_buffer_size = 2M

read_rnd_buffer_size = 2M

log_timestamps = SYSTEM

lower_case_table_names = 1

default-authentication-plugin =mysql_native_password

4.创建目录授权等：

groupadd mysql

useradd mysql

mkdir -p /data/mysql

chown -R mysql:mysql /data/mysql/

chmod -R 775 /data/mysql/

5.初始化数据库：

#/usr/local/mysql/bin/mysqld --user=mysql --basedir=/usr/local/mysql