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. How to use mysqli_query() in PHP?
  11. Access denied for user ‘root@localhost’ (using password:NO)
  12. Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
  13. ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
  14. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  15. How do I quickly rename a MySQL database (change schema name)?
  16. What does SQL Select symbol || mean?
  17. Django upgrading to 1.9 error “AppRegistryNotReady: Apps aren’t loaded yet.”
  18. When to use SELECT … FOR UPDATE?
  19. ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
  20. pip install mysql-python fails with EnvironmentError: mysql_config not found
  21. Django – no such table exception
  22. Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
  23. Search for all occurrences of a string in a mysql database
  24. #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
  25. How to convert a string to date in MySQL?
  26. MySQL COUNT DISTINCT
  27. How to update a record using sequelize for node?
  28. Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
  29. Convert MySQL to SQlite [closed]
  30. Create a temporary table in a SELECT statement without a separate CREATE TABLE
  31. ImportError: No module named mysql.connector using Python2
  32. Convert partially non-numeric text into number in MySQL query
  33. MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
  34. MySQL: What’s the difference between float and double?
  35. How can I search (case-insensitive) in a column using LIKE wildcard?
  36. MySQL Select Multiple VALUES
  37. SQL – IF EXISTS UPDATE ELSE INSERT INTO
  38. How to unblock with mysqladmin flush hosts
  39. Node.js MySQL – Error: connect ECONNREFUSED
  40. Solution to “subquery returns more than 1 row” error
  41. MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
  42. How To have Dynamic SQL in MySQL Stored Procedure
  43. MySQL – UPDATE query with LIMIT
  44. MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
  45. __init__() got an unexpected keyword argument ‘user’
  46. What SQL Query to do a simple find and replace
  47. Scanning Database for malicious Data
  48. how to refresh wordpress permalink settings? (without admin panel)
  49. Ordering posts by day (not time) AND meta value
  50. wpdb->prepare function remove single quote for %s in SQL statment
  51. Problems with DBDelta with FOREIGN key?
  52. Alternative to mysql_real_escape_string
  53. Is it useful to turn on MySQL query cache for performance
  54. Programmatically changing role information; editing role name and deleting
  55. Search and replace in post content
  56. How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
  57. wpdb insert and boolean fields
  58. WordPress installation on valet php 8 (PHP Fatal error: Uncaught mysqli_sql_exception Table ‘wp_options’ doesn’t exist in wp-includes/wp-db.php:2056)
  59. What are the issues associated with upgrading MySQL for WordPress?
  60. How to find meta entries with their posts missing via SQL?
  61. Mysql SELECT posts
  62. #1115 – Unknown character set: ‘utf8mb4’
  63. How to add a private user page populated from sql?
  64. Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
  65. Which is better and faster ? WordPress Queries or SQL Query
  66. Using WPDB->Insert()
  67. Active DB queries in WordPress?
  68. Changing MySQL password via WHM – does this affect WordPress?
  69. Run Username SQL Query from WordPress Child Theme Functions File
  70. SQL syntax error. However, it works normally at phpmyadmin
  71. string literals in query
  72. MySQL query for taxonomy-meta
  73. Editing mysql tables/database with wordpress or other app/cms
  74. Create pages from MySQL database
  75. Sql – Search with serialized Data / better database concept
  76. WordPress unescape text on mysql?
  77. Getting data from Mysql Table..confusing
  78. Exporting completed webiste for another server
  79. SQL Statement – Mass Delete Custom Post Types
  80. Ubuntu 12.04, Nginx and MySQL issue with WordPress Database
  81. latency problems with wordpress install (from SQL import)
  82. mysql – Delete keyword with link from wordpress post database
  83. Creating dynamic content and pages for 1000’s of locations
  84. Remove duplicate media entries from mysql database
  85. mysqli_sql_exception: Unknown column ‘wp_’ in ‘field list’ PHP 8
  86. In a MySQL query, one of the columns in the LEFT JOIN returns “Unknown column”
  87. DB option update with wp-cli
  88. Find locations of all featured images of draft posts via SQL
  89. wpdb insert into point column in db
  90. 403 Forbidden home on localhost with nginx server
  91. WPDB delivers wrong results from complex queries
  92. How to change link in all posts?
  93. #1115 – Unknown character set: ‘utf8mb4’
  94. Get data from 3rd table
  95. Why can’t I connect to imported WP DB on local MAMP?
  96. Need SQL query to find&replace image URL
  97. InnoDB: Error: log file ./ib_logfile0 is of different size
  98. Postgres equivalent to MySQL’s \G?
  99. Postgres equivalent to MySQL’s \G?
  100. How to check what port mysql is running on

Leave a Comment