MySQL commands list. MySQL using the terminal.. MySQL guides, tutorials and help

Date Posted: Sunday 07th of February 2010 | Category: MySQL

MySQL commands list. MySQL using the terminal.
MySQL commands list. MySQL using the terminal.
Here is a list of commands that can be entered in the terminal to create, drop, show and use MySQL

You first need access to MySQL. Enter the following command in the terminal:-

mysql -u root -p

Enter your MySQL password. The MySQL command prompt should now be visible in the terminal.

MySQL Commands List
To create a new database enter the following in the terminal:-

mysql> create database test;

To delete the database enter the following in the terminal:-

mysql> drop database test;

To exit MySQL enter the following in the terminal:

mysql> \c

Then enter

mysql> exit

MySQL will display the message BYE