[wiki:howto <- Back to the HOWTO section]

= How to setup MySQL Workbench to work with MacPorts =

 * Audience: Intermediate Users
 * Requires: MacPorts >=1.9.2
 * Created: 23/06-2011
 * Revised: 24/06-2011 - modified install intructions
 * Author: Bjarne D Mathiesen (macintosh _at_ mathiesen _dot_ info)

{{{
#!html
<div style="text-align: center; background-color: yellow; color: red; padding: 2em;">
<h1>!!! NOTE !!!</h1>
<p>
I'm custom-installing MacPorts in <tt>/macports</tt> instead of <tt>/opt/local</tt><br>
So, whenever you see <tt>/macports/...</tt> in a dialog-box,<br>
you'll have to substitute with <tt>/opt/local/...</tt>
</p>
</div>
}}}

== Introduction ==

MySQL Workbench is a nice and advanced GUI frontend to administer MySQL databases. It's basically a GUI frontend to the mysql client and as such is similiar to the phpMyAdmin web-frontend .

The MySQL Workbench program make some assumptions as to where files are under Mac OS X - specifically the program assumes that MySQL has been installed from the *.dmg downloaded from MySQL.

This tutorial shows how to modify the default setting to get it to recognize the MacPorts install of MySQL5 as well as giving a very basic introduction in setting up a basic configuration that the postfixadmin port can use.

Many web-interfaces / web-services require a basic setup in the MySQL database in order to do their own configuration stuff.

== Installation ==

=== Step 1: '''Install and configure the mysql5 port''' ===

{{{
port install mysql5-server                          # install mysql5 from macports
cd /private/tmp                                     # the following command is executed as the _mysql user
                                                    # + so we'll have to be somewhere in the file system where
                                                    # + the _mysql user has write access
mysql_install_db5 --user=_mysql                     # install the default databases
port load mysql5                                    # start the mysqld server
ps -axj | grep mysql                                # check that the mysql server is running
/macports/lib/mysql5/bin/mysql_secure_installation  # secure the default installation
echo '[mysqld]' >> /macports/etc/mysql5/my.cnf      # create a very basic configuration file for mysql(d)
chown _mysql:_mysql /macports/etc/mysql5/my.cnf
chmod 664 /macports/etc/mysql5/my.cnf               # I'ld have preferred 660, but that conflicts with letting
                                                    # MySQL Workbench read the file as the current user
}}}

The following are the questions asked by mysql_secure_installation and the appropriate answers
{{{
Enter current password for root (enter for none):   # just hit [enter] as the database is new
Set root password? [Y/n] Y                          # we do want the root user to have a password
New password:                                       # enter at very secure password
Re-enter new password: 
Remove anonymous users? [Y/n] Y                     # anonymous users are not wanted !
Disallow root login remotely? [Y/n] Y               # root can only log in from localhost
Remove test database and access to it? [Y/n] Y      # we have no need for a test database
Reload privilege tables now? [Y/n] Y                # make sure the above settings are applied
}}}


== Configuration ==

=== Step 1: '''Install MySQL Workbench''' ===

Download and install the MySQL Workbench program from [http://wb.mysql.com/ MySQL Workbench]

=== Step 2: '''Modify the default settings in MySQL WorkBench''' ===
[[Image(MySQLWorkbench001.png)]]
[[Image(MySQLWorkbench002.png)]]
[[Image(MySQLWorkbench003.png)]]
[[Image(MySQLWorkbench004.png)]]
[[Image(MySQLWorkbench005.png)]]
[[Image(MySQLWorkbench006.png)]]
[[Image(MySQLWorkbench007.png)]]
[[Image(MySQLWorkbench008.png)]]
[[Image(MySQLWorkbench009.png)]]
[[Image(MySQLWorkbench010.png)]]
[[Image(MySQLWorkbench011.png)]]
[[Image(MySQLWorkbench012.png)]]
=== Step 3: '''Create a database / schema''' ===
[[Image(MySQLWorkbench013.png)]]
[[Image(MySQLWorkbench014.png)]]
[[Image(MySQLWorkbench015.png)]]
[[Image(MySQLWorkbench016.png)]]
[[Image(MySQLWorkbench017.png)]]
=== Step 4: '''Add some Users''' ===
[[Image(MySQLWorkbench018.png)]]
[[Image(MySQLWorkbench019.png)]]

== Optional Parts ==

=== '''TODO: What else can be done?''' ===

[wiki:howto <- Back to the HOWTO section]