Usefull Mysql Commands.

How to check mysql connection or login to your Database using shell
=========================
root@hostdens[#] mysql -u username -p
=========================
it will ask for password then provide the correct password.

Create Database on the Mysql Server
=========================
mysql> create database [databasename];
=========================
ex : mysql>create database Dresses;

List all databases on the sql server.
===========================
mysql> show databases;
===========================

To List all tables in the Database.

==========================
mysql> show tables;
==========================

To check the table Constraints or Describe table
==========================
mysql> describe [table name];
==========================

To Delete a Database
==========================
mysql> drop database [database name];
==========================

To delete a table.
==========================
mysql> drop table [table name];
==========================

Command to give privileges to the user

root@server[#]mysql

grant all privileges on hostdens_wrdp1.* to hostdens_wrdp1@localhost identified by ‘hostdens123′;

database name = hostdens_wrdp1
db user name = hostdens_wrdp1
db pass = hostdens123