Mysql connect details for Linux using Putty

05 January,2011 by Jack Vamvas

Prerequisites

1)Putty client

2)Username\Password of a valid Linux user

3)Username,hostname,password of MySQL server

4)Database name – assume it’s called MYDB

 

Steps

Logon to Linux server using Putty with information from step 2) of Prerequisites

From the command line type:

 mysql -uUSERNANE -hHOST –pPASSWORD

 

replacing USERNAME,HOST and PASSWORD with valid details from step 3) of Prerequisites

 

If successful you’ll see  a message such as : Welcome to the MySQL Monitor and the mysql prompt:

 

mysql>

 

 

To use a database do, which will change the context :

 

mysql>use MYDB;

 

To list  all tables:

 

mysql>show tables;

 

+-------------------+

| Tables_in_MYDB  |

+-------------------+

| archive           |

| category          |

| categorylinks     |

| change_tag        |

| external_user     |

| externallinks     |

| filearchive       |

| hitcounter        |

+-------------------+

 

 

To select some records from a table :

 mysql>SELECT * FROM archive;

 This is a basic introduction – check out the mysql reference for more DML options

Author: Jack Vamvas(http://www.dba-db2.com)

Share:

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been saved. Comments are moderated and will not appear until approved by the author. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment on Mysql connect details for Linux using Putty

Comments are moderated, and will not appear until the author has approved them.


dba-db2.com | DB2 Performance Tuning | DBA DB2:Everything | FAQ | Contact | Copyright