MySQL二进制安装

MySQL二进制安装

​ 下载链接：https://dev.mysql.com/downloads/mysql/5.7.html#downloads

一、创建 mysql 用户

#1)创建用户
useradd --home-dir=/home/mysql -m mysql

#2)删除用户
userdel -r mysql

#3)修改用户密码
passwd mysql

二、安装MySQL(二进制)

​ 1、安装依赖包（root用户）

yum -y install gcc gcc-c++ ncurses ncurses-devel cmake bison libaio-devel git openssl-devel

​ 2、创建软件目录（root用户）

mkdir -p /home/mysql/mysql && chown mysql:mysql /home/mysql/mysql

​

​ 3、解压二进制包到软件目录（mysql用户）

tar -zxvf mysql-5.7.30-linux-glibc2.12-x86_64.tar.gz -C /home/mysql/mysql/

cd /home/mysql/mysql/

mv mysql-5.7.30-linux-glibc2.12-x86_64 mysql-5.7.30

​ 4、增加软连接（root用户）

ln -s  /home/mysql/mysql/mysql-5.7.30 /usr/local/mysql

​ 5、配置 my.cnf 文件（mysql用户）

[client]
socket=/home/mysql/mysql.sock
[mysqld]
symbolic-links=0
server_id                  = 1353306
default_storage_engine    = Innodb
user                      = mysql
basedir                    = /home/mysql/mysql
datadir                    = /home/mysql/mysqldata
tmpdir                    = /home/mysql/tmp
socket                    = /home/mysql/mysql.sock
pid_file                  = /home/mysql/mysql.pid
character_set_server      = utf8
collation_server          = utf8_general_ci
log_error                  = /home/mysql/mysqllog/error/error.log
log_bin                    = /home/mysql/mysqllog/binlog/mysql-binlog
innodb_log_group_home_dir  = /home/mysql/mysqllog/innodb
slow_query_log_file        = /home/mysql/mysqllog/slowlog/slow-query.log
slave_parallel_type=LOGICAL_CLOCK								
slave_parallel_workers=4												
slave_preserve_commit_order=on									
skip_slave_start=on															
sync_binlog=1																		
master-info-repository=TABLE										
relay-log-info-repository=TABLE									
relay-log-recovery=ON														
log_slave_updates=on														
gtid_mode=on																		
enforce-gtid-consistency=on											
binlog_format=row																
sync_binlog = 1                                 
innodb_flush_log_at_trx_commit = 1              

[mysqld_safe]
log-error=/home/mysql/mysqllog/error/error.log

​ 6、创建所需目录（mysql用户）

mkdir -p /home/mysql/mysqllog/error
mkdir -p /home/mysql/mysqllog/binlog
mkdir -p /home/mysql/mysqllog/innodb
mkdir -p /home/mysql/mysqllog/slowlog
mkdir -p /home/mysql/tmp
mkdir -p /home/mysql/mysqldata

​ 7、配置 mysql 用户环境(mysql用户)

mysql@localhost ~]$ echo $PATH
/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/mysql/.local/bin:/home/mysql/bin
[mysql@localhost ~]$ export PATH=$PATH:/usr/local/mysql/bin
[mysql@localhost ~]$ echo $PATH
/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/mysql/.local/bin:/home/mysql/bin:/usr/local/mysql/bin
[mysql@localhost ~]$



# vi .bashrc 在最后加上
PATH=/usr/local/bin:/bin:/usr/bin:/usr/local/sbin:/usr/sbin:/home/mysql/.local/bin:/home/mysql/bin:/usr/local/mysql/bin

source .bashrc

​ 8、初始化数据库（root用户）

/usr/local/mysql/bin/mysqld --initialize --user=mysql --basedir=/usr/local/mysql --datadir=/home/mysql/mysqldata & 

​ 9、登库并修改密码

#启库
/usr/local/mysql/bin/mysqld --defaults-file=/home/mysql/mysql/my.cnf --user=mysql &

#停库
/usr/local/mysql/bin/mysqladmin -uroot -p shutdown -S /home/mysql/mysql.sock

#登库
mysql -uroot -p -S /home/mysql/mysql.sock

#修改密码
alter user 'root'@'localhost' identified by 'hadoop';

​ 10、导入 sakila 数据库

#导入 sakila 数据库方法一
mysql -uroot -p -S /home/mysql/mysql.sock
source /home/mysql/tmp/sakila-db/sakila-data.sql
source /home/mysql/tmp/sakila-db/sakila-schema.sql


#导入 sakila 数据库方法二
mysql -uroot -p -S /home/mysql/mysql.sock < sakila-schema.sql
mysql -uroot -p -S /home/mysql/mysql.sock < sakila-data.sql