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

?

1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28 29 30 31

[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

 3）ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/tmp/mysql.sock' (2)

更改 /etc/my.cnf的配置

[client]
socket = /var/run/mysqld/mysqld.sock

4）2003 - Can’t connect to MySQL server on ' '(10060)

因为Debian通常使用MariaDB作为MySQL的替代品

sudo vim /etc/mysql/mariadb.conf.d/50-server.cnf

重启MySQL服务

修改配置文件后，需要重启MySQL服务以使更改生效：

sudo systemctl restart mysql

或者对于MariaDB：

sudo systemctl restart mariadb

 

查看端口情况

 如果端口无法访问：

sudo iptables -A INPUT -p tcp --dport 80 -j DROP