ZestyBeanz Technologies Pvt Ltd 4th Floor, Nila, Technopark Thiruvananthapuram,
India – 695581
Phone: +91 471 4063254
Fax : +91 471 2700171


ZestyBeanz Technologies Pvt Ltd
2987, Manikkath Cross Road
Ravipuram, Kochi, India - 682016
Phone: +91 484 4063254


ZestyBeanz Technologies FZE
P.O Box 53261 HFZA, Sharjah Phone: +971-24915431​


ZestyBeanz Technologies UG
Ingolstädter Str. 91
90461 ​Nürnberg
Fon: +49 911 480899-48
Fax: +49 911 480899-99


Contact Form

Shobin Markose's picture

Important MySQL Commands

Here I am trying to give a full instant guide to Mysql commands that will help people for their easy usage.

To login (from unix shell) use -h only if needed.
# [mysql dir]/bin/mysql -h hostname -u username -ppassword
To login (from windows)
mysql dir/bin/mysql.exe -h hostname -u username -ppassword

Create a database.
mysql> create database [databasename];

List all databases on the server.