A site about Talend
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'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.
To install MySQL Server & Workbench, I chose the DMG download option, for Mac OSX.
I downloaded the following two files.
Open the MySQL Server DMG. This should look something like the screenshot below.
There are two installable packages, here, and I installed both.
Open the MySQL Server package and follow the instructions.
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
There's not much to say about this installation. It's a fairly standard Mac OSX Installation.
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.
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.
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.
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.
If all looks good here, you can hit Continue.
There was no need to make any changes here, I simply hit Continue.
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.
This screen provides an opportunity to review settings. As this is a very basic installation, for tutorial purposes, I simply hit Continue.
This is the finance step in the process. I simply hit Continue to accept the default value.
Your Server Instance should now be created and available for use, as shown in the screenshots below.
Open the root connection from, hit the button and then create a new schema named TalendByExample, or a name of your choice.
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.
Now select the Schema Privileges tab, to give your new user priviledges to the schema that you have just created.comments powered by Disqus