PHP and MySQL Setup

Install and configure PHP 8.x and MySQL database server.

Intermediate25 min

Setup Steps

1. Install PHP 8.3:

sudo apt install php8.3 php8.3-fpm php8.3-mysql php8.3-xml php8.3-mbstring php8.3-curl php8.3-gd php8.3-zip php8.3-intl -y

2. Install MySQL 8:

sudo apt install mysql-server -y

3. Run MySQL security configuration:

sudo mysql_secure_installation

4. Check PHP version:

php -v

5. Start PHP-FPM:

sudo systemctl start php8.3-fpm
sudo systemctl enable php8.3-fpm

6. Edit php.ini settings:

sudo nano /etc/php/8.3/fpm/php.ini
# Recommended settings:
upload_max_filesize = 64M
post_max_size = 64M
max_execution_time = 300
memory_limit = 256M

7. Connect to MySQL:

sudo mysql -u root -p

8. Create a new database and user:

CREATE DATABASE myapp;
CREATE USER 'appuser'@'localhost' IDENTIFIED BY 'Password123!';
GRANT ALL PRIVILEGES ON myapp.* TO 'appuser'@'localhost';
FLUSH PRIVILEGES;

Related Guides

Linux VPS Server Setup (Ubuntu)

Configure your Ubuntu-based VPS server from scratch. Security, user management and basic settings.

Apache Web Server Setup

Install Apache HTTP server and configure virtual hosts.

Nginx Web Server Setup

Install Nginx web server and configure it as a reverse proxy.

Let's Encrypt SSL Certificate Setup

Get a free SSL/TLS certificate with Certbot and enable HTTPS.