DATABASE DESIGN - SQL TABLES

Validating the MySQL Server Install

First locate the mysql command on your system.

Windows Users:

\connect

When the application is properly installed, run the application mySQL Shell:

At the prompt you can connect to the server that was installed on your local machine:

\connect root@localhost

The first time you run the command you will need to enter the password used during the install.

Once connected, run the \status command. You should see a similar output to the above screenshot.

Mac OS Users:

Open a terminal window from Applications|Utilities|Terminal

At the terminal window enter following commands:

1. Cd \

2. find – name mysql

3. Once the path of mysql is located, copy and run from the terminal.

Once the command is run, enter the \connect root@localhost command and \status as shown above.