mysql 登录日志_MySQL登录与退出

17270ce95af85a4a2d33846cd5831d99.png

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>

有用的提示符

c67a32ddb735d1d0a8d2d0cf854e78eb.png

退出命令

exit

quit

\q

  • 0
    点赞
  • 0
    收藏
    觉得还不错? 一键收藏
  • 0
    评论

“相关推荐”对你有帮助么?

  • 非常没帮助
  • 没帮助
  • 一般
  • 有帮助
  • 非常有帮助
提交
评论
添加红包

请填写红包祝福语或标题

红包个数最小为10个

红包金额最低5元

当前余额3.43前往充值 >
需支付:10.00
成就一亿技术人!
领取后你会自动成为博主和红包主的粉丝 规则
hope_wisdom
发出的红包
实付
使用余额支付
点击重新获取
扫码支付
钱包余额 0

抵扣说明:

1.余额是钱包充值的虚拟货币,按照1:1的比例进行支付金额的抵扣。
2.余额无法直接购买下载,可以购买VIP、付费专栏及课程。

余额充值