Steps to setup MySQL Client(Sequel Pro) for Mac OS

Step 1: Download & Install mysql for Mac OS.

http://www.mysql.com/downloads/mysql/

Step 2: To set up Sequel Pro mysql client,  go to http://www.sequelpro.com/ and download Sequel Pro, MySQL database management for Mac OS X.

Step 3: Download and install Sequel Pro.

Step 4: Navigate to Applications -> Sequel Pro. Double click it to open it.

Step 5: 

Enter 127.0.0.1 as host and click the connect button to login to mysql database. Use "Test connection" button to test the user login connectivity. 

Ps Note: you are connecting as a "test" user.  The "test" user login do not have db privilege to create database. This user can only be used to check out existing sample database.

For creating database, login as root user. Check the below screenshot for details.

Ps Note: When installing the MySQL database, I created the root username with no password.  Due to this setup, I was able to login to root user account without entering password. If you have provided the password during the install time, you need to provide the same password to login to root user account.

Step 6: After login, click the "Choose Database" drop down to check out the available options.

Step 7: Select 'Add Database' option to proceed with database creation. Enter Database Name, select Database Encoding option from the drop down and click the Add button to complete the database creation step.

Step 8: Next step is to proceed further by creating database tables. Click the + icon on the bottom left hand side to get to the table creation wizard. Enter the table name, table encoding and table type details to proceed with the table creation wizard.

Step 9: Click the "+" icon to create columns. Use "-" icon to delete columns.  Check out the below screenshot for details.

Step 10: Continue with your work. Good luck.