Setting up MySQL on OS X

MySQL is a popular database platform with connectivity options for many programming languages such as PHP, Perl, Python, TCL, C, Java etc. This means you can easily access this data from a variety of applications written in a variety of programming languages.

The Middleware Add-On is an option that allows Big Business to synchronize data with an external data source (MySQL) where it can be more readily accessed and copied to another system. This Solution describes installing MySQL for Mac OS X. (6168)

Here are the basic steps.

1. Download an installer .dmg from

2. Install mysql, its startup item, and preference pane.

3. Start mysql using the preference pane

4. Set a password (Copy and Paste the following line into Terminal):
/usr/local/mysql/bin/mysqladmin -u root password "newpassword"
Then backspace and replace newpassword and closing double-quote

5. Set access (Copy and Paste each line into Terminal):
/usr/local/mysql/bin/mysql -u root -p
grant all on *.* to "root"@"%";
set password for 'root'@'%' =password('newpassword');

6. Check the results and exit Terminal with:
select user, host, password from mysql.user;


  Chapter 24 Middleware

Return to Help