二进制安装MySQL方法

1、获取二进制安装包mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

2、创建用户和组

[root@localhost ~]# groupadd mysql

[root@localhost ~]# useradd -g mysql -s /sbin/nologin mysql

3、解压源码包

[root@localhost ~]# mkdir -p /usr/local/

[root@localhost ~]# tar zxf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz -C /usr/local/

4、设置环境变量

[root@localhost ~]# cd /usr/local/

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

[root@localhost local]# echo "export PATH=$PATH:/usr/local/mysql/bin" >> /etc/profile

[root@localhost local]# source /etc/profile

5、[root@localhost ~]# mkdir -p /data/mysql

[root@localhost ~]# chown -R mysql. /data/mysql/

6、编辑my.cnf

[client]

port = 3306

socket = /tmp/mysql.sock

[mysqld]

port = 3306

socket = /tmp/mysql.sock

pid_file = /data/mysql/mysql.pid

datadir = /data/mysql

default_storage_engine = InnoDB

max_allowed_packet = 512M

max_connections = 2048

open_files_limit = 65535

skip-name-resolve

lower_case_table_names=1

character-set-server = utf8mb4

collation-server = utf8mb4_unicode_ci

init_connect='SET NAMES utf8mb4'

innodb_buffer_pool_size = 512M

innodb_log_file_size = 1024M

innodb_file_per_table = 1

innodb_flush_log_at_trx_commit = 0

key_buffer_size = 64M

log-error = /data/mysql/mysql_error.log

log-bin = /data/mysql/mysql-bin

binlog_format = mixed

expire_logs_days = 10

slow_query_log = 1

slow_query_log_file = /data/mysql/slow_query.log

long_query_time = 1

server-id=1

7、初始化mysql

mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

8、配置启动脚本

cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld

chkconfig --add mysqld

chkconfig  mysqld on

chkconfig --list |grep mysqld

9、启动MySQL

/etc/init.d/mysqld start

10、会生成一个临时密码，使用临时密码登录mysql即可