Mysql Workbench 5.6 Download Mac Updated

Mysql Workbench 5.6 Download Mac

aka "How to utilize multiple MySQL Servers and Workbench in Snow Leopard without using Concluding… and live happily always later"

The MySQL Customs is a earth of command-line aficionados. Many people, including myself, show their dearest to the uncomplicated-only-powerful interface of the mysql control-line client, only not everybody is keen to use a bash beat and requite upward its GUI, no thing how powerful the software is.

Until recently, GUI tools for MySQL were half baked solutions: in the end, in that location was always something that y'all had to do via the command line. Today, you can install, set upwardly and use MySQL on your Mac with Snow Leopard without using Terminal, at all.

My Special Needs

Before digging into the details of the installation, let me depict what I need on my Mac. I use various versions of MySQL and I often need to run two or more instances at the aforementioned fourth dimension. I constantly build, install and uninstall versions of MySQL and I need to find a way to quickly remove (or move) one version of MySQL with data, configuration files and all that is related to a specific case.

Not everybody has complicated environments and multiple instances; for many users, a single installation would be enough. If you are one of these lucky users, y'all may skip some steps. In any case, everything presented in this article is applicable to 1 or more instances running on a single Mac.

The Ingredients

All the software is bachelor on the MySQL Dev site. Yous will need two kits: MySQL Server and MySQL Workbench. I used the latest .dmg archive from http://dev.mysql.com/downloads and the latest version of Workbench, from hither http://dev.mysql.com/downloads/workbench/5.2.html. At the fourth dimension I am preparing this post, the latest versions are MySQL Server 5.6.0-m4 and MySQL Workbench five.two.27.

Training

I accept my own way of keeping multiple instances on a single mac, and I am sure you can find many others, perhaps they would brand even more sense for y'all. There are some good tools and scripts that may help you (simply google a bit or visit confidently Giuseppe Maxia's weblog: http://datacharmer.blogspot.com).

In a nushell, my way of keeping everything separated tin can be described every bit:

• Select a parent directory: in my case, I cull /usr/local. For example, the new version of the server will be available on /usr/local/mysql-5.5.vi-m4-osx10.6-x86_64. Everything related to this version is in there.
• Select a data directory: I simply apply the data sub-directory in the base directory. For an instance on a laptop, used for basic tests, that would be just fine.
• Go along the config files in the base directory: For instance, the configuration file, by default, would be /etc/my.cnf. I will employ /usr/local/mysql-5.5.vi-m4-osx10.6-x86_64/my.cnf instead.
• Select a socket file: in this case, I keep the socket file in the /tmp directory. My suggestion is to use a naming convention, such as mysql-<version>.sock. For example, the socket file for this version would exist mysql-five.6.0-m4.sock.
• Identify a specific TCP port for your version: avoid the default port (3306) and showtime from 3307 ore whatever other port. In this style, your customer tools will not accidentally connect to a server considering you forget to specify the TCP port.

Cooking Instructions

Once you have downloaded the software, you are ready to install it. You lot should beginning with MySQL Server. When you open the DMG archive, y'all should see something this:

MySQL Server Package

Just doubleclick on the chief bundle and follow the default instructions, and you lot are washed in literally 1 infinitesimal.

By default, the package creates a symbolic link to the base directory. You lot should see a base of operations dir created under /usr/local. Finder does not let yous to browse /usr/local, but if y'all get do Go To Binder in the Go carte, you can insert /usr/local in the binder text box and run into this window:

Go To Folder

As you can meet, there is a mysql sym link (/usr/local/mysql) and a new mysql-5.vi.0-m4-osx10.6-x86_64, which is the base directory that you lot have just installed.

Local Dir

My recommendation is to remove the mysql link, in order to avert whatsoever defoliation with multiple instances. Since the server has been installed with the superuser, you need to retype the superuser password over again to remove the link.

Another important betoken to consider is that the installer has created a base directory endemic by the superuser, with Read/Write access. Standard users have ReadOnly access. You should open the Info dialog (right click on the dir and select Become Info), then you should grant Read/Write access to anybody.

MySQL Base of operations Dir Info

Alter to RW

Now it'south time to install MySQL Workbench. This is an even easier task, since you lot just need to open the DMG archive to expose the application:

MySQL Workbench Package

The side by side step is to elevate and drop the Workbench icon into your favourite awarding folder or subfolder.

Like shooting fish in a barrel as ane..2..3, done. Just double click on Workbench and you will see the main window:

MySQL Workbench Habitation Page

The next step is to create a new server instance. Click on the New Server Case item on the right side of the main window and you will encounter this dialog:

Create New Server Case

The instance will run on your local Mac, so leave the radio push on localhost selected. By clicking the Go on push, yous volition see the adjacent page:

Create New Server Instance

Equally Connection Name, I used the version of the server (mysql-5.vi.0.-m4) and I have selected Local Socket every bit Connection Method. At present yous need to specify the socket file and path. I usually leave the file in the /tmp directory, therefore the file and path would be /tmp/mysql-v.vi.0-m4.sock.

I practice non have any relevant data in my instances, so a root admission with simple or no password is plenty. I use to store information technology in the Keychain, in order to avoid the request every time I need to open a new connection.

Store Password for Connection

By clickingProceed on the main dialog window, you will move to a testing page. Hither Workbench will try to connect to the server. Since the server is down, y'all will see a set up of errors, they are admittedly fine at this phase.

Testing the DB Connection

Past clicking Continue, you will be able to specify the operating system and the package yous are using. These combos are already selected for you as MacOS X and MySQL Package. When you will open the profile to modify some parameters, you will notice that the Installation Type will be dissimilar: this is absolutely normal, since Workbench identifies the fact that we have overridden some defaults as a custom installation.

Specifying the Bone

When you click Go along, you lot will examination the host settings and again, you volition run across some errors, due to the fact that the instance is not running (see prototype beneath).

Testing the Host Settings

Another click on the very same push button brings you to the MySQL Config Page. In this page you tin can specify the version of the server and the path to the configuration file. Personally I am very lazy and with fat fingers, so I adopt to meet the software to provide the path for me. I volition use the same fox adopted in Finder, i.e. I will type the outset or first two directories in the path, then I will click "…" to select the rest of the path:

Info About MySQL Conf

Specify Path to the Conf File

Here you tin can select the base directory and from the base directory you can select a file. My recommendation is to select the README file:

Select README

When you click the Open push, the README file and path will fill the Path text box. Now you lot can change README with my.cnf:

Change README to my.cnf

You are ready to click Keep over again. The next page shows you the commands used to administrate the server instance. You tin can leave these commands as is at the moment, you lot volition change them in a minute.

Commands to Manage the Server

The last click on Continue brings you lot to the final page, where you can requite a proper noun to the contour. Again, I used the version and the location to name the profile.

Create Instance Profile

You tin can finally create the Profile past clicking the Stop button. The result is a new example in the Server Administration area.

New Case Created

At present you may desire to change the way you administer the instance, by selecting more details that were not present in the wizard. Y'all tin do so past clicking the Manager Server Instances item.

The output window shows the connection parameters that have been fix in the wizard.

Director Server Instances - Connexion

By clicking System Profile, you lot will run across a new prepare of parameters. Some of them were not nowadays in the previous wizard, but you tin can review and change them at present. You may take noticed that the Installation Blazon is now Custom, because the path of the configuration file has changed. Now what you lot should practise is to update the offset and end commands in this page, since they still refer to the symbolic link that I removed.

Manage Server Instances – Organisation Profile

This is probably the trickiest role of the configuration. In general, the offset and stop commands require the privilege of superuser (or you must play more with the owneship and the grants of files and directories). I had lots of bug with the sudo commands and in the end I decided to use a trick. Again, this trick is not great, since it exposes my user password on the local machine, but I do not have whatsoever problem with that, and then I decided to adopt information technology. Basically, I added the sudo command to the get-go and stop lines and I unchecked the checkbox underneath. The result is that I practise not rely on the use of two commands combined in one activeness, but I tin can confidently test and execute a command in i become.

The final start and finish commands are something similar this:

Start:

echo mypwd | sudo -Southward /bin/sh -c "cd /usr/local/mysql-5.6.0-m4-osx10.half-dozen-x86_64; bin/mysqld_safe --defaults-file=my.cnf"

Terminate:

repeat mypwd | sudo -South /bin/sh -c "cd /usr/local/mysql-5.6.0-m4-osx10.6-x86_64; bin/mysqladmin -uroot --socket=/tmp/mysql-v.vi.0-m4.sock shutdown"

The concept is pretty unproblematic: you type a password and you pass it to a sudo command. The command and so executes a shell and passes the command string between quotes to the shell. If this explanation does not make sense to you, don't worry, just supersede mypwd with your machine password. Just recall, if you are using special characters, i.eastward. non digits or letters, y'all should use the \ symbol as prefix. Hence, the countersign "Good Chore!" should exist "Skillful\ Job\!". Y'all may notice that I take also removed the sudo command completely, only to avoid any misunderstanding.

Change Start-Stop

When y'all click the Shut button, yous are finally ready to go! Now you can doubleclick the new case profile and Workbench will try to connect to the case. Once more, MySQL is not running, so you should run into a dialog that alerts y'all and you should click Continue Anyway.

Open a MySQL Case

After few seconds, you lot volition see the main server instance window:

Server Example Window

The MySQL Server is stopped and you need to set few more parameters earlier yous tin have it up and running. Click the Configuration Item and commencement with the Full general tab. Here you lot should modify the TCP port (as brash, so you lot will not accidentally connect to whatever instance by default), the base directory and the data directory. The same play tricks to select a root directory first is applicable hither, since the two directories should be respectively /usr/local/mysql-5.half dozen.0-m4-osx10.vi-x86_64 and /usr/local/mysql-5.half dozen.0-m4-osx10.six-x86_64/data.

Instance Configuration - Full general

Once you lot take gear up the directories, you demand to modify a network parameter. Click the Networking tab and specify the socket file as we accept previously divers (/tmp/mysql-v.vi.0-m4.sock).

Instance Configuration - Networking

At present you lot can click the Employ push and create the my.cnf file for the very first time. The dialog that appears is simply a confirmation of the actions to accept. You will create the file by clicking Apply again.

Conf File Changes

You can finally select the server case again and click on Start Server. The outset time you start the server, let your Mac to work for 40-fifty seconds or fifty-fifty a minute or and so. MySQL needs to create the InnoDB files and information technology volition take a while.

Open Case

Finally, you lot will be rewarded with this screen:

Instance Running

Congratulations!

Now, you may fence it's overcomplicated, but again, everything is cocky contained and y'all tin can run equally many instances equally yous like at the same time, without touching the Concluding.

Savor!

As final scrap, you should check the connectedness parameters set by the wizard, past selecting the new connection on the left and clicking the Manage Connection option. Here, I would simply recommend to requite a good name to the connectedness.

Manage Connection

At present you lot tin can close the window and doubleclick the new connectedness. The query window will appear:

Open Connection

You lot can now first using the connection, past executing queries or creating objects with the SQL editor or with the data modeler.

Just the dazzler of Workbench is fabric for some other post!

Mysql Workbench 5.6 Download Mac

Posted by: graceycrepare.blogspot.com