راهنمای راه‌اندازی پایگاه داده از راه دور برای بهینه‌سازی عملکرد سایت با MySQL روی Ubuntu

sudo nano /etc/mysql/mysql.conf.d/mysqld.cnf

bind-address = db_server_ip

require_secure_transport = on

sudo mysql_ssl_rsa_setup --uid=mysql

sudo systemctl restart mysql

sudo ufw allow mysql

sudo mysql -u root -p

CREATE DATABASE wordpress DEFAULT CHARACTER SET utf8 COLLATE utf8_unicode_ci;

CREATE USER 'local_db_user'@'localhost' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON wordpress.* TO 'local_db_user'@'localhost';

CREATE USER 'remote_user'@'web_server_ip' IDENTIFIED BY 'password';
GRANT ALL PRIVILEGES ON wordpress.* TO 'remote_user'@'web_server_ip';
FLUSH PRIVILEGES;

sudo apt install php-curl php-gd php-intl php-mbstring php-soap php-xml php-xmlrpc php-zip

sudo systemctl restart php7.4-fpm

location ~* \.(css|gif|ico|jpeg|jpg|js|png)$ {
    expires max;
    log_not_found off;
}
location / {
    try_files $uri $uri/ /index.php$is_args$args;
}

sudo nginx -t
sudo systemctl reload nginx

cd /tmp
curl -LO https://wordpress.org/latest.tar.gz
tar xzvf latest.tar.gz

cp /tmp/wordpress/wp-config-sample.php /tmp/wordpress/wp-config.php

sudo cp -a /tmp/wordpress/. /var/www/your_domain
sudo chown -R www-data:www-data /var/www/your_domain

define('DB_NAME', 'wordpress');
define('DB_USER', 'remote_user');
define('DB_PASSWORD', 'remote_user_password');
define('DB_HOST', 'db_server_ip');
define('MYSQL_CLIENT_FLAGS', MYSQLI_CLIENT_SSL);