二进制安装mysql-5.7.28

二进制安装mysql-5.7.28

1 ) 下载并解压缩安装包：

cd /data/src/
wget https://cdn.mysql.com/archives/mysql-5.7/mysql-5.7.28-linux-glibc2.12-x86_64.tar.gz
tar -zxf mysql-5.7.28-linux-glibc2.12-x86_64.tar.g
mv mysql-5.7.28-linux-glibc2.12-x86_64 /data/mysql

2 ） 安装二进制包需要的依赖包：

yum install libaio -y

3 ) 初始化安装过程：

### 3.1 )  添加mysql 用户组：
groupadd mysql
useradd -r -g mysql -s /bin/false mysql

### 3.2 )  创建数据目录：
mkdir -p /data/mysql_data
chown mysql:mysql /data/mysql_data
chmod 750 /data/mysql_data

###  3.3 ) 执行初始化mysql-5.7.29(执行成功后会产生一个root@localhost 的临时密码一定要记住，第一次进入以后要自改)：
cd /data/mysql
bin/mysqld --initialize --user=mysql --basedir=/data/mysql --datadir=/data/mysql_data

###  3.4 ) mysql-5.7.29 内部没有发现my.cnf,自己手工写一个：
vim /etc/my.cnf
[client]
default-character-set = utf8
#user=root
#password='M=y&mJepc5Al'
socket          = /tmp/mysql.sock
[mysqld]
#skip-grant-tables=1
default-storage-engine = INNODB
character-set-server = utf8
collation-server = utf8_general_ci
port=3306
socket=/tmp/mysql.sock
user=mysql
datadir=/data/mysql_data

###  3.5 ) 执行以下命令创建RSA private key：
bin/mysql_ssl_rsa_setup --datadir=/data/mysql_data

###  3.6 ) 启动命令(这一步要修改启动文件里的basedir=,datadir= 选项, 全都改.)：
cp support-files/mysql.server /etc/init.d/mysqld 
chkconfig --add mysqld
chkconfig mysqld on 
/etc/init.d/mysqld restart

### 3.7 ) 初始化示例：
[root@promi mysql]# bin/mysqld --initialize --user=mysql --basedir=/data/mysql --datadir=/data/mysql_data
2020-04-14T06:39:10.762197Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details).
2020-04-14T06:39:11.923097Z 0 [Warning] InnoDB: New log files created, LSN=45790
2020-04-14T06:39:12.089667Z 0 [Warning] InnoDB: Creating foreign key constraint system tables.
2020-04-14T06:39:12.154559Z 0 [Warning] No existing UUID has been found, so we assume that this is the first time that this server has been started. Generating a new UUID: a6d67ce3-7e1a-11ea-b0a2-52540063b5d5.
2020-04-14T06:39:12.163927Z 0 [Warning] Gtid table is not ready to be used. Table 'mysql.gtid_executed' cannot be opened.
2020-04-14T06:39:13.026642Z 0 [Warning] CA certificate ca.pem is self signed.
2020-04-14T06:39:13.242955Z 1 [Note] A temporary password is generated for root@localhost: M=y&mJepc5Al

###  --basedir mysql基础目录
###  --datadir mysql数据存放目录
这里会生成mysql第一次登录用的 临时密码 需要保存下来 M=y&mJepc5Al 就是临时密码
root@localhost: M=y&mJepc5Al

### 3.8 )  进入mysql 修改root 密码(如果不能登录,采用破解root权限的方法)：
1) select user,host,authentication_string from mysql.user;
update mysql.user set authentication_string=password('linux') where user='root' and Host = 'localhost';
2)  update mysql.user set password_expired='N' where user='root';
3)  flush privileges;

 经过已经步骤就已经安装完成了, 也是可以正常登录.

4 ) 配置环境变量：

### 4.1 ） 添加mysql环境变量：
vim /etc/profile.d/mysqld.sh

PATH=$PATH:$HOME/bin:/data/mysql:/data/mysql/bin/
export PATH
### 4.2 )  加载环境变量：
source /etc/profile

...... 至此 mysql-5.7.29 二进制包安装完成：