Error loading MySQLdb module: No module named ‘MySQLdb’

MySQLdb is only for Python 2.x. You can’t install in Python 3.x versions. Now from your question i can see that you are working with Django. In this case you have three alternatives, from Django mysql notes:

  • mysqldb
  • mysqlclient
  • mysql-connect-python

This gives to you two alternatives, mysqlclient and mysql-connect-python, The first one requires compilation from extensions for the plugin and, in Windows, this implies VStudio Libraries and a know-how for compile native extensions.

mysql-connect-python is not compiled (and i don’t recommend this for production, maybe only for dev) so you are going to need to install this.

You can try:

pip3 install mysql-connect-python

or

pip3 install http://cdn.mysql.com/Downloads/Connector-Python/mysql-connector-python-2.0.4.zip

if the first one fails.

Related Posts:

  1. Can’t fix “zipimport.ZipImportError: can’t decompress data; zlib not available” when I type in “python3.6 get-pip.py”
  2. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  3. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  4. Setting Django up to use MySQL
  5. Django Rest Framework — no module named rest_framework
  6. TypeError: int() argument must be a string, a bytes-like object or a number, not ‘list’
  7. ImportError: No module named ‘django.core.urlresolvers’
  8. What is the easiest way to clear a database from the CLI with manage.py in Django?
  9. Use Gif Logo For Loading Screen In Kivy
  10. How can I make a time delay in Python? [duplicate]
  11. Python – TypeError: ‘int’ object is not iterable
  12. What is the difference between rw+ and r+
  13. Python – TypeError: ‘int’ object is not iterable
  14. Python: ‘ModuleNotFoundError’ when trying to import module from imported package
  15. What does the list() function do in Python?
  16. Invalid character in identifier
  17. Convert bytes to a string
  18. Python Error: AttributeError: __enter__ [duplicate]
  19. filedialog, tkinter and opening files
  20. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  21. Error in Python script “Expected 2D array, got 1D array instead:”?
  22. ‘str’ object has no attribute ‘decode’. Python 3 error?
  23. How to find all the indexes of a recurring item in a list?
  24. Name ‘xrange’ is not defined in Python 3 [duplicate]
  25. How to check Django version
  26. How do you use subprocess.check_output() in Python?
  27. Error: ” ‘dict’ object has no attribute ‘iteritems’ “
  28. (Help) TypeError: ‘str’ object cannot be interpreted as an integer
  29. How do order of operations go on Python?
  30. Why KeyError: 0
  31. How to upgrade pip3?
  32. Microsoft Visual C++ 14.0 is required (Unable to find vcvarsall.bat)
  33. TypeError: cannot convert the series to
  34. Pinging servers in Python
  35. Import error: No module name urllib2
  36. ‘End of statement expected’ in pycharm
  37. Change figure size and figure format in matplotlib
  38. How can I concatenate str and int objects?
  39. error: Failed to load the native TensorFlow runtime
  40. ImportError: No module named ‘encodings’
  41. TypeError(“‘bool’ object is not iterable”,) when trying to return a Boolean
  42. Get ZeroDivisionError: float division in python
  43. Python: tuple indices must be integers, not str when selecting from mysql table
  44. PermissionError: [WinError 5] Access is denied
  45. How to delete last item in list?
  46. Don’t understand this SyntaxError: illegal target for annotation
  47. Using Queue in python
  48. Converting int to bytes in Python 3
  49. How to get the current working directory using python 3?
  50. min() arg is an empty sequence
  51. “for line in…” results in UnicodeDecodeError: ‘utf-8’ codec can’t decode byte
  52. SyntaxError invalid token
  53. How do I format a string using a dictionary in python-3.x?
  54. For loop and ‘numpy.float64’ object is not iterable error
  55. django MultiValueDictKeyError error, how do I deal with it
  56. ImportError: No module named MySQLdb
  57. python mpl_toolkits installation issue
  58. Python sockets error TypeError: a bytes-like object is required, not ‘str’ with send function
  59. Pipenv: Command Not Found
  60. TypeError: ‘dict_keys’ object does not support indexing
  61. How to strip all whitespace from string
  62. Python Binomial Coefficient
  63. Pip – Fatal error in launcher: Unable to create process using ‘”‘
  64. pythonw.exe or python.exe?
  65. NumPy array is not JSON serializable
  66. pip install -r requirements.txt [Errno 2] No such file or directory: ‘requirements.txt’
  67. How to convert ‘binary string’ to normal string in Python3?
  68. Properly formatted multiplication table
  69. python3 TypeError: ‘function’ object is not iterable
  70. How to start from second index for for-loop
  71. How to compare individual characters in two strings in Python 3
  72. ModuleNotFoundError: No module named ‘seaborn’ in Python IDE
  73. Is there a ceiling equivalent of // operator in Python?
  74. Need to install urllib2 for Python 3.5.1
  75. Django reverse lookup of foreign keys
  76. ImportError: No module named ‘xlrd’
  77. Moving Average Pandas
  78. TypeError: ‘set’ object does not support indexing
  79. How to fix error “ERROR: Command errored out with exit status 1: python.” when trying to install django-heroku using pip
  80. Root mean square of a function in python
  81. H14 error in heroku – “no web processes running”
  82. What does this Django regular expression mean? `?P`
  83. Is it better to use path() or url() in urls.py for django 2.0?
  84. matplotlib: plot multiple columns of pandas data frame on the bar chart
  85. pip throws TypeError: parse() got an unexpected keyword argument ‘transport_encoding’ when trying to install new packages
  86. No module named django but it is installed
  87. What is the purpose of dollar sign in this Python3 string formatting expression?
  88. How to know/change current directory in Python shell?
  89. What does on_delete do on Django models?
  90. What is an easy way to implement fprintf in python?
  91. How to check if a user is logged in (how to properly use user.is_authenticated)?
  92. The view didn’t return an HttpResponse object. It returned None instead
  93. gunicorn.errors.HaltServer: django
  94. Generator expression must be parenthesized if not sole argument
  95. Does python have header files like C/C++?
  96. How to install NumPy for Python 3.6
  97. TypeError: got multiple values for argument
  98. IOError: [Errno 32] Broken pipe when piping: `prog.py | othercmd`
  99. Python webbrowser.open() to open Chrome browser
  100. __init__() got an unexpected keyword argument ‘user’

Leave a Comment