debian 8 （jessie版） 下载解压安装mysql 5.7（版本5.7.25）

debian 8 安装 mysql 5.7

## 查看mysql有哪些安装
dpkg --get-selections | grep mysql

## 卸载已经安装（纯净系统忽略）
sudo apt-get --purge remove mysql-server
sudo apt-get --purge remove mysql-client
sudo apt-get --purge remove mysql-common

## 删除mysql相关配置（纯净系统忽略）
sudo apt-get autoremove
sudo apt-get autoclean
sudo rm /etc/mysql/ -R
sudo rm /var/lib/mysql/ -R

## 下载官网 mysql 5.7 安装包（5.7.25）
## https://cdn.mysql.com/archives/mysql-5.7/
## mysql-server_5.7.25-1debian8_amd64.deb-bundle.tar
wget --no-check-certificate https://cdn.mysql.com/archives/mysql-5.7/mysql-server_\
5.7.25-1debian8_amd64.deb-bundle.tar

## 解压
tar xvf mysql-server_5.7.25-1debian8_amd64.deb-bundle.tar

## 更新系统包
apt-get update
apt-get upgrade

## 安装依赖
apt-get install libnuma1
apt-get install libmecab2

## TODO 如何依赖安装不上，更换源
## https://blog.csdn.net/yjk13703623757/article/details/78943345/

## 安装mysql基础工具包
sudo dpkg -i mysql-common_5.7.25-1debian8_amd64.deb
## 安装 client
sudo dpkg -i mysql-community-client_5.7.25-1debian8_amd64.deb
sudo dpkg -i mysql-client_5.7.25-1debian8_amd64.deb
## 安装 server
sudo dpkg -i mysql-community-server_5.7.25-1debian8_amd64.deb
sudo dpkg -i mysql-server_5.7.25-1debian8_amd64.deb

## 查看mysql状态
systemctl status  mysql.service

## 如下图：

## 查看是否成功
mysql -u root -p

## 设置为系统服务开机启动
systemctl enable mysql.service

## 常用命令
systemctl status  mysql.service		## 查看状态
systemctl start mysql.service		## 开启服务
systemctl stop mysql.service		## 关闭服务
systemctl restart mysql.service		## 重启服务


## 修改远程可以访问
cd /etc/mysql/mysql.conf.d/
vim mysqld.cnf
## 修改： bind-address = 127.0.0.1 //修改为0.0.0.0即可

# 修改 root 用户不能远程方位
# is not allowed to connect tothis mmysql server 解决
mysql -u root -p
use mysql;
select host from user where user='root';
update user set host = '%' where user ='root';
flush privileges;

## 修改密码
mysql -u root -p
use mysql;
## 密码修改为 123
update user set authentication_string = PASSWORD("123") where user='root';
update user set plugin="mysql_native_password";
flush privileges;
quit;


## 测试
mysql mysql -u root -p
123