Expert Consultancy from Yellow Pelican

Install MySQL Server 5.6.x

A site about Talend

Install MySQL Server 5.6.x

All of the database tutorials and reference material on this site are, at the time of writing, based on MySQL 5.6.x. That's not to say that they are not relevant to you working with other database vendors; however, I've had to select one database and MySQL seems to be a sensible choice - that anyone can download and use. All of our tutorial and reference material can be easily translated for your use with other database vendors and, where appropriate, I have made reference to specific features that other vendors support.

You may download an install the community edition of mySQL, from here.

You will find it helpful to download and install both the MySQL Community Server and MySQL Workbench.

You'll see that the screenshots and comments here have a slant towards Mac OSX. This is simply because this is that platform that I've used for writing these tutorials. If you are using a different platform, then, although the installation procedures may be less helpful, much of the setup and configuration still will be.

Installation

To install MySQL Server & Workbench, I chose the DMG download option, for Mac OSX.

I downloaded the following two files.

mysql-5.6.12-osx10.7-x86_64.dmg
mysql-workbench-gpl-5.2.47-osx-i686.dmg

Installing MySQL Server

Open the MySQL Server DMG. This should look something like the screenshot below.

Image 1

There are two installable packages, here, and I installed both.

MySQL Server

Open the MySQL Server package and follow the instructions.

MySQL Startup Item

Open the MySQL Startup Item package and follow the instructions.

Installing this option allows you to easily start and stop your MySQL Server, using the following commands.

sudo /Library/StartupItems/MySQLCOM/MySQLCOM start
sudo /Library/StartupItems/MySQLCOM/MySQLCOM stop

Installing MySQL Workbench

There's not much to say about this installation. It's a fairly standard Mac OSX Installation.

Setup of MySQL

These notes are based on a fresh install of MySQL Server and some initial configuration; which was sufficient to complete our tutorials.

First of all, start MySQL Server (see above) and launch MySQL Workbench.

Create a New Server Instance

With a fresh install of MySQL Server, you will have no MySQL Server instances, as shown in the screenshot below. To create a new Instance, hit New Server Instance.

Image 1

Specify the Host Machine the Database Server is running on

You have two basic options here, Localhost or Remote Host. I chose the default option of Localhost, as this is where I've installed MySQL Server.

Image 2

Set the Database Connection Values

I left all of the default values, here, and chose root as the Username. Note that the default root password for MySQL is root and you should change this.

Image 3

Testing the Database Connection

If all looks good here, you can hit Continue.

Image 4

Specify the installation type for your target operating system

There was no need to make any changes here, I simply hit Continue.

Image 5

Testing Host Machine Settings

For installations on Mac OSX, Error: File /etc/my.conf doesn't exist appears. A quick Google shows that this is an expected error for new installations. I simply hit Continue to proceed.

Image 6

Review Server Instance Setting

This screen provides an opportunity to review settings. As this is a very basic installation, for tutorial purposes, I simply hit Continue.

Image 7

Create the Instance Profile

This is the finance step in the process. I simply hit Continue to accept the default value.

Image 8

Server Instance Created

Your Server Instance should now be created and available for use, as shown in the screenshots below.

Image 9

Image 10

Create TalendByExample schema

Open the root connection from, hit the Image 12 button and then create a new schema named TalendByExample, or a name of your choice.

Image 11

Create tbe (TalendByExample) User

Return to the Home screen and then open Manage Security. Here, you can create the tbe user, or a name of your choice. Complete the dialog, as shown below. When completed, hit the Apply button.

Image 13


Now select the Schema Privileges tab, to give your new user priviledges to the schema that you have just created.




Expert Consultancy from Yellow Pelican
comments powered by Disqus

© www.TalendByExample.com