You’re going to want to add Python to your Path Environment Variable in this way. Go to:
- My Computer
- System Properties
- Advance System Settings
- Under the “Advanced” tab click the button that says “Environment Variables”
- Then under System Variables you are going to want to add / change the following variables:
PYTHONPATH
andPath
. 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:
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
- Can’t connect to local MySQL server through socket ‘/tmp/mysql.sock
- Setting Django up to use MySQL
- Escape string Python for MySQL
- ImportError: No module named MySQLdb
- How to install Python MySQLdb module using pip?
- What is the easiest way to clear a database from the CLI with manage.py in Django?
- Failed building wheel for mysql-python
- Error loading MySQLdb module: No module named ‘MySQLdb’
- How to use mysqli_query() in PHP?
- Access denied for user ‘root@localhost’ (using password:NO)
- Getting TypeError: __init__() missing 1 required positional argument: ‘on_delete’ when trying to add parent table after child table with entries
- ERROR 1698 (28000): Access denied for user ‘root’@’localhost’
- MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
- How do I quickly rename a MySQL database (change schema name)?
- What does SQL Select symbol || mean?
- Django upgrading to 1.9 error “AppRegistryNotReady: Apps aren’t loaded yet.”
- When to use SELECT … FOR UPDATE?
- ERROR 1396 (HY000): Operation CREATE USER failed for ‘jack’@’localhost’
- pip install mysql-python fails with EnvironmentError: mysql_config not found
- Django – no such table exception
- Getting “Lock wait timeout exceeded; try restarting transaction” even though I’m not using a transaction
- Search for all occurrences of a string in a mysql database
- #1045 – Access denied for user ‘root’@’localhost’ (using password: YES)
- How to convert a string to date in MySQL?
- MySQL COUNT DISTINCT
- How to update a record using sequelize for node?
- Can’t open the mysql.plugin table. Please run mysql_upgrade to create it
- Convert MySQL to SQlite [closed]
- Create a temporary table in a SELECT statement without a separate CREATE TABLE
- ImportError: No module named mysql.connector using Python2
- Convert partially non-numeric text into number in MySQL query
- MySql: is it possible to ‘SUM IF’ or to ‘COUNT IF’?
- MySQL: What’s the difference between float and double?
- How can I search (case-insensitive) in a column using LIKE wildcard?
- MySQL Select Multiple VALUES
- SQL – IF EXISTS UPDATE ELSE INSERT INTO
- How to unblock with mysqladmin flush hosts
- Node.js MySQL – Error: connect ECONNREFUSED
- Solution to “subquery returns more than 1 row” error
- MySQL Error #1071 – Specified key was too long; max key length is 767 bytes
- How To have Dynamic SQL in MySQL Stored Procedure
- MySQL – UPDATE query with LIMIT
- MySQL said: Documentation #1045 – Access denied for user ‘root’@’localhost’ (using password: NO)
- __init__() got an unexpected keyword argument ‘user’
- What SQL Query to do a simple find and replace
- Scanning Database for malicious Data
- how to refresh wordpress permalink settings? (without admin panel)
- Ordering posts by day (not time) AND meta value
- wpdb->prepare function remove single quote for %s in SQL statment
- Problems with DBDelta with FOREIGN key?
- Alternative to mysql_real_escape_string
- Is it useful to turn on MySQL query cache for performance
- Programmatically changing role information; editing role name and deleting
- Search and replace in post content
- How to add 2 hours to the wordpress time formed with current_time(“mysql”, false)?
- wpdb insert and boolean fields
- 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)
- What are the issues associated with upgrading MySQL for WordPress?
- How to find meta entries with their posts missing via SQL?
- Mysql SELECT posts
- #1115 – Unknown character set: ‘utf8mb4’
- How to add a private user page populated from sql?
- Slow wp-admin due to “SELECT DISTINCT post_mime_type FROM wp_posts WHERE post_type = ‘attachment'”
- Which is better and faster ? WordPress Queries or SQL Query
- Using WPDB->Insert()
- Active DB queries in WordPress?
- Changing MySQL password via WHM – does this affect WordPress?
- Run Username SQL Query from WordPress Child Theme Functions File
- SQL syntax error. However, it works normally at phpmyadmin
- string literals in query
- MySQL query for taxonomy-meta
- Editing mysql tables/database with wordpress or other app/cms
- Create pages from MySQL database
- Sql – Search with serialized Data / better database concept
- WordPress unescape text on mysql?
- Getting data from Mysql Table..confusing
- Exporting completed webiste for another server
- SQL Statement – Mass Delete Custom Post Types
- Ubuntu 12.04, Nginx and MySQL issue with WordPress Database
- latency problems with wordpress install (from SQL import)
- mysql – Delete keyword with link from wordpress post database
- Creating dynamic content and pages for 1000’s of locations
- Remove duplicate media entries from mysql database
- mysqli_sql_exception: Unknown column ‘wp_’ in ‘field list’ PHP 8
- In a MySQL query, one of the columns in the LEFT JOIN returns “Unknown column”
- DB option update with wp-cli
- Find locations of all featured images of draft posts via SQL
- wpdb insert into point column in db
- 403 Forbidden home on localhost with nginx server
- WPDB delivers wrong results from complex queries
- How to change link in all posts?
- #1115 – Unknown character set: ‘utf8mb4’
- Get data from 3rd table
- Why can’t I connect to imported WP DB on local MAMP?
- Need SQL query to find&replace image URL
- InnoDB: Error: log file ./ib_logfile0 is of different size
- Postgres equivalent to MySQL’s \G?
- Postgres equivalent to MySQL’s \G?
- How to check what port mysql is running on