R-Ts NetWorks

Server the Best

Mysql Commands


Mysql Commands:

How to check mysql connection or login to your Database using shell
=========================
root@server[#] 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 test_wrdp1.* to test_wrdp1@localhost identified by ‘test123’;

database name = test_wrdp1
db user name = test_wrdp1
db pass = test123

Advertisements

December 28, 2011 - Posted by | MySql, Uncategorized |

No comments yet.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s

%d bloggers like this: