博客系统迁移服务器主要事项

// 更新apt
sudo apt update && sudo apt upgrade -y
// 安装NVM
// 按照文档安装nvm https://github.com/nvm-sh/nvm?tab=readme-ov-file#installing-and-upwehpwe
curl -o- https://raw.githubusercontent.com/nvm-sh/nvm/v0.40.4/install.sh | bash
// nvm安装报错就执行下面命令
// git config --global --unset http.proxy
// git config --global --unset https.proxy
// 找不到命令执行 source ~/.bashrc 

// 安装使用NODE和NPM
nvm install 22.17.0
nvm use 22.17.0
// 安装PM2 
npm install pm2 --global
// 安装MySQL
sudo apt install mysql-server
// 安装NGINX 
sudo apt install nginx
// 安装REDIS
sudo apt install redis-server -y

CREATE USER 'xiaoming'@'localhost' IDENTIFIED BY 'xiaoming2048!@#';
-- 全部权限
GRANT ALL PRIVILEGES ON dbname.* TO 'xiaoming'@'localhost';
-- 部分权限
GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,ALTER ON dbname.* TO 'xiaoming'@'localhost';
FLUSH PRIVILEGES;
-- 远程连接需要修改 /etc/mysql/mysql.conf.d/mysqld.cnf的bind-address = 0.0.0.0
-- 修改当前数据库用户密码 root
SELECT CURRENT_USER();
ALTER USER USER() IDENTIFIED BY 'root123456!@#';
-- systemctl restart mysql.service
-- systemctl status mysql.service

sudo mkdir /opt/jxapp
# 存放系统配置
sudo mkdir /opt/jxapp/config
# 部署前端
sudo mkdir /opt/jxapp/front && cd /opt/jxapp/front
sudo mkdir blog-admin zone-admin zone test-front
# 部署后端
sudo mkdir /opt/jxapp/server && cd /opt/jxapp/server
sudo mkdir blog-server zone-server/logs blog-home-nuxt blog-home-nuxt/output
# 给ubuntu用户权限
sudo chown -R ubuntu:ubuntu /opt/jxapp
# 上传静态资源、代码包、配置文件，然后解压
tar -xvf dist.tar

# 配置防火墙
sudo ufw allow 22/tcp    # SSH
sudo ufw allow 80/tcp    # HTTP
sudo ufw allow 443/tcp   # HTTPS
sudo ufw enable
cd /etc/nginx
sudo vim /etc/nginx/nginx.conf # 创建主配置文件
sudo vim /etc/nginx/conf.d/main.conf # 通用配置文件
sudo vim /etc/nginx/conf.d/jiang-xia.top.conf # server块为独立文件
sudo vim /etc/nginx/conf.d/admin.jiang-xia.top.conf # server块为独立文件
# 删除进入 粘贴模式 :%d | set paste | startinsert :wq保存退出
# 设置自动证书 文档 https://certbot.eff.org/instructions?ws=nginx&os=snap

-- 建立本地连接账号
CREATE USER 'jxzone'@'127.0.0.1' IDENTIFIED BY 'jxzone2048!@#';
GRANT ALL PRIVILEGES ON zone_db.* TO 'jxzone'@'127.0.0.1';
FLUSH PRIVILEGES;

CREATE USER 'jxblog'@'127.0.0.1' IDENTIFIED BY 'jxblog2048!@#';
GRANT ALL PRIVILEGES ON myblog.* TO 'jxblog'@'127.0.0.1';
FLUSH PRIVILEGES;