Tip : Install mysql driver in Pentaho Data Integration (Kettle)

1) Download mysql-connector-java-gpl-5.1.35.msi from

http://dev.mysql.com/downloads/connector/j/

2) Execute the .msi file. (As soon as you click on run button it executes and disappears). 

3) It'll create MySQL folder inside "Program Files(x86)". (Not the "Program Files")

    Go to below location "C:\Program Files (x86)\MySQL\Connector.J 5.1" and find 

     the "mysql-connector-java-5.1.35-bin.jar" file.

4) Copy this driver to lib folder of kettle .

i.e.,. copy driver in : pdi-ce-5.4.0.0-128\data-integration\lib

5) Start PDI and try giving connection to a mysql database .

Example : 

Resources : 

1) http://stackoverflow.com/questions/18894416/install-mysql-jdbc-driver-msi