mysql 参数

来源：互联网发布：windows error code 编辑：程序博客网时间：2024/06/08 20:15

C:\Windows\system32>mysql -Vmysql  Ver 14.14 Distrib 5.7.14, for Win64 (x86_64)C:\Windows\system32>mysql -u root -pEnter password: ******C:\Windows\system32>mysql -uroot -p123456C:\Windows\system32>mysql -uroot -p -P3306 -h127.0.0.1Enter password: ******Welcome to the MySQL monitor.  Commands end with ; or \g.Your MySQL connection id is 7Server 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 itsaffiliates. Other names may be trademarks of their respectiveowners.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 \hmysql: [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 10Server 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 itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.localhost

2.连接上客户端后，通过prompt 指定

C:\Windows\system32>mysql -uroot -p123456mysql: [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 11Server 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 itsaffiliates. Other names may be trademarks of their respectiveowners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> prompt \hPROMPT set to '\h'localhost

MySQL 提示符

参数描述 \D 完整的日期 \d 当前数据库 \h 服务器名称 \u 当前用户

0 0