sudo systemctl status mysql

● mysql.service - MySQL Community Server
   Loaded: loaded (/lib/systemd/system/mysql.service; enabled; vendor preset: enabled)
   Active: active (running) since ...

Unit mysql.service could not be found.

sudo apt-get install mysql-server

sudo service mysql start

# 檢查 MySQL 服務狀態(tài)
sudo service mysql status

# 或者通過 netstat 查看 MySQL 監(jiān)聽端口
sudo netstat -tap | grep mysql

# 使用 root 用戶連接 MySQL 數(shù)據(jù)庫
mysql -u root -p

# 如果沒有設置密碼，直接回車進入

USE mysql;

# 查詢用戶信息
SELECT host, user, plugin, authentication_string FROM user;

# 修改 root 用戶的密碼，并設置認證方式為 mysql_native_password
ALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY '你的新密碼';

# 刷新權限
FLUSH PRIVILEGES;

# 將 host 從 localhost 修改為 %，允許通過 Navicat 等工具遠程連接
UPDATE mysql.user SET host='%' WHERE user='root';

# 刷新權限
FLUSH PRIVILEGES;

# 編輯 MySQL 配置文件
sudo vim /etc/mysql/mysql.conf.d/mysqld.cnf

# 注釋或修改以下配置項：
# bind-address = 127.0.0.1
# mysqlx-bind-address = 127.0.0.1

# 重啟 MySQL 服務以應用配置更改
sudo systemctl restart mysql

# 檢查 MySQL 是否監(jiān)聽了 0.0.0.0:3306
sudo netstat -ntlp | grep mysql

# 檢查防火墻狀態(tài)
sudo ufw status

# 如果需要開放 3306 端口
sudo ufw allow 3306

python3 --version

python --version

sudo apt update
sudo apt install python3 python3-pip

python3 --version
pip3 --version

nginx -v

sudo systemctl status nginx

nginx.service - A high performance web server and a reverse proxy server
   Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
   Active: active (running) since Mon 2024-10-07 12:00:00 UTC; 1h 30min ago

nginx.service - A high performance web server and a reverse proxy server
   Loaded: loaded (/lib/systemd/system/nginx.service; enabled; vendor preset: enabled)
   Active: inactive (dead)

sudo apt update

sudo apt install nginx

sudo systemctl start nginx

sudo systemctl enable nginx

sudo systemctl status nginx

# 默認為80端口,若為其他端口,則開放相應端口
# 例: 開放8000端口 
sudo ufw allow 8000/tcp

# 在server{}節(jié)點修改
vim /etc/nginx/sites-enabled/default

server {
	listen 8000 ssl;
   	server_name ceshi.mrccoss.com;
 
 	# 證書配置
   	ssl_certificate /etc/nginx/cert/ceshi.mrccoss.com_cert_chain.pem;
   	ssl_certificate_key /etc/nginx/cert/ceshi.mrccoss.com_key.key;
 
   	ssl_session_cache shared:SSL:1m;
   	ssl_session_timeout  10m;
   	ssl_ciphers HIGH:!aNULL:!MD5;
   	ssl_prefer_server_ciphers on;
 
   	location / {
       	proxy_pass http://127.0.0.1:8001; # 轉發(fā)的地址，即Gunicorn運行的地址
       	proxy_redirect off;
   		proxy_set_header Host $host;
       	proxy_set_header X-Real-IP $remote_addr;
       	proxy_set_header X-Forwarded-For $proxy_add_x_forwarded_for;
       	proxy_set_header X-Forwarded-Proto $scheme;
	    client_max_body_size 100M; # 客戶端請求體大小限制
	    
	    # 允許http://example.com跨域訪問
        add_header 'Access-Control-Allow-Origin' '*';   
        # 允許的HTTP方法
        add_header 'Access-Control-Allow-Methods' 'GET, POST, PUT, DELETE, OPTIONS';   
        # 允許的自定義請求頭
        add_header 'Access-Control-Allow-Headers' 'Content-Type, Authorization, X-Requested-With';   
        # 允許攜帶Cookie(如果需要)
        add_header 'Access-Control-Allow-Credentials' 'true';   
    }
	location /static { 
   		alias /usr/file/images/;
   		expires 30d; 
		client_max_body_size 100M; # 客戶端請求體大小限制
    }
}

nginx -t

service nginx reload