...

Installation on Mac OS X

1. Download MySQL Community Server of MySQL Community Edition, version 5.6 or later, and follow the installation instructions including the postinstallation setup and testing.
2. MySQL gets installed to /usr/local/mysql-VERSION and also installs a symbolic link, /usr/local/mysql, that points to the new location.  By default, MySQL is set up with only a root account with no password.
3. Ensure the MySQL bin folder has been added to your PATH environment variable:
   • In TextEdit, navigate to your home folder (~ or /Users/<yourname>).
   • From the File menu, choose Open.
   • Press Cmd + Shift + . so that hidden files are shown, and select the .profile file.

   • Add the following line:

     Code Block
     language text theme DJango linenumbers true
     export PATH=$PATH:/usr/local/mysql/bin

   • You can also edit the .bash_profile file as done above using VI and add a line that appends /usr/local/mysql/bin to the PATH environment variable.
   • If you have a Terminal window open, be sure to close it and open a new one so that the PATH change takes effect.
4. Download the attached CreateExamplegearDatabase_v1.sql file to your local machine.
5. In the Terminal window,
   
   1. Navigate to the directory to which you downloaded the the attached CreateExamplegearDatabase_v1.sql file.

   2. Go into the mysql command line program as the root user by executing the following command:

      Code Block
      language text theme DJango linenumbers true
      mysql -u root mysql

   3. At the mysql prompt, execute the following command to create the database and populate it with data.

      Code Block
      language text theme DJango linenumbers true
      source CreateExamplegearDatabase_v1.sql

6. At this point you should have the following:
   1. A MySQL database named examplegeardb.
   2. A user account dbuser with a password of mypassword.
   3. These tables:
      1. Addresses
      2. Customers
      3. Departments
      4. Employees
      5. LineItems
      6. Products
      7. Ref_AddressTypeCode
      8. Ref_CountryCode
      9. Ref_EmployeeStatusCode
      10. Ref_OrderStatusCode
7. To support running SQL queries against the examplegeardb database using the SQL for Confluence (Express Edition) add-on or SQL for Confluence (Pro Edition) add-on, build a data source profile with the following information:

...

Database Schema