Python: How to run flask mysqldb on Windows machine?

  • 11 months ago

1 / 1

To run a Flask application with MySQL database connectivity on a Windows machine, you can follow these steps:

  1. Install Python:
    If you don't have Python installed, download and install the latest version from the official Python website:

  2. Install Virtual Environment (Optional, but Recommended):
    It's a good practice to create a virtual environment for your project to isolate dependencies. Open a Command Prompt and run:

    pip install virtualenv
  3. Create and Activate Virtual Environment:
    Navigate to your project directory and create a virtual environment:

    cd your_project_folder
    virtualenv venv

    Activate the virtual environment:

  4. Install Flask and Flask-MySQLdb:
    Inside your virtual environment, install Flask and Flask-MySQLdb:

    pip install Flask Flask-MySQLdb
  5. Create Your Flask App:
    Create your Flask app using Flask and Flask-MySQLdb. Here's a simple example:

    from flask import Flask
    from flask_mysqldb import MySQL

    app = Flask(__name__)

    # Configure MySQL
    app.config['MYSQL_HOST'] = 'localhost'
    app.config['MYSQL_USER'] = 'your_username'
    app.config['MYSQL_PASSWORD'] = 'your_password'
    app.config['MYSQL_DB'] = 'your_database_name'

    mysql = MySQL(app)

    def hello():
    return 'Hello, Flask-MySQLdb!'

    if __name__ == '__main__':
  6. Run Your Flask App:
    In the Command Prompt, navigate to your project directory and activate the virtual environment if it's not already activated. Then run your Flask app:

  7. Access Your App:
    Open a web browser and go to http://localhost:5000/. You should see the "Hello, Flask-MySQLdb!" message.

Remember to replace 'your_username', 'your_password', and 'your_database_name' with your actual MySQL database credentials.

This example is a basic setup to help you get started. For a production application, you should consider more secure ways to handle database credentials, error handling, and other best practices.

Keep in mind that Flask-MySQLdb may have compatibility issues with MySQL 8. In such cases, you might want to consider using mysql-connector-python or other MySQL libraries for Flask.