mysql离线部署

有些时候因环境要求,必须离线部署的时候,发现因为依赖的问题感觉就会头大,不过还好,今天发现一个比较简单的离线部署方法,就简单记录一下.首先是下载包

 wget https://downloads.mysql.com/archives/get/p/23/file/mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz
 tar -xvf mysql-8.0.23-linux-glibc2.12-x86_64.tar.xz 
 mv mysql-8.0.23-linux-glibc2.12-x86_64 mysql
 groupadd mysql
 useradd -g mysql mysql
 chown -R mysql.mysql mysql

但是mysql也需要安装一下依赖包,这里把联网和离线的两种方式都记录一下

 dnf -y install libaio-devel
 yum -y install libaio-devel

联网就直接安装,如果离线的话,先找一个和要安装目标一样的系统,然后在本地做个虚拟机,把依赖包下载不安装,然后打包传到目标机器,在安装即可

 yumdownloader --resolve libaio-devel --releasever=8
 把libaio-devel打包上传到目标机器
 rpm -i *
 find /usr/lib* -name "libtinfo.so.6"
 sudo ln -s /path/to/libtinfo.so.6 /usr/lib/libtinfo.so.5

依赖环境已经做好了,下面就开始直接安装mysql即可

 cd mysql/bin/
 ./mysqld --user=mysql --basedir=/apps/works/server/mysql --datadir=/apps/works/data/mysql --initialize
 2025-03-12T05:06:45.945880Z 0 [System] [MY-013169] [Server] /apps/works/server/mysql/bin/mysqld (mysqld 8.0.23) initializing of server in progress as process 1292945
 2025-03-12T05:06:45.945906Z 0 [ERROR] [MY-010338] [Server] Can't find error-message file '/apps/works/service/mysql/share/errmsg.sys'. Check error-message file location and 'lc-messages-dir' configuration directive.
 2025-03-12T05:06:45.952601Z 1 [System] [MY-013576] [InnoDB] InnoDB initialization has started.
 2025-03-12T05:06:46.590315Z 1 [System] [MY-013577] [InnoDB] InnoDB initialization has ended.
 2025-03-12T05:06:47.706941Z 6 [Note] [MY-010454] [Server] A temporary password is generated for root@localhost: n/3r6<gsG44s #密码
 chmod +x /etc/init.d/mysql
 cp ../support-files/mysql.server /etc/init.d/mysql
 chmod +x /etc/init.d/mysql
 chkconfig --add mysql
 ln -s /apps/works/server/mysql/bin/mysql /usr/bin/

编译后会提示一个随机密码,然后配置一下mysql的启动脚本,需要注意的是,在启动脚本中需要修改一下mysql的根目录以及数据目录,要不会是默认的.启动成功之后需要修改一下默认密码

 CREATE USER 'root'@'%' IDENTIFIED BY '1111111';
 ​
 ALTER USER 'root'@'localhost' IDENTIFIED BY '1111111';

一个不限制访问密码,一个限制访问密码,修改之后就可以通过远程连接数据库了.