MySQL¶

Mysql is another fairly popular database engine, it's fast, easy to setup and easy to maintain. We recommend sqlite more, but you may use mysql if you really want.

Using MySQL as your local database¶

Add these to your django environment variables.

.env

DATABASE_TYPE=mysql
DATABASE_HOST=
DATABASE_PORT=3306
DATABASE_NAME=myfinances# you can choose this, but must first create it (STEP 2)
DATABASE_USER=admin
DATABASE_PASS=

DATABASE_HOST¶

This is the main host of your database, for example if ran locally would be "127.0.0.1", if on aws might be mydb.123456789012. eu-west-2.rds.amazonaws.com.

DATABASE_PORT¶

This is the port of your host, mysql is likely 3306 though. May be at the end of your DATABASE_HOST, make sure to remove it!

DATABASE_NAME¶

This is the name of your database that you created. You will have to do this manually.

First access your db

$ mysql -h {DATABASE_HOST} -u {DATABASE_USER} -p {DATABASE_PASS} # manually fill out the values in brackets {}

Then run this SQL command:

CREATE DATABASE myfinances # you can call "myfinances" whatever you like

Use this "myfinances" or whatever you called it in the DATABASE_NAME variable

DATABASE_USER¶

This is the user that you use to login to your mysql server with, might be "root" or "admin"

DATABASE_PASS¶

This is the password that you use to login to your mysql server with

More on environment variables can be through our guides: env files and env files for pycharm professional

Run django migrate command

python manage.py migrate

And that's it - Good luck! Create an issue or discussion if you continue you gain errors, and one of us will help you out :)