Setting up MySQL 4.0.x for Workbench

Scope
Obtain, Install the Software, and start the MySQL Server
Set the user environment
Configure the database instance for Workbench Server access
Create the WorkbenchDB database

Scope

This document describes how to setup MySQL datastore for Workbench.

Note

Workbench has been tested against the following STANDARD binary distributions:
version 4.0.18 on the following plaforms:
RedHat Linux 7.2 Kernel v2.4.20 (mysql-standard-4.0.18-pc-linux-i686.tar.gz)
Mac OS X kernel v7.2.0 (mysql-standard-4.0.18-apple-darwin6.8-powerpc.tar.gz)
Microsoft Windows XP/Server 2003/Windows 2000 (mysql-4.0.24-win.zip installed as a windows service)

Obtain, Install the Software, and start the MySQL Server

Refer to http://www.mysql.com site for details in regards to the use of and instructions for downloading and installing the software, and starting the server.

Warning

Workbench maintains a persistent connection to the MySQL database. Depending on the combination of the O/S and version of MySQL, this persistent connection may terminate if workbench has been idle for a duration greater then the MySQL wait_timeout global variable. This variable is set to 8 hours by default (28800 seconds). Please refer to MySQL documentation in increasing this value to a reasonable duration if the persistent connection does terminate. ControlTier recommends 604800 seconds as a reasonable default.

Set the user environment

Define the MYSQL_HOME and PATH environment variables. for unix:

	  MYSQL_HOME=<MYSQL_HOME>
	  export MYSQL_HOME

	  PATH=$MYSQL_HOME/bin:$PATH
	  export PATH

for win32:

	  set MYSQL_HOME=<MYSQL_HOME>

	  set PATH=%MYSQL_HOME%\bin:%PATH%

Note

Replace <MYSQL_HOME> with the path to to the mysql software installation.

Configure the database instance for Workbench Server access

Run the mysql client as the root database user

	  mysql -p -u root 
	  (enter c/r for password)

Run the following SQL statements after the mysql prompt:

GRANT ALL ON WorkbenchDB.* TO 'ctier'@'localhost' IDENTIFIED BY '<CtierPassword>';
GRANT ALL ON WorkbenchDB.* TO 'ctier'@'<WorkbenchHost>' IDENTIFIED BY '<CtierPassword>';
exit

Note

Replace <CtierPassword> with the desired password for the mysql ctier user. Replace <WorkbenchHost> with the hostname of the machine running the Workbench Server. Access to the mysql database server as root may require special privlidges granted by your database administrator.

Create the WorkbenchDB database

	  mysql -p -u ctier
	  (enter password for ctier user)

	  create database WorkbenchDB;
	  exit