mysql  --u<user-id>  -p[password]    [option]   <database_name>

--help, -?

Display a help message and exit.  

--host=host_name,

 -h host_name

Connect to the MySQL server on the given host.

--user=user_name,

-u user_name

The MySQL user name to use when connecting to the server.

--password[=password], -p[password]

The password to use when connecting to the server. If you use the short

option form (-p), you cannot have a space between the option and the password. If you omit the password value following the --password or –p option on the Shell, mysql prompts for one.

Specifying a password on the Shell should be considered insecure. See Section 6.1.2.1, "End-User Guidelines for Password Security". You can

use an option file to avoid giving the password on the Shell.

mysql  -u <user-id>   -p<password>  <database_name>

pi@raspberrypi ~ $ mysql -u root –p

Enter password:

Welcome to the MySQL monitor.  Commands end with ; or \g.

Your MySQL connection id is 62

Server version: 5.5.43-0+deb7u1 (Debian)

Copyright (c) 2000, 2015, 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>

명령

축약

description

?        

＼?

Synonym for `help'.

help     

＼h

Display this help.

clear    

＼c

Clear command.

connect  

＼r

Reconnect to the server. Optional arguments are db and host.

edit     

＼e

Edit command with $EDITOR.

exit     

＼q

Exit mysql. Same as quit.

quit     

＼q

Quit mysql.

use      

＼u

Use another database. Takes database name as argument.

source  

＼.

Execute an SQL script file. Takes a file name as an argument

status   

＼s

Get status information from the server.

system   

＼!

Execute a system shell command.

warnings 

＼W

Show warnings after every statement.

nowarning

＼w

Don't show warnings after every statement.

delimiter

＼d

Set statement delimiter.

delimiter

＼d

Set statement delimiter.

ego

＼G

Send command to mysql server, display result vertically.

go

＼g

Send command to mysql server.

pager

＼P

Set PAGER [to_pager]. Print the query results via PAGER.

nopager

＼n

Disable pager, print to stdout.     

tee

＼T

Set outfile [to_outfile]. Append everything into given outfile.

notee

＼t

Don't write into outfile.

print

＼p

Print current command.

prompt

＼R

Change your mysql prompt.

rehash

＼#

Rebuild completion hash.

charset

＼C

Switch to another charset. Might be needed for processing binlog with multi-byte charsets

mysql> help use ;

mysql> help use

Name: 'USE'

Description:

Syntax:

USE db_name

The USE db_name statement tells MySQL to use the db_name database as

the default (current) database for subsequent statements. The database

remains the default until the end of the session or another USE

statement is issued:

USE db1;

SELECT COUNT(*) FROM mytable;   # selects from db1.mytable

USE db2;

SELECT COUNT(*) FROM mytable;   # selects from db2.mytable

URL: http://dev.mysql.com/doc/refman/5.5/en/use.html

mysql>

mysql> exit;

Bye

pi@raspberrypi ~ $

mysql> status;

--------------

mysql  Ver 14.14 Distrib 5.5.43, for debian-linux-gnu (armv7l) using readline 6.2

Connection id:          65

Current database:

Current user:           root@localhost

SSL:                    Not in use

Current pager:          stdout

Using outfile:          ''

Using delimiter:        ;

Server version:         5.5.43-0+deb7u1 (Debian)

Protocol version:       10

Connection:             Localhost via UNIX socket

Server characterset:    latin1

Db     characterset:    latin1

Client characterset:    utf8

Conn.  characterset:    utf8

UNIX socket:            /var/run/mysqld/mysqld.sock

Uptime:                 4 hours 32 min 9 sec

Threads: 1  Questions: 773  Slow queries: 0  Opens: 213  Flush tables: 2  Open tables: 24  Queries per second avg: 0.047

--------------

mysql> use mysql;

Reading table information for completion of table and column names

You can turn off this feature to get a quicker startup with -A

Database changed

mysql> status;

--------------

mysql  Ver 14.14 Distrib 5.5.43, for debian-linux-gnu (armv7l) using readline 6.2

Connection id:          67

Current database:       mysql

Current user:           root@localhost

SSL:                    Not in use

Current pager:          stdout

Using outfile:          ''

Using delimiter:        ;

Server version:         5.5.43-0+deb7u1 (Debian)

Protocol version:       10

Connection:             Localhost via UNIX socket

Server characterset:    latin1

Db     characterset:    latin1

Client characterset:    utf8

Conn.  characterset:    utf8

UNIX socket:            /var/run/mysqld/mysqld.sock

Uptime:                 4 hours 39 min 59 sec

Threads: 1  Questions: 836  Slow queries: 0  Opens: 213  Flush tables: 2  Open tables: 24  Queries per second avg: 0.049

--------------

mysql> use edit;

mysql> edit

    -> ＼g