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