All posts filed under: MySQL

Create a DB connection to MySQL in Kettle

comments 4
MySQL / Pentaho

Introduction Creating a DB connection from Kettle to MySQL involves creating a MySQL use who can access the DB in question, installing the JDBC driver, and creating a connection. Install the MySQL JDBC driver Download the MySQL JDBC driver from http://dev.mysql.com/downloads/connector/j/. Login to mysql.com, then click Download. cd ~/Downloads tar -xzf mysql-connector-java-5.1.20.tar.gz cd mysql-connector-java-5.1.20 cp mysql-connector-java-5.1.20-bin.jar ~/bin/data-integration/libext/ Create a MySQL user In this post, I am going to create a connection to the Sakila DB. […]

Install MySQL 5.5 on Ubuntu 12.04 LTS

Leave a comment
Linux / MySQL

Introduction Installing the MySQL package on Ubuntu is extremely simple. Installation Open a terminal and enter the following commands. sudo apt-get install mysql-client mysql-navigator mysql-server Type Y to accept the additional packages. Press Enter. After downloading and during installation, the MySQL configuration dialogs will display in the terminal. In the first dialog, press Enter. Enter a password for the MySQL root user. Press Enter. Reenter the root password. Press Enter. That’s it, MySQL is now […]

Install MySQL 5.5 on Ubuntu 10.04 LTS running in the Rackspace Cloud

comments 6
Linux / MySQL

Update April 23, 2012 I added new instructions for adding the MySQL libs to the loader path. Failure to add the libs to the loader path will cause errors when you try to run/build programs that depend on MySQL, such as installing the MySQL driver for Pyramid (Python). Update April 18, 2012 Thanks to Lampros for pointing out that WordPress was converting double dashes into single dashes “-“. I have updated the post so that […]