How to install Python MySQLdb module using pip?

It’s easy to do, but hard to remember the correct spelling:

pip install mysqlclient

If you need 1.2.x versions (legacy Python only), use pip install MySQL-python

Note: Some dependencies might have to be in place when running the above command. Some hints on how to install these on various platforms:

Ubuntu 14, Ubuntu 16, Debian 8.6 (jessie)

sudo apt-get install python-pip python-dev libmysqlclient-dev

Fedora 24:

sudo dnf install python python-devel mysql-devel redhat-rpm-config gcc

Mac OS

brew install mysql-connector-c

if that fails, try

brew install mysql

Related Posts:

  1. Install mysql-python (Windows)
  2. Escape string Python for MySQL
  3. How do I update\upgrade pip itself from inside my virtual environment?
  4. How do I update\upgrade pip itself from inside my virtual environment?
  5. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  6. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  7. How to install pip with Python 3?
  8. ‘pip’ is not recognized as an internal or external command
  9. How to update/upgrade a package using pip?
  10. How do I update\upgrade pip itself from inside my virtual environment?
  11. How to update/upgrade a package using pip?
  12. How to use mysqli_query() in PHP?
  13. bash: pip: command not found
  14. bash: pip: command not found
  15. How to uninstall a package installed with pip install –user
  16. How to uninstall pip on OSX?
  17. How can I install packages using pip according to the requirements.txt file from a local directory?
  18. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  19. ImportError: No module named pip
  20. ImportError: No module named pip
  21. “pip install unroll”: “python setup.py egg_info” failed with error code 1
  22. How do I install pip on macOS or OS X?
  23. Pip freeze vs. pip list
  24. How do I install pip on macOS or OS X?
  25. How can I install pip on Windows?
  26. “pip install unroll”: “python setup.py egg_info” failed with error code 1
  27. ImportError: No module named tensorflow
  28. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  29. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  30. Column count doesn’t match value count at row 1
  31. Where is BeautifulSoup4 hiding?
  32. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  33. MySQL string replace
  34. Cannot add or update a child row: a foreign key constraint fails
  35. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  36. String concatenation in MySQL
  37. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  38. Where does pip install its packages?
  39. Cannot add or update a child row: a foreign key constraint fails
  40. MySQL Error “Operand should contain 1 column”
  41. Where does pip install its packages?
  42. How to install python3 version of package via pip on Ubuntu?
  43. Could not install packages due to an EnvironmentError:
  44. How to use MySQL DECIMAL?
  45. Access denied for user ‘root@localhost’ (using password:NO)
  46. Could not find a version that satisfies the requirement tensorflow
  47. How do I install a Python package with a .whl file?
  48. pip/python: normal site-packages is not writeable
  49. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  50. How to make MySQL table primary key auto increment with some prefix
  51. Access denied for user ‘root@localhost’ (using password:NO)
  52. MySQL ERROR 1290 (HY000) –secure-file-priv option
  53. “Defaulting to user installation because normal site-packages is not writeable” python message
  54. Could not find a version that satisfies the requirement tensorflow
  55. How do I install a Python package with a .whl file?
  56. How to install pytorch in Anaconda with conda or pip?
  57. MySQL error 2006: mysql server has gone away
  58. “ssl module in Python is not available” when installing package with pip3
  59. Which MySQL data type to use for storing boolean values
  60. Can’t fix “zipimport.ZipImportError: can’t decompress data; zlib not available” when I type in “python3.6 get-pip.py”
  61. Configuring so that pip install can work from github
  62. import opencv vs import cv2
  63. No module named ‘psycopg2’
  64. Is #include bad practice?
  65. How to pip or easy_install tkinter on Windows
  66. sql query with multiple where statements
  67. python3 command not found after installing python with pyenv
  68. Conda uninstall one package and one package only
  69. pip or pip3 to install packages for Python 3?
  70. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  71. Error after upgrading pip: cannot import name ‘main’
  72. filename.whl is not supported wheel on this platform
  73. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  74. Cannot delete or update a parent row: a foreign key constraint fails
  75. Cannot delete or update a parent row: a foreign key constraint fails
  76. “ssl module in Python is not available”
  77. “E: Unable to locate package python-pip” on Ubuntu 18.04 [duplicate]
  78. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  79. MySQL server startup error ‘The server quit without updating PID file’
  80. Permission denied error by installing matplotlib
  81. Updating matplotlib in virtualenv with pip
  82. Rename a column in MySQL
  83. ImportError: cannot import name main when running pip –version command in windows7 32 bit
  84. filename.whl is not a supported wheel on this platform
  85. E: unable to locate package pip
  86. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  87. Cannot delete or update a parent row: a foreign key constraint fails
  88. What is the difference between pip and conda?
  89. bash: pip: command not found
  90. “E: Unable to locate package python-pip” on Ubuntu 18.04 [duplicate]
  91. MySQL server startup error ‘The server quit without updating PID file’
  92. How do I restore a dump file from mysqldump?
  93. How to know the version of pip itself
  94. Syntax error due to using a reserved word as a table or column name in MySQL
  95. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  96. MySQL root password change
  97. Installation of MySQL for Visual Studio 1.2.8 failed
  98. Not unique table/alias
  99. How do I import an SQL file using the command line in MySQL?
  100. How to install pip3 on Windows?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)