หน้าเว็บ

Tuesday, November 13, 2012

Connecting to and Disconnecting from the Server

To be able to connect and disconnect a MySQL server to query any data like this:
shell> mysql -h host -u user -p
Enter password: ********
.
.
.
mysql>
mysql>
mysql> quit
Bye
mysqlthe program that is invoked
-h hosthost represent the host name where your MySQL server is running (if host is localhost, you can omit this option)
-u useruser represent the user name of your MySQL account
-pto enter password of user at the "Enter password:" prompt.
quit or \qexit MySQL program (On Unix, you can also disconnect by pressing Control+D.)


Example:
C:\>
C:\>mysql -h localhost -u root -p
Enter password: ********
Welcome to the MySQL monitor.  Commands end with ; or \g.
Your MySQL connection id is 1
Server version: 5.5.27 MySQL Community Server (GPL)

Copyright (c) 2000, 2011, Oracle and/or its affiliates. All rights reserved.

Oracle is a registered trademark of Oracle Corporation and/or its
affiliates. Other names may be trademarks of their respective
owners.

Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.

mysql>
mysql>
mysql> quit
Bye

C:\>

Refer to:MySQL Document as "refman5-5"

MySQL: Tutorial

  1. Connecting to and Disconnecting from the Server

MySQL

  1. Tutorial

I'm Yours

Jason Mraz



INRTO: /A/E/F#m/D D9/
   A
Well, you done done me and you bet I felt it
   E
I tried to be chill but your so hot that I melted
  F#m
I fell right through the cracks,
D
Now I'm tryin to get back...
        A
 Before the cool done run out, I'll be givin it my best test
  E
 And nothin's gonna stop me but divine intervention
    F#m
 I reckon it's again my turn,
    D     D9
 To win some or learn some
  A             E
But I won't hesitate no more,
   F#m             D D9       A     E/F#m/D D9/
no more, It cannot wait, I'm yours
     A
 Well open up your mind and see like me
     E
 Open up your plans and damn you're free
     F#m
 Look into your heart
                 D
 And you'll find love love love love
A
Listen to the music of the moment people dance and sing
E
We're just one big family
F#m
And it's our godforsaken right 
      D           D9           E
to be loved loved loved loved loved
  A              E
 So, i won't hesitate no more,
    F#m              D
 no more, It cannot wait, I'm sure
            A             E             
 there's no need to complicate
             F#m                 D         A    E/F#m/D D9/
 Our time is short, This is our fate, I'm yours

SOLO: /A/E/F#m/D D9/
      A
I've been spendin' way too long checkin' my tongue in the mirror
     E
And bendin' over backwards just to try to see it clearer
     F#m
But my breath fogged up the glass
    D
And so I drew a new face and I laughed
    A
 I guess what I'd be sayin' is there ain't no better reason
     E
 to rid yourself of vanities and just go with the seasons
 F#m
 It's what we aim to do
      D 
 Our name is our virtue
   A            E
But I won't hesitate no more,
    F#m             D
no more, It cannot wait, I'm yours
      A
 Well open up your mind and see like me
      E
 Open up your plans and damn you're free
      F#m                                  D
 Look into your heart and you will find that the sky is yours
     A
So please don't, please don't, please don't,
            E
There's no need keep to complicate,
           F#m
Cause our time is short
                         D
This, this, this is our fate,
      A   E/F#m/D D9/
I'm yours