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 ne visible in the terminal.

MySQL Commands List

To create a new database enter the following in the terminal
create database gnulinux;

To delete the database enter the following in the terminal
drop database gnulinux;

To exit MySQL enter the following in the terminal:
\c
Then enter
exit

MySQL will display the message BYE
Home - Apache - Ubuntu - MySQL - PHP - Misc

The Ubuntu Counter Project - user number # 17415
Updated on: 2008-01-08 07:49:13