How to Set Up a MySQL Database for a Mezzanine Project

Install MySQL server and python-mysqldb package:

sudo apt-get install mysql-server
sudo apt-get install python-mysqldb

Run MySQL:

mysql -u root -p

Create a database:

mysql> create database mezzanine_project;

Confirm it:

mysql> show databases;

Exit:

mysql> exit

Configure local_settings.py:

cd path/to/your/mezzanine/projectnano local_settings.py

Like following:

 1DATABASES = {
 2    "default": {
 3        "ENGINE": "django.db.backends.mysql",
 4        "NAME": "mezzanine_project",
 5        "USER": "root",
 6        "PASSWORD": "123456",
 7        "HOST": "",
 8        "PORT": "",
 9        }
10    }

Note: Replace your password

• python
• django
• mezzanine
• mysql
• database