获取二进制安装包mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
创建用户和组[root@localhost ~]# groupadd mysql[root@localhost ~]# useradd -g mysql -s /sbin/nologin mysql
解压源码包[root@localhost ~]# mkdir -p /usr/local/[root@localhost ~]# tar zxf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz -C /usr/local/
设置环境变量[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
[root@localhost ~]# mkdir -p /data/mysql[root@localhost ~]# chown -R mysql. /data/mysql/
编辑my.cnf[client]port = 3306socket = /tmp/mysql.sock[mysqld]port = 3306socket = /tmp/mysql.sockpid_file = /data/mysql/mysql.piddatadir = /data/mysqldefault_storage_engine = InnoDBmax_allowed_packet = 512Mmax_connections = 2048open_files_limit = 65535skip-name-resolvelower_case_table_names=1character-set-server = utf8mb4collation-server = utf8mb4_unicode_ciinit_connect='SET NAMES utf8mb4' innodb_buffer_pool_size = 512Minnodb_log_file_size = 1024Minnodb_file_per_table = 1innodb_flush_log_at_trx_commit = 0key_buffer_size = 64M log-error = /data/mysql/mysql_error.loglog-bin = /data/mysql/mysql-binbinlog_format = mixedexpire_logs_days = 10slow_query_log = 1slow_query_log_file = /data/mysql/slow_query.loglong_query_time = 1server-id=1
初始化mysqlmysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql
配置启动脚本 cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld chkconfig --add mysqld chkconfig mysqld on chkconfig --list |grep mysqld
启动MySQL/etc/init.d/mysqld start
会生成一个临时密码，使用临时密码登录mysql即可