mysql prompt一个特别好用的命令

想必大家在命令行操作mysql的时候会十分发愁现在的操作的是那个数据库吧，至少我就纠结过，可能您会说我打一条命令不就知道了，是的这样做确实可以的。

可是今儿给大家介绍个好用的命令–prompt

[root@fsailing1 ~]# mysql -uroot -p --prompt="\u@\h:\d \r:\m:\s>"  Enter password:  Welcome to the MySQL monitor.  Commands end with ; or g.  Your MySQL connection id is 378  Server version: 5.0.95 Source distribution    Copyright (c) 2000, 2011, 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:(none) 08:23:32>use test;  Reading table information for completion of table and column names  You can turn off this feature to get a quicker startup with -A  Database changed  root@localhost:test 08:23:44>exit;  

这样做的好处就是让我们大家在操作数据库时更加方便快捷。

您也可以在在my.cnf配置文件里进行配置：

[mysql]  prompt=mysql(\u@\h:\d)>    default-character-set=utf8  

[root@fsailing1 ~]# vim /etc/my.cnf  [root@fsailing1 ~]# service mysqld restart  停止 MySQL：                                               [确定]  启动 MySQL：                                               [确定]  [root@fsailing1 ~]# mysql -uroot -p  Enter password:  Welcome to the MySQL monitor.  Commands end with ; or g.  Your MySQL connection id is 2  Server version: 5.0.95 Source distribution    Copyright (c) 2000, 2011, 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(root@localhost:(none))>use test;  Reading table information for completion of table and column names  You can turn off this feature to get a quicker startup with -A  Database changed  mysql(root@localhost:test)>  

这里也给出需要的一些个选项供大家参考。

原文出处：teakki -> https://www.teakki.com/p/57e22dffa16367940da63f58