MacOSX Sierra中PyCharm无法导入MySQLdb模块连接MySQL如何解决？

Hey there, let's tackle this MySQL connection issue on macOS Sierra step by step— I’ve run into similar headaches before, so I know exactly where to look.

先搞定系统层面的依赖 #

macOS Sierra often lacks the necessary compilation tools and MySQL libraries to build packages like mysqlclient. Let's fix that first:

• Update Homebrew (if you don’t have it installed, grab it from the official site first):

  brew update
  

• Install MySQL and its development headers:

  brew install mysql mysql-connector-c
  

• Add MySQL’s bin directory to your PATH to ensure tools like mysql_config are found:

  echo 'export PATH="/usr/local/mysql/bin:$PATH"' >> ~/.bash_profile
  source ~/.bash_profile
  

• Also make sure Xcode Command Line Tools are fully installed (critical for compiling packages):

  xcode-select --install
  

  If you get a "already installed" message, reset it with xcode-select --reset to fix any corrupted paths.

针对你的PyCharm虚拟环境安装mysqlclient #

Since you’re using a virtual environment (venv) in PyCharm, we need to make sure we install the package inside that environment:

1. Activate your virtual environment first— either use PyCharm’s built-in terminal (it should activate automatically) or run this in your system terminal:

   source /Users/muhammed/Desktop/PyhtonHomework/venv/bin/activate
   

2. Upgrade pip to the latest version to avoid installation bugs:

   pip install --upgrade pip
   

3. Install mysqlclient with the necessary environment variables to bypass Sierra’s compilation quirks:

   export LDFLAGS="-L/usr/local/opt/mysql/lib"
   export CPPFLAGS="-I/usr/local/opt/mysql/include"
   pip install mysqlclient
   

   If that still fails, try explicitly pointing to MySQL’s install path:

   pip install --global-option=build_ext --global-option="-I/usr/local/mysql/include" --global-option="-L/usr/local/mysql/lib" mysqlclient
   

如果mysqlclient还是不行，用pymysql作为替代 #

pymysql is a pure-Python MySQL connector that doesn’t require compilation— super reliable for tricky macOS setups:

1. Install it in your virtual environment:

   pip install pymysql
   

2. You can either use it directly, or make it mimic MySQLdb so your existing import MySQLdb code works:

   # Add this at the top of your script
   import pymysql
   pymysql.install_as_MySQLdb()
   
   # Now you can use MySQLdb like normal
   import MySQLdb
   conn = MySQLdb.connect(
       host="localhost",
       user="your_mysql_username",
       passwd="your_mysql_password",
       db="your_database_name"
   )
   

Double-check PyCharm’s interpreter configuration #

Sometimes PyCharm might be using the wrong Python interpreter (not your venv), which makes it look like the package isn’t installed:

• Open PyCharm’s Preferences (press Cmd + , on Mac)
• Navigate to Project: PyhtonHomework > Python Interpreter
• Make sure the selected interpreter is /Users/muhammed/Desktop/PyhtonHomework/venv/bin/python
• If not, click the gear icon in the top-right, select Add, and navigate to your venv’s Python executable to add it.

Quick sanity check #

Don’t forget to make sure your MySQL server is running! Start it with Homebrew:

brew services start mysql

内容的提问来源于stack exchange，提问作者Muhammed Gül