二进制安装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@loca造婷用痃lhost 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 = 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 = 64Mlog-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

7、初始化mysqlmysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/data/mysql

8、配置启动脚本cp /usr/local/mysql/support-files/mysql.衡痕贤伎server /etc/init.d/mys鳎溻趄酃qldchkconfig --add mysqldchkconfig mysqld onchkconfig --list |grep mysqld

9、启动MySQL/etc/init.d/mysqld start

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