No module named 'mysql'

You are missing mysql package in your Python environment!

You got error message about missing Python package. The error happens when you try to import Python module mysql. The Python complains that mysql module can't be importend because its path is not present in your current Python path.

When using Python srcipt in your terminal your output with error message might look like this:

computer:~$

python -c "import mysql"

Traceback (most recent call last):
File "<string>", line 1, in <module>
ModuleNotFoundError: No module named 'mysql'

Are you using Python notebook? Then your code cell with error message looks similar to:

import mysql
---------------------------------------------------------------------------
ModuleNotFoundError Traceback (most recent call last) 
Cell In[1], line 1
----> 1 import mysql

ModuleNotFoundError: No module named 'mysql'

3 ways to fix - No module named mysql

Don't worry. We will fix the issue. You need to install missing package. We will show you 3 ways of how it can be fixed:

  • - install mysql using pip
  • - install mysql using conda
  • - automatic install of mysql in MLJAR Studio

Why there are three ways to fix this issue? It all depends on which package manager are you using. The most common package manager is pip. The common choice, especially in Windows environments, is conda manager. There are also other Python package managers, for example Poetry, but we don't cover them in this article.

The last way to fix issue, is to use MLJAR Studio. It is a notebook based programming environment that can automatically detect missing Python packages and install them.

How to check if package manager is pip or conda

Are you not sure what package manager are you using? Please try the following command and if you goet the conda version displayed it means that you are using conda package manager:

computer:~$

conda --version

conda 23.11.0
If conda is missing in your environment you will get output similar to:
computer:~$

conda --version

Command 'conda' not found

Please try the below code cell if you are in Python notebook. If you get no error then you are using conda otherwise please use pip for installing new packages.

import sys
!conda list --prefix {sys.prefix}

Install mysql with pip

Please run the following command to install mysql with pip:

pip install mysql-connector-python

If you are using virtual environment, please make sure that it is activated.

For Python notebook users, please use the following command:

import sys
!{sys.executable} -m pip install mysql-connector-python

This will ensure that a new package is installed in Python from currently used notebook kernel. You will be able to import mysql package in your notebook.

It is worth to check the PyPi website of mysql-connector-python. You can check there what is the current version and history of releases.

Install mysql with conda

The mysql package can be installed with the command:

conda install -c conda-forge mysql-connector-python

If you are in Python notebook, please use the following code:

import sys
!conda install --yes --prefix {sys.prefix} -c conda-forge {entry.installName}

The above code cell ensures you that mysql is installed in the correct environment and will be accessable in your current notebook. Please check mysql-connector-python conda-forge website to check latest version number and history of releases.

Automatic install of mysql in MLJAR Studio

MLJAR Studio is a notebook based programming environment. It offers a set of interactive Python code recipes to make coding super easy.

Each code recipe has information about required packages. If code recipe depends on mysql and it is not available in Python environment then you will get the below information.

Install packages

Please install below packages to use this code recipe.

mysql-connector-python >= 8.3.0

Please wait a while for mysql package installation after clicking Install package button. You will see below message:

Install packages

Please install below packages to use this code recipe.

Please wait, package installation ...

After successful installation you will get information that package is available and you can use code recipe.

Required packages

mysql-connector-python >= 8.3.0

You can focus on coding rather than fighting your python environment thanks to automatic package management.

What is mysql?

MySQL is an open-source relational database management system (RDBMS) that uses structured query language (SQL) for managing and manipulating databases. It stores data in tables and supports a wide range of operations like querying, updating, and managing relational data. MySQL is widely used in web applications, with platforms like WordPress and Drupal relying on it for data storage. It's known for its speed, reliability, and ease of use, making it a popular choice for both small and large-scale applications. It supports complex queries and transactions, ensuring data integrity and consistency.

Install more packages