[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

!!! NOTE !!!

I'm custom-installing MacPorts in /macports instead of /opt/local
So, whenever you see /macports/... in a dialog-box,
you'll have to substitute with /opt/local/...

}}} == 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]