C:\Windows\system32>mysql -V
mysql Ver 14.14 Distrib 5.7.14, for Win64 (x86_64)
C:\Windows\system32>mysql -u root -p
Enter password: ******
C:\Windows\system32>mysql -uroot -p123456
C:\Windows\system32>mysql -uroot -p -P3306 -h127.0.0.1
Enter password: ******
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 7
Server version: 5.7.14 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.
mysql>
参数 | 描述 |
---|---|
-D, –database=name | 打开指定数据库 |
–delimiter = name | 指定分隔符 |
-h, –host =name | 服务器名称 |
-p, –password | 密码 |
-P(大写), –port=# | 端口号 |
–prompt=name | 设置提示符 |
-u, –user=name | 用户名 |
-V(大写), –version | 输出版本信息并且推出 |
MySQL 退出
mysql> eixt ;
mysql > quit;
mysql > \q;
## 写改MySQL提示符 ##
1. 连接客户端时通过参数指定
C:\Windows\system32>mysql -uroot -p123456 --prompt \h
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 10
Server version: 5.7.14 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.
localhost
2.连接上客户端后,通过prompt 指定
C:\Windows\system32>mysql -uroot -p123456
mysql: [Warning] Using a password on the command line interface can be insecure.
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 11
Server version: 5.7.14 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.
mysql> prompt \h
PROMPT set to '\h'
localhost
MySQL 提示符
参数 | 描述 |
---|---|
\D | 完整的日期 |
\d | 当前数据库 |
\h | 服务器名称 |
\u | 当前用户 |