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

= TODO: title =

 * Audience: Intermediate Users
 * Requires: MacPorts >=1.9.2

== 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                          # intstall mysql5 from macports
sudo -u _mysql mysql_install_db5                    # 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 configuration file for mysql(d)
chown _mysql:_mysql /macports/etc/mysql5/my.cnf
chmod 664 /macports/etc/mysql5/my.cnf
}}}

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''' ===


== Optional Parts ==

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

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