1. Start the MySQL server by issuing the command mysqld-shareware –standalone at the prompt in c:\mysql\bin. Refer the previous session Installing MySQL on Windows for further details.

2. Now invoke the mysql client program by typing mysql at the prompt.

3. The prompt is changed to a mysql> prompt. Type:

4. create database employees;

5. The MySQL server responds with something like:

6. Query OK, 1 row affected (0.00 sec)

7. This means that you have sucessfully created the database. Now, let’s see how many databases you have on your system. Issue the following command.

8. show databases;
The server responds with the list of databases.

| Database |
| employees |
| mysql |
| test |
3 rows in set (0.00 sec)
Here we have three databases, two created by MySQL during installation and our employees database.
9. To come back to the DOS prompt, type quit at the mysql prompt.

Post By Editor (2,827 Posts)

Website: →