User Authentication System with Python Flask and MySQL

Requirements

- Download and install Python, I am using be using Python 3.7.2, make sure to check the box Add Python to PATH on the installation setup screen.

- Download and install MySQL Community Server and MySQL Workbench, you can skip this step if you already have a MySQL server set up.

- Install Python Flask with the command: pip install flask

- Install Flask-MySQLdb with the command: pip install flask-mysqldb

Major operations handled.

1). Form Design — Design a login and registration form with HTML5 and CSS3.
2). Templates — Create Flask templates with HTML and Python.
3). Basic Validation — Validating form data that is sent to the server (username, password, and email).
4). Session Management — Initialize sessions and store retrieved database results.
5). MySQL Queries — Select and insert records from/in our database table.
6). Routes — Routing will allow us to point our URL's to our functions.

Requirements and Packages used.
Download and install Python, for this tutorial I'll be using Python 3.7.2, make sure to check the box Add Python to PATH on the installation setup screen.
Download and install MySQL Community Server and MySQL Workbench, you can skip this step if you already have a MySQL server set up.
Install Python Flask with the command: pip install flask.
Install Flask-MySQLdb with the command: pip install flask-mysqldb.

Image description