I was working on a personal MySQL project and encountered this issue, which says:
"No module named MySQLdb"
So I went to the terminal and typed pip install mysqlclient
I was welcomed with this screen:
<img src="http://api.codewithharry.com/media/blogFiles/no-module-named-mysql-error/base64.png" width="1018" height="471" />
The error says that windows failed to build MySQL extension from scratch.
&lt;|AD|&gt;
<h4>How to solve this error?</h4>
All you need to do is go to the unofficial binaries for windows 10 page and download the mysqlclient from there.&nbsp;
Step1: Go to google and type "Unofficial Python Binaries."
<img src="http://api.codewithharry.com/media/blogFiles/no-module-named-mysql-error/base64_9NTJf1x.png" width="941" height="587" />
Step 2: Click the first link and search for mysqlclient
<img src="http://api.codewithharry.com/media/blogFiles/no-module-named-mysql-error/base64_lESm7P8.png" width="1127" height="556" />
&lt;|AD|&gt;
Step 3: Click on mysqlclient and download the wheel file for your OS.
<img src="http://api.codewithharry.com/media/blogFiles/no-module-named-mysql-error/base64_TVVpkFS.png" width="617" height="787" />
I am using the 32-bit version of python and python 3.8, so I will download the cp-38-win32 wheel.
Step 4: Download the wheel and go to the folder where this wheel file is downloaded.
<img src="http://api.codewithharry.com/media/blogFiles/no-module-named-mysql-error/base64_YXngkNr.png" width="838" height="824" />
Step 5: cd into the directory where this wheel file is downloaded and run the "pip install mysqlclient-1.4.6-cp38-cp38-win32.whl" command.
The wheel file I downloaded was named mysqlclient-1.4.6-cp38-cp38-win32.whl,<a title="[96&nbsp;KB] [Jun 10, 2019]"> so I ran.</a>
&lt;|AD|&gt;
<pre class="language-python"><code>pip install mysqlclient-1.4.6-cp38-cp38-win32.whl</code></pre>
This will install mysqlclient on windows, and your error will be solved! Let me know if this helped you in fixing this issue in your windows machine.
<img src="http://api.codewithharry.com/media/blogFiles/no-module-named-mysql-error/base64_Htplhdo.png" width="1023" height="244" />
Note: If you are a beginner and don't know what cd into a directory means, you can go to the folder where you downloaded this wheel file and press shift, and right-click on some empty area to get an option called "Open command prompt/Powershell window here." This command will open the command prompt in the directory where you have downloaded this wheel file. Now you can type pip install Pyaudio-file-name.whl

[Solved] No Module Named MySQLdb in Windows 10

Add a new comment