MySQL登录与退出

mysql连接登录参数

• -?, –help

Display this help and exit.

• -I, –help

Synonym for -?

以上为mysql参数帮助命令

以下为常用的参数命令

• –auto-rehash

Enable automatic rehashing. One doesn't need to use
'rehash' to get table and field completion, but startup
and reconnecting may take a longer time. Disable with
--disable-auto-rehash.
(Defaults to on; use --skip-auto-rehash to disable.)

• -A, –no-auto-rehash

No automatic rehashing. One has to use 'rehash' to get
table and field completion. This gives a quicker start of
mysql and disables rehashing on reconnect.    

• -D, –database=name Database to use.
• –delimiter=name Delimiter to be used.
• -h, –host=name Connect to host.
• -p, –password[=name]

Password to use when connecting to server. If password is
not given it's asked from the tty.

• -P, –port=#

Port number to use for connection or 0 for default to, in
order of preference, my.cnf, $MYSQL_TCP_PORT,
/etc/services, built-in default (3306).

• –prompt=name

Set the mysql prompt to this value.

• -u, –user=name

User for login if not current user.

• -V, –version

Output version information and exit.

不带口令的登录

C:\Users\oneTOinf                                                            
λ  mysql -u root -p --auto-rehash                                            
Enter password: ****                                                          
Welcome to the MySQL monitor.  Commands end with ; or \g.                    
Your MySQL connection id is 2                                                
Server version: 5.5.53 MySQL Community Server (GPL)                          

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

登录时修改提示符

C:\Users\oneTOinf                                                            
λ  mysql -u root -p --prompt \u@\h>                                          
Enter password: ****                                                          
Welcome to the MySQL monitor.  Commands end with ; or \g.                    
Your MySQL connection id is 3                                                
Server version: 5.5.53 MySQL Community Server (GPL)                          

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

root@localhost>                                                              

登录后修改提示符

mysql> prompt \u@\h>
PROMPT set to '\u@\h>'
root@localhost>

有用的提示符

退出命令

• exit
• quit
• \q