Django连接MySQL执行dbshell报错：mysql程序未安装或不在路径

Hey there, let's work through this issue step by step—you've got two small but critical things to address here:

1. First, Correct Your Database Port Configuration #

Wait a minute, you set PORT to 5432 in your settings.py—that's the default port for PostgreSQL, not MySQL! MySQL uses 3306 by default. Let's fix that first:

DATABASES = {
    'default': {
        'ENGINE': 'django.db.backends.mysql',
        'NAME': 'maison',
        'USER': 'root',
        'PASSWORD': '1234',
        'HOST': '127.0.0.1',
        'PORT': '3306',  # Swap this to MySQL's default port
    }
}

2. Fix the "mysql program not found" Error for dbshell #

The python manage.py dbshell command tries to launch your system's native MySQL command-line client (the mysql executable), not just the Python MySQL driver you might have installed. Here's how to fix this based on your operating system:

For Windows #

• If you haven't installed the MySQL command-line client yet:
  1. Download the MySQL Installer from MySQL's official site.
  2. Run the installer, choose "Custom" setup, and make sure you check the MySQL Command Line Client option under "MySQL Server" > "Client Programs".
  3. After installation, locate the bin folder in your MySQL install directory (usually C:\Program Files\MySQL\MySQL Server 8.0\bin).
  4. Add this bin folder path to your system's PATH environment variable:
     • Right-click "This PC" > "Properties" > "Advanced system settings" > "Environment Variables".
     • Under "System variables", find Path, click "Edit", then "New", and paste the bin folder path.
  5. Restart your terminal/command prompt and try dbshell again.

For macOS #

• Option 1: Install just the MySQL client with Homebrew:

  brew install mysql-client
  

  Then add its path to your shell config (.zshrc or .bashrc):

  echo 'export PATH="/usr/local/opt/mysql-client/bin:$PATH"' >> ~/.zshrc
  source ~/.zshrc
  

• Option 2: Install the full MySQL server (which includes the client):

  brew install mysql
  

For Linux (Ubuntu/Debian) #

Install the MySQL client package with apt:

sudo apt-get update && sudo apt-get install mysql-client

For CentOS/RHEL:

sudo yum install mysql-community-client  # You may need to enable the MySQL repo first

Alternative Way to Verify Connection (Without dbshell) #

If you just want to confirm your Django app can talk to the MySQL database, you don't need dbshell—try running:

python manage.py inspectdb

If this outputs a list of Django model definitions (even empty ones for your new maison database), your connection is working correctly. You can also test it in a Python shell:

python manage.py shell

Then run:

from django.db import connection
cursor = connection.cursor()  # No error means connection is good!

内容的提问来源于stack exchange，提问作者khadija.EL