Pentaho Common Errors : Driver class 'org.gjt.mm.mysql.Driver' could not be found

Error Message
Error connecting to database [MySQLDev] : org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.
org.gjt.mm.mysql.Driver
org.pentaho.di.core.exception.KettleDatabaseException:
Error occured while trying to connect to the database
Driver class 'org.gjt.mm.mysql.Driver' could not be found, make sure the 'MySQL' driver (jar file) is installed.
org.gjt.mm.mysql.Driver
 at org.pentaho.di.core.database.Database.normalConnect(Database.java:415)
 at org.pentaho.di.core.database.Database.connect(Database.java:353)
 at org.pentaho.di.core.database.Database.connect(Database.java:306)

 

 Resolution

 Pentaho version : PDI 5.0.2
OS                      : Linux CentOS release 6.2

1) Download latest MySQL jdbc connector.

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

Download platform independent TAR archive for Linux OS.
ZIP Archive can be used for Windows.

2) Copy jar file to folder.

• Locate tar file.

           [root@localhost Downloads]# ls
           mysql-connector-java-5.1.29.tar.gz
           [root@localhost Downloads]#

• Unzip the file using following command.

            [root@localhost Downloads]# tar -zxvf mysql-connector-java-5.1.29.tar.gz

• Copy file to folder pentaho/design-tools/data-integration/lib/

            cp mysql-connector-java-5.1.29-bin.jar /opt/pentaho/design-tools/data-integration/lib/

 3) Restart Spoon.