Connect to Database - MySQL (How does Django connect to MySQL/MariaDB database)
MySQL is one of the most popular database. It is fast and reliable. It is easy to learn and administer. It uses Standard Structured Query Language(SQL).
MariaDB is just another implementation of MySQL
HOW TO INSTALL MYSQL
1. Visit the official website - https://dev.mysql.com/downloads/ to download the database depending on the OS you are using. You can use community editions which are free to use.
2. For Windows, visit https://dev.mysql.com/downloads/installer/
3. For ubuntu, visit https://dev.mysql.com/downloads/repo/apt/
4. To install on ubuntu, follow the guide https://dev.mysql.com/doc/mysql-apt-repo-q...
5. An installation of MariaDB server is already demonstrated in this video.
6. To install MySQL on Mac, visit https://dev.mysql.com/doc/mysql-installati...
CONNECT MYSQL GRAPHICALLY
1. To connect a MySQL service graphically for east administration, you can install SQLYog software. Visit https://webyog.com/product/sqlyog/
2. You can also install community edition of DBeaver software which is free to use. Visit https://dbeaver.io/download/
PACKAGE USED BY DJANGO TO CONNECT TO MYSQL
mysqlclient is the package required by Django to successfully connect to the MySQL server.
pip install mysqlclient
In the setting.py, connection can be created like this:
DATABASES = {
'default': {
'ENGINE': 'django.db.backends.mysql',
'NAME': 'developerdemo',
'USER': 'developerdemo',
'PASSWORD': 'Demo650##',
'HOST': 'localhost',
'PORT' : '3306',
}
}
