Detailed process of installing and configuring MySQL, Python, and Nginx in Ubuntu

sudo systemctl status mysql

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

Unit  could not be found.

sudo apt-get install mysql-server

sudo service mysql start

# Check MySQL service statussudo service mysql status

# Or view the MySQL listening port via netstatsudo netstat -tap | grep mysql

# Use root user to connect to MySQL databasemysql -u root -p

# If you do not set the password, enter directly

USE mysql;

# Query user informationSELECT host, user, plugin, authentication_string FROM user;

# Modify the root user's password and set the authentication method to mysql_native_passwordALTER USER 'root'@'localhost' IDENTIFIED WITH mysql_native_password BY 'Your new password';

# Refresh permissionsFLUSH PRIVILEGES;

# Modify host from localhost to % to allow remote connection through tools such as NavicatUPDATE  SET host='%' WHERE user='root';

# Refresh permissionsFLUSH PRIVILEGES;

# Edit MySQL configuration filesudo vim /etc/mysql//

# Comment or modify the following configuration items:# bind-address = 127.0.0.1
# mysqlx-bind-address = 127.0.0.1

# Restart the MySQL service to apply configuration changessudo systemctl restart mysql

# Check whether MySQL is listening 0.0.0.0:3306sudo netstat -ntlp | grep mysql

# Check the firewall statussudo ufw status

# If you need to open port 3306sudo 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

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

 - A high performance web server and a reverse proxy server
   Loaded: loaded (/lib/systemd/system/; 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

# The default is port 80. If it is another port, the corresponding port will be opened.# Example: Open port 8000sudo ufw allow 8000/tcp

# Modify on server{} nodevim /etc/nginx/sites-enabled/default

server {
	listen 8000 ssl;
   	server_name ;
 
 	# Certificate Configuration   	ssl_certificate /etc/nginx/cert/.com_cert_chain.pem;
   	ssl_certificate_key /etc/nginx/cert/.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; # The forwarded address, that is, the address where Gunicorn runs       	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; # Client request body size limit	    
	    # Allow cross-domain access        add_header 'Access-Control-Allow-Origin' '*';   
        # Allowed HTTP methods        add_header 'Access-Control-Allow-Methods' 'GET, POST, PUT, DELETE, OPTIONS';   
        # Allowed custom request headers        add_header 'Access-Control-Allow-Headers' 'Content-Type, Authorization, X-Requested-With';   
        # Allow cookies (if required)        add_header 'Access-Control-Allow-Credentials' 'true';   
    }
	location /static { 
   		alias /usr/file/images/;
   		expires 30d; 
		client_max_body_size 100M; # Client request body size limit    }
}

nginx -t

service nginx reload