Unable to install mysqlclient in python virtualenv

While installing mysqlclient in python virtualenv, some might have experienced issue like 

"failed building wheel for mysqlclient". This issue occurs mostly in Windows, to overcome this we need to download appropriate version of mysqlclient-xxx-xx.whl files, search for below files

Mysqlclient, a fork of the MySQL-python interface for the MySQL database.

• mysqlclient‑1.3.10‑cp27‑cp27m‑win32.whl
• mysqlclient‑1.3.10‑cp27‑cp27m‑win_amd64.whl
• mysqlclient‑1.3.10‑cp34‑cp34m‑win32.whl
• mysqlclient‑1.3.10‑cp34‑cp34m‑win_amd64.whl
• mysqlclient‑1.3.10‑cp35‑cp35m‑win32.whl
• mysqlclient‑1.3.10‑cp35‑cp35m‑win_amd64.whl
• mysqlclient‑1.3.10‑cp36‑cp36m‑win32.whl
• mysqlclient‑1.3.10‑cp36‑cp36m‑win_amd64.whl

and run the command

$ pip install mysqlclient-1.3.10.cp27m-win32.whl

you can see mysqlclient installed successfully.

Connecting to MySQL database in Google Compute Engine - Remote Access

This page help you to access MYSQL database in Google Compute Engine from your system or network.

1. Get your public IP address.
2. Open Google Compute Engine in browser window
3. Navigate to /etc/mysql/
4. Open my.cnf file and add line:  bind-address = <internal IP>
5. Restart mysql server: $ service mysql restart
6. Sign in as mysql root user: $mysql -u root -p
7. Create new user: mysql>CREATE USER 'user1'@'<internal-ip-my-client>' IDENTIFIED BY '<some-password>'
8. Provide access to the user: mysql> GRANT ALL PRIVILEGES ON *.* TO 'user1'@'<internal-ip-my-client>' IDENTIFIED BY '<some-password>'; 
9. Restart mysql server