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.

Vagrant Ubuntu Virtual Machine - Step by Step Installation

Vagrant and Installation

Step 1: Installing Virtualbox

Download Oracle Virtulabox from https://www.virtualbox.org/ install virtual box.

Step 2: Installing Vagrant

Download vagrant from https://www.vagrantup.com/downloads.html and install to local machine.

Step 3: Installing Vagrant Host-Manager

Run below commands to install vagrant manager.

$vagrant plugin install vagrant-hostmanager

Step 4: Create vagrant working directory

$mkdir VagrantBox

$cd VagrantBox

$mkdir ubuntu64

$cd ubuntu64

Step 5: Run ubuntu virtual machine

$ vagrant box add {title} {url}

e.g.,

$vagrant box add ubuntu64 https://cloud-images.ubuntu.com/vagrant/trusty/current/trusty-server-cloudimg-amd64-vagrant-disk1.box

Refer: http://www.vagrantbox.es/ for url

Step 6: Initiate vagrant ubuntu machine

$ vagrant init {title}

$ vagrant up

Step 7: A ubuntu machine will start, and requests for username and password. Provide below username and password and start using virtual machine.

username: vagrant

password: vagrant