Importerror no module named mysqldb : Cause and Fix

importerror no module named mysqldb error comes because of improper binary extension compilation issue of Internal files. The solution is to recompile it in Binary format or you may use pure python binding. In this article, We will see the practical ways to fix this error.

importerror no module named mysqldb ( Solution ) –

mysqldb is the most popular database in python frameworks. We often connect with databases while web API development. In some real scenarios, we encounter such a problem where this import error comes out. Let’s see the methods to fix this.

Method 1 :

The most promising way to fix this error is to install PyMySQL . Here is the command to install the PyMySQL.

pip install PyMySQL

This command will install the latest version for PyMySQL. But in addition to it, We can define the version with it also. This is really important while shipping any software. Suppose you developed the code with version V1 but later on it is updated with V2. Now the same command will create a version incompatibility issue. Hence the best practice is to add the version with them.

Method 2 :

The other alternative here is to use the conda package manager for installing pymysql. It’s similar to pip but the command will be –

conda install -c anaconda pymysql

I think if you try those above mention steps, You will easily fix the error you are getting “importerror no module named mysqldb”. If you are still facing the issue, please let us know. Our team will connect with you on the same. The article is quite generic but for specific errors like the same, please do not hesitate to comment in the comment box.

Apart from the above error, you may ask for the solution to any similar issue while programming. Thanks for reading the whole article.

Data Science Learner Team