Swordfish Tutorials
Installation of MySQL 5 in Mac OSX
Visit http://dev.mysql.com/downloads/mysql/5.0.html , scroll down to Mac OS X (package format) downloads and click on the Pick a mirror link to download a .dmg disk image.
After downloading the MySQL .dmg (use Safari, avoid Firefox) you will see a Finder window with 2 installable packages, a preferences panel and a README file. Do this:
- Install the two installable packages.
- Open System Preferences and then drag MySQL.prefPane to the main panel
- Open the MySQL preferences panel
- Select "Automatically Start MySQL Server on Startup"
- Start the server if it is not running
To create a database using MySQL 5 do this:
- Start Swordfish
- Select "Create Database" in Database menu
- Fill the dialogue as follows:
The default user is "root" without password.
That's all you need to use MySQL 5.x with Swordfish on Mac.
If you want to add new users or customise MySQL, get MySQL GUI Tools from http://dev.mysql.com/downloads/gui-tools/5.0.html