MySQL

Introduction

This page contains information and resources related to the MySQL database.

MacOS Setup

1. Download the community edition installer (i.e. .dmg file).
2. Follow the installation instructions.
3. Set your path so you have easy access to the mysql and mysqladmin commands via the command line by creating a .bash_login file in the root of your user home directory (if it does not exist already). It should have this line added to the end of the file: export PATH="/usr/local/bin:/usr/local/sbin:/usr/local/mysql/bin:$PATH". Type the following to run the newly updated script: . ~/.bash_login.
4. Download and install the MySQL GUI Tools (Administrator and Query Browser). Use the Administrator tool to setup your databases, user accounts, and privileges.

Tips and Tricks

• Unix Post-Installation Procedures - A good set of exercises to follow once you have finished installing MySQL. It will help you validate that you are installed and configured properly.
• Causes of Access-Denied Errors - Read this page in case you are having access and user account issues.