use mysql 退出_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:UsersoneTOinf λ 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:UsersoneTOinf λ 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

原文出处：csdn -> http://blog.csdn.net/pianoorrock/article/details/78514968