I would like to change the prompt to my mariadb or mysql client.
I would like the prompt to be the contain of a variable like
report_host or more, to something that can change like
Does someone know how to do it?
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It only takes a minute to sign up.Sign up to join this community
AFAIK MySQL prompt cannot be set to MySQL variables (Global or Session). The only options that can be used are documented at https://dev.mysql.com/doc/refman/5.7/en/mysql-commands.html (look towards the end of the documentation page for a full list).
Set it manually:
mysql> prompt Foo> PROMPT set to 'Foo> ' Foo>
root@ironforge:~# export MYSQL_PS1="Foo> " root@ironforge:~# mysql -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 195 Server version: 5.5.54-0ubuntu0.14.04.1 (Ubuntu) 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. Foo>
You can also use variables to add things like the database name (
\d), hostname (
\h) etc to the prompt. A full list is available in the documentation.