How to Install MySQL on PyCharm?

by

MySQLdb is an interface to an existing MySQL database server for Python.

Problem Formulation: Given a PyCharm project. How to install MySQL in your project within a virtual environment or globally?

Here’s a solution that always works:

  • Open File > Settings > Project from the PyCharm menu.
  • Select your current project.
  • Click the Python Interpreter tab within your project tab.
  • Click the small + symbol to add a new library to the project.
  • Now type in the library to be installed, in your example "mysql-python" without quotes, and click Install Package.
  • Wait for the installation to terminate and close all popup windows.

Here’s the installation process as a short animated video—it works analogously for the MySQLdb library, just type in “mysql-python” in the search field instead:

Make sure to select only “MySQL-python” that is the package name for the MySQLdb connector library:

Alternatively, you can run the pip install mysql-python command in your PyCharm “Terminal” view:

$ pip install mysql-python

Feel free to check out the following free email academy with Python cheat sheets to boost your coding skills!

To become a PyCharm master, check out our full course on the Finxter Computer Science Academy available for free for all Finxter Premium Members:

Programmer Humor – Blockchain

“Blockchains are like grappling hooks, in that it’s extremely cool when you encounter a problem for which they’re the right solution, but it happens way too rarely in real life.” source – xkcd