Django – installing mysqlclient error: mysqlclient 1.3.13 or newer is required; you have 0.9.3

by

I guess your project uses pymysql instead of mysqlclient.

You can try to search the following code snippet in your project. If you find it, please try the following methods to fix this problem:

import pymysql
pymysql.install_as_MySQLdb()

Insert a line of code between these two to make it look like this:

import pymysql
pymysql.version_info = (1, 3, 13, "final", 0)
pymysql.install_as_MySQLdb()

Then try to start your project.

  • Why do I know you are using pymysql? Because 0.9.3 is just the latest version of pymysql.
  • Why use pymysql instead of mysqlclient for the project? Because it is easier to install. pymysql does not depend on system libraries, while mysqlclient relies on a series of system libraries such as libmysqlclient-dev.
  • Why is mysqlclient difficult to install and Django still uses it by default? Because mysqlclient is faster and performs better. So if your project has high performance requirements, I suggest you remove the compatible code above and install mysqlclient in your project. If you need help during the installation of mysqlclient, please refer to this link: How to install Python MySQLdb module using pip?, and ensure libssl-dev has been installed before pip install mysqlclient.

More Related Contents:

  1. How can I temporarily disable a foreign key constraint in MySQL?
  2. Problems with contenttypes when loading a fixture in Django
  3. Django MySQL full text search
  4. GROUP_CONCAT equivalent in Django
  5. What’s the best way to migrate a Django DB from SQLite to MySQL?
  6. How to use django models with foreign keys in different DBs?
  7. How to drop all tables from the database with manage.py CLI in Django?
  8. Database returned an invalid value in QuerySet.dates()
  9. Error installing mysqlclient for python on Ubuntu 18.04
  10. django cannot connect mysql in docker-compose
  11. Which DB technology is sued to solve the following search issue? [closed]
  12. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  13. How should I resolve –secure-file-priv in MySQL?
  14. node-mysql multiple statements in one query
  15. Select last row in MySQL
  16. MySQL LOAD DATA INFILE with ON DUPLICATE KEY UPDATE
  17. Difference between Key, Primary Key, Unique Key and Index in MySQL
  18. MySQL: Split comma separated list into multiple rows
  19. How to start MySQL with –skip-grant-tables?
  20. Setting Django up to use MySQL
  21. How can I access the MySQL command line with XAMPP for Windows?
  22. Difference in MySQL JOIN vs LEFT JOIN
  23. Get most recent row for given ID
  24. Update a column in MySQL
  25. Mysql covering vs composite vs column index
  26. Invalid default value for ‘create_date’ timestamp field
  27. Insert/ Update random date in MySQL
  28. The web application [] appears to have started a thread named [Abandoned connection cleanup thread] com.mysql.jdbc.AbandonedConnectionCleanupThread
  29. Execute INSERT if table is empty?
  30. MySQL data directory location

Leave a Comment