|NO.Z.00014|——————————|Applications|——|Mysql.V5.7.26部署|——|待修订|

一、mysql.v5.7.26版本包下载

### --- mysql.v5.7.26版本包下载
### --- mysql.v5.7.26官网地址：

~~~     mysql下载地址：
~~~     https://downloads.mysql.com/archives/community/

### --- mysql配置目录说明

/opt/yanqi/software：                                        //  安装文件下载目录
/usr/local/mysql：                                           //  Mysql目录安装位置
/data/mysql：                                                //  数据库保存位置
/data/log/mysql                                              //  日志保存位置

二、mysql.v5.7.26版本包安装

### --- 下载mysql.v5.7.26版本包

~~~     # 下载mysql.v5.7.26版本包
~~~     # 下载mysql版本包
[root@localhost ~]# wget https://downloads.mysql.com/archives/get/p/23/file/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
[root@localhost ~]# ls /opt/yanqi/software/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz 
/opt/yanqi/software/mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz

~~~     # 解压并修改目录名称

[root@localhost ~]# cd /opt/yanqi/software/
[root@localhost software]# tar -zxvf mysql-5.7.26-linux-glibc2.12-x86_64.tar.gz
[root@localhost software]# mv mysql-5.7.26-linux-glibc2.12-x86_64 /usr/local/mysql

### --- 创建用户及修改目录属性

~~~     # 创建用户及修改目录属性
~~~     # 创建数据存储目录
[root@localhost ~]# mkdir -p /data/mysql

~~~     # 创建mysql用户、组及目录：新建mysql用户禁止登录

[root@localhost ~]# groupadd mysql
[root@localhost ~]# useradd -r -s /sbin/nologin -g mysql mysql \
-d /usr/local/mysql

~~~     # 改变目录属有着

[root@localhost ~]# cd /usr/local/mysql/
[root@localhost mysql]# chown -R mysql .
[root@localhost mysql]# chgrp -R mysql .
[root@localhost mysql]# chown -R mysql /data/mysql

### --- 配置参数

~~~     # 初始化数据库
[root@localhost ~]# cd /usr/local/mysql/
[root@localhost mysql]# bin/mysqld --initialize --user=mysql \
--basedir=/usr/local/mysql --datadir=/data/mysql
~~~输出参数
[Note] A temporary password is generated for root@localhost: U9,<9)0o-FiN
~~~生成临时密码：YFe5.36Ae1?J

~~~     # 定义mysql数据目录

[root@localhost mysql]# bin/mysql_ssl_rsa_setup  --datadir=/data/mysql

### --- 修改系统配置文件

~~~     # 修改my.cnf配置文件
[root@localhost ~]# cd /usr/local/mysql/support-files
[root@localhost support-files]# cp my-default.cnf /etc/my.cnf
[root@localhost support-files]# cp mysql.server /etc/init.d/mysql

~~~     # 修改配置参数

[root@localhost ~]# vim /etc/init.d/mysql
~~~修改如下配置参数
basedir=/usr/local/mysql
datadir=/data/mysql

~~~     # 软连接启动文件

[root@localhost ~]# ln -s /usr/local/mysql/bin/mysql /usr/bin

### --- 配置环境变量

~~~     # 配置mysql环境变量 
[root@localhost ~]# vim /etc/profile
##MYSQL_HOME
export MYSQL_HOME=/usr/local/mysql
export PATH=$PATH:$MYSQL_HOME/bin
export PATH=$PATH:$MYSQL_HOME/sbin

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

### --- 启动mysql服务

~~~     # 启动mysql服务
[root@localhost ~]#  /etc/init.d/mysql start

### --- 初始化数据库

~~~     # 初始化数据库
[root@localhost ~]# mysql_secure_installation
~~~ 输出参数
Enter password for user root:                                       // 键入root密码
Press y|Y for Yes, any other key for No: n                          // 确认root密码
Change the password for root ?: y                                   // 修改root密码
New password:                                                       // 新密码
Re-enter new password:                                              // 确认新密码
Remove anonymous users? : n                                         // 是否删除匿名用户
Disallow root login remotely? : n                                   // 是否禁用root远程登录权限
Remove test database and access to it? : n                          // 是否删除测试数据库
Reload privilege tables now? : y                                    // 加载特权表
Success.

### --- 进入数据库初始配置

~~~     # 进入数据库初始配置
[root@localhost ~]# mysql -uroot -p123456
mysql>  use mysql;
mysql>  set password=password('123456');
mysql>  grant all privileges on *.* to 'root'@'%' identified by '123456';
mysql>  flush privileges;
mysql>  select host,user from user;

---

附录一：my.cnf配置文件

### --- my.cnf配置文件

[root@localhost ~]# cat my.cnf 
[mysqld]

port = 3306
server_id = 22206
basedir = /usr/local/mysql
datadir = /data/mysql
socket = /tmp/mysql.sock
innodb_buffer_pool_size = 10G
character-set-server=utf8
collation-server=utf8_bin
init-connect='SET NAMES utf8'
binlog_format = statement
join_buffer_size = 128M
sort_buffer_size = 2M
read_rnd_buffer_size = 2M
log_bin_trust_function_creators = on sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES

lower_case_table_names=1

---

 

 

 

---

Walter Savage Landor:strove with none,for none was worth my strife.Nature I loved and, next to Nature, Art:I warm'd both hands before the fire of life.It sinks, and I am ready to depart

                                                                                                                                                   ——W.S.Landor

---