mysql8 安装 解压_mysql8解压方式安装

1、解压安装包 mysql-8.0.17-linux-glibc2.12-x86_64.tar.xz

[root@localhost opt]# tar Jxvf mysql-8.0.17-linux-glibc2.12-x86_64.tar.xz

2、移动到安装目录ll

[root@localhost opt]# mv mysql-8.0.17-linux-glibc2.12-x86_64 /usr/local/mysql

3、创建mysql用户和组

[root@localhost mysql]# groupadd mysql

[root@localhost mysql]# useradd -r -g mysql -s /bin/false mysql

4、创建mysql数据目录，修改权限

[root@localhost data]# mkdir mysql-files

[root@localhost data]# chown mysql:mysql mysql-files/

[root@localhost data]# chmod 750 mysql-files/

5、新建一个my-default.cnf文件，复制到/etc/my.cnf

[root@localhost mysql]# touch my-default.cnf

[root@localhost mysql]# chmod 755 my-default.cnf

[root@localhost mysql]# cp my-default.cnf /etc/my.cnf

cp：是否覆盖"/etc/my.cnf"？ y

[root@localhost mysql]#

6、配置my.cnf

[client]

port = 3306

socket = /tmp/mysql.sock

[mysql]

prompt="\u@mysqldb \R:\m:\s [\d]> "

no-auto-rehash

[mysqld]

#skip-grant-tables

user = mysql

port = 3306

basedir = /usr/local/mysql

datadir = /data/mysql-files

socket = /tmp/mysql.sock

pid-file = mysqldb.pid

character-set-server = utf8mb4

default_authentication_plugin=mysql_native_password

skip_name_resolve = 1

open_files_limit = 65535

back_log = 1024

max_connections = 6000

max_allowed_packet = 64M

interactive_timeout = 600

wait_timeout = 600

tmp_table_size = 32M

max_heap_table_size = 32M

slo