Debian安装Mysql

Linux环境

root@debian:~# cat /etc/debian_version 
11.6

root@debian:~# uname -r
5.10.0-20-amd64

root@debian:~# uname -a
Linux debian 5.10.0-20-amd64 #1 SMP Debian 5.10.158-2 (2022-12-13) x86_64 GNU/Linux

Date 2023/1/21
Debian 11.6 / Linux Kernel 5.10 / Mysql 8.0.31

正文

(SS means steps, TT means tips)

SS 拉取Mysql的deb配置源 Debian最新的配置源

root@debian:~# wget https://dev.mysql.com/get/mysql-apt-config_0.8.24-1_all.deb

TT wget不通的话多试几次，还不行就在windows下下载好之后scp过去
TT 备注一下下载Mysql的页面：Mysql Community 官网Download页面

SS apt install安装deb配置源

root@debian:~# sudo apt install ./mysql-apt-config_0.8.24-1_all.deb

TT 注意加上./来告诉apt使用本地deb包

SS 回车进入第一项，选择mysql-8.0，回车回到初始界面，选择第四个OK，回车
SS 安装Mysql

root@debian:~# sudo apt update
root@debian:~# sudo apt install mysql-server

TT 配置mysql密码 TT 点进USE STRONG PASSWORD(RECOMMENDED)

SS 验证mysql安装成功

root@debian:~# systemctl status mysql

TT 输出Active: active (running)即可

SS 进入mysql

root@debian:~# mysql -u root -p

TT 至此Mysql安装成功

TT 虽然本地连接成功，但远程连接不成功
SS 修改mysql数据库的user表

mysql> update user set host="%" where user="root" and host="localhost";
mysql> flush privileges;

TT 使用sqlyog还会遇到报错 plugin caching_sha2_password could not...
SS 修改加密方式和密码

# 修改加密方式
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY 'password' PASSWORD EXPIRE NEVER;
mysql> ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'password';
mysql> FLUSH PRIVILEGES;
# 修改密码
mysql> ALTER USER 'root'@'localhost' IDENTIFIED BY '123456'; 

致谢

参考自九分柠的CSDN博客