Install mysql-python (Windows)

You’re going to want to add Python to your Path Environment Variable in this way. Go to:

  1. My Computer
  2. System Properties
  3. Advance System Settings
  4. Under the “Advanced” tab click the button that says “Environment Variables”
  5. Then under System Variables you are going to want to add / change the following variables: PYTHONPATH and Path. Here is a paste of what my variables look like:

PYTHONPATH

C:\Python27;C:\Python27\Lib\site-packages;C:\Python27\Lib;C:\Python27\DLLs;C:\Python27\Lib\lib-tk;C:\Python27\Scripts

Path

C:\Program Files\MySQL\MySQL Utilities 1.3.5\;C:\Python27;C:\Python27\Lib\site-packages;C:\Python27\Lib;C:\Python27\DLLs;C:\Python27\Lib\lib-tk;C:\Python27\Scripts

Your Path’s might be different, so please adjust them, but this configuration works for me and you should be able to run MySQL after making these changes.

Related Posts:

  1. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  2. Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
  3. Setting Django up to use MySQL
  4. Escape string Python for MySQL
  5. ImportError: No module named MySQLdb
  6. How to install Python MySQLdb module using pip?
  7. What is the easiest way to clear a database from the CLI with manage.py in Django?
  8. Failed building wheel for mysql-python
  9. Error loading MySQLdb module: No module named ‘MySQLdb’
  10. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  11. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  12. ‘pip’ is not recognized as an internal or external command
  13. How to use mysqli_query() in PHP?
  14. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  15. Access Denied for User ‘root’@’localhost’ (using password: YES) – No Privileges?
  16. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  17. Column count doesn’t match value count at row 1
  18. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  19. MySQL string replace
  20. Cannot add or update a child row: a foreign key constraint fails
  21. ERROR 1045 (28000): Access denied for user ‘root’@’localhost’ (using password: YES)
  22. String concatenation in MySQL
  23. What’s the difference between INNER JOIN, LEFT JOIN, RIGHT JOIN and FULL JOIN? [duplicate]
  24. Where does pip install its packages?
  25. Cannot add or update a child row: a foreign key constraint fails
  26. IndexError: tuple index out of range —– Python
  27. MySQL Error “Operand should contain 1 column”
  28. Where does pip install its packages?
  29. How to use MySQL DECIMAL?
  30. django: TypeError: ‘tuple’ object is not callable
  31. Access denied for user ‘root@localhost’ (using password:NO)
  32. Can’t connect to local MySQL server through socket ‘/var/mysql/mysql.sock’ (38)
  33. How to make MySQL table primary key auto increment with some prefix
  34. Access denied for user ‘root@localhost’ (using password:NO)
  35. MySQL ERROR 1290 (HY000) –secure-file-priv option
  36. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  37. MySQL error 2006: mysql server has gone away
  38. Which MySQL data type to use for storing boolean values
  39. Can’t fix “zipimport.ZipImportError: can’t decompress data; zlib not available” when I type in “python3.6 get-pip.py”
  40. No module named ‘psycopg2’
  41. Is #include bad practice?
  42. sql query with multiple where statements
  43. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  44. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  45. No module named MySQLdb
  46. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  47. Cannot delete or update a parent row: a foreign key constraint fails
  48. Cannot delete or update a parent row: a foreign key constraint fails
  49. ERROR 2003 (HY000): Can’t connect to MySQL server on localhost (10061)
  50. No module named MySQLdb
  51. MySQL server startup error ‘The server quit without updating PID file’
  52. How to check Django version
  53. Rename a column in MySQL
  54. “INSERT IGNORE” vs “INSERT … ON DUPLICATE KEY UPDATE”
  55. Cannot delete or update a parent row: a foreign key constraint fails
  56. MySQL server startup error ‘The server quit without updating PID file’
  57. How do I restore a dump file from mysqldump?
  58. Syntax error due to using a reserved word as a table or column name in MySQL
  59. How to switch Python versions in Terminal?
  60. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  61. MySQL root password change
  62. Installation of MySQL for Visual Studio 1.2.8 failed
  63. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  64. is not JSON serializable
  65. Not unique table/alias
  66. How do I import an SQL file using the command line in MySQL?
  67. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  68. #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
  69. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  70. Your password does not satisfy the current policy requirements
  71. How do I quickly rename a MySQL database (change schema name)?
  72. What does SQL Select symbol || mean?
  73. Django: ImproperlyConfigured: The SECRET_KEY setting must not be empty
  74. MySQL: Access denied for user ‘test’@’localhost’ (using password: YES) except root user
  75. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  76. django:django.core.exceptions.AppRegistryNotReady: Apps aren’t loaded yet
  77. mysql_config not found when installing mysqldb python interface
  78. SQL – Update multiple records in one query
  79. No module named pkg_resources
  80. Django upgrading to 1.9 error “AppRegistryNotReady: Apps aren’t loaded yet.”
  81. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  82. What is the definition of cardinality in SQL
  83. How to restart remote MySQL server running on Ubuntu linux?
  84. Authentication plugin ‘caching_sha2_password’ cannot be loaded
  85. MySQL DROP all tables, ignoring foreign keys
  86. #1055 – Expression of SELECT list is not in GROUP BY clause and contains nonaggregated column this is incompatible with sql_mode=only_full_group_by
  87. When to use SELECT … FOR UPDATE?
  88. Host ‘xxx.xx.xxx.xxx’ is not allowed to connect to this MySQL server
  89. Can’t compare naive and aware datetime.now() <= challenge.datetime_end
  90. Can’t connect to local MySQL server through socket ‘/var/lib/mysql/mysql.sock’ (2)
  91. Setting up foreign keys in phpMyAdmin?
  92. Select from multiple tables without a join?
  93. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  94. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  95. SQL Query Where Field DOES NOT Contain $x
  96. Create a new database with MySQL Workbench
  97. Duplicating a MySQL table, indices, and data
  98. django import error – No module named core.management
  99. Disable ONLY_FULL_GROUP_BY
  100. Forbidden (403) CSRF verification failed. Request aborted. Even using the {% csrf_token %}

Leave a Comment

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