Introduction Creating a database in MySQL is exceptionally as you only have to execute one SQL statement after logging in. Step-by-Step Open a terminal and run the following commands. mysql -u root -p This will open the mysql> prompt. CREATE DATABASE mytest;
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. […]
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 […]
I have updated an earlier post on how to install MySQL 5.5 on Ubuntu 10.04 LTS. Importantly, the new instructions include how to add the MySQL 5.5 libs to the loader path. This is very important as it’s highly likely that you’ll build software that depends on these MySQL libraries. The updated instructions can be viewed at: MySQL 5.5 on Ubuntu 10.04 LTS.
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 […]