Debian 11 离线安装MySql记录

环境：

mysql：mysql-8.0.32-linux-glibc2.17-aarch64.tar.gz

1、上传到服务器，然后解压缩

tar -zxvf mysql-8.0.32-linux-glibc2.17-aarch64.tar.gz

2、移动到指定目录/usr/local/mysql-8

mv mysql-8.0.32-linux-glibc2.17-aarch64 /usr/local/mysql-8

3、创建MySQL数据目录

mkdir -p /data

cd /data

mkdir -p mysql

4、生成编辑配置文件

vim /etc/my.cnf

[mysqld]

bind-address=0.0.0.0

port=13307

user=root

basedir=/usr/local/mysql-8

datadir=/data/mysql

socket= /var/run/mysqld/mysqld.sock

log-error=/data/mysql/mysql.err

pid-file=/data/mysql/mysql.pid

#character config

character_set_server=utf8mb4

symbolic-links=0

event_scheduler = on

max_connections = 100000

[client]

socket = /var/run/mysqld/mysqld.sock

5、初始化MYSQL

cd /usr/local/mysql-8/bin/

./mysqld --defaults-file=/etc/my.cnf --basedir=/usr/local/mysql-8/ --datadir=/data/mysql/ --user=mysql --initialize

6、查看初始密码

cat /data/mysql/mysql.err

7、启动mysql

cp /usr/local/mysql-8/support-files/mysql.server /etc/init.d/mysql

/etc/init.d/mysql status

启动 service mysql start

8、更改密码

cd /usr/local/mysql-8/bin/

./mysql -u root -p

alter user 'root'@'localhost' identified by 'Sail@2021';

9、更改访问权限

use mysql;

update user set host = '%' where user = 'root';

flush privileges;

10、设置开机自启

sudo update-rc.d -f mysql defaults

提示

1）mysql: error while loading shared libraries: libncurses.so.5: cannot open shared object file: No such file or directory，则安装

sudo apt-get install libncurses5

2）./mysql: error while loading shared libraries: libtinfo.so.5: cannot open shared object file: No such file or directory

更换下载源

deb https://mirrors.ustc.edu.cn/debian/ bullseye main contrib non-free
deb-src https://mirrors.ustc.edu.cn/debian/ bullseye main contrib non-free

deb https://mirrors.ustc.edu.cn/debian/ bullseye-updates main contrib non-free
deb-src https://mirrors.ustc.edu.cn/debian/ bullseye-updates main contrib non-free

deb https://mirrors.ustc.edu.cn/debian/ bullseye-backports main contrib non-free
deb-src https://mirrors.ustc.edu.cn/debian/ bullseye-backports main contrib non-free

deb https://mirrors.ustc.edu.cn/debian-security/ bullseye-security main contrib non-free
deb-src https://mirrors.ustc.edu.cn/debian-security/ bullseye-security main contrib non-free

新的下载源

deb https://mirrors.ustc.edu.cn/debian/ bookworm main contrib non-free non-free-firmware
deb-src https://mirrors.ustc.edu.cn/debian/ bookworm main contrib non-free non-free-firmware
deb https://mirrors.ustc.edu.cn/debian/ bookworm-updates main contrib non-free non-free-firmware
deb-src https://mirrors.ustc.edu.cn/debian/ bookworm-updates main contrib non-free non-free-firmware
deb https://mirrors.ustc.edu.cn/debian/ bookworm-backports main contrib non-free non-free-firmware
deb-src https://mirrors.ustc.edu.cn/debian/ bookworm-backports main contrib non-free non-free-firmware
deb https://mirrors.ustc.edu.cn/debian-security/ bookworm-security main contrib non-free non-free-firmware
deb-src https://mirrors.ustc.edu.cn/debian-security/ bookworm-security main contrib non-free non-free-firmware