Install MySQL on Ubuntu for Django

Step 1: Install MySQL Server

sudo apt update
sudo apt install mysql-server -y

Step 2: Secure MySQL Installation

sudo mysql_secure_installation

Choose the following options during the setup:

• Validate password plugin: No (optional)
• Set root password: Yes
• Remove anonymous users: Yes
• Disallow root remote login: Yes
• Remove test database: Yes
• Reload privileges: Yes

Create a MySQL Database and User for Django

sudo mysql -u root -p

Then run the following SQL commands:

CREATE DATABASE django_db CHARACTER SET UTF8MB4 COLLATE utf8mb4_general_ci;

CREATE USER 'django_user'@'localhost' IDENTIFIED BY 'your_strong_password';

GRANT ALL PRIVILEGES ON django_db.* TO 'django_user'@'localhost';

FLUSH PRIVILEGES;

EXIT;

Update settings.py in Your Django Project

Configure the database section like this:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'django_db',
        'USER': 'django_user',
        'PASSWORD': 'your_strong_password',
        'HOST': 'localhost',
        'PORT': '3306',
    }
}

Run Django Migrations

python manage.py migrate