H - Stash

1. Start the MySQL client by entering the following command:

   mysql -uUser -pPassword

   For example, if your MySQL user name (also known as an account name) and password are Tara and Telly3, then enter the following command:

   mysql -uTara -pTelly3

   If you don’t have a password, omit the -p argument as follows:

   mysql -uTara

   If you didn’t define a user name while configuring your MySQL installation, enter root as the user name, as follows:

   mysql -uroot

   The MySQL client’s command prompt appears, as follows:

   mysql>

2. Create a new database by entering the following command at the MySQL prompt:

   mysql>CREATE DATABASE TrioMotors;

   MySQL creates a new database, but it doesn’t contain any tables or records yet.

3. Log out of the MySQL client by entering the following command at the prompt:

   mysql>quit;

This entry was posted on Tuesday, April 14th, 2009 at 6:50 pm and is filed under Uncategorized. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.