mysql shell display database name

November 11th, 2008

This is a neat little command you can add to the my.cnf to display the hostname along with the database that you’re currently using in MySQL:

[mysql]
prompt=’mysql [\h] {\u} (\d) > ‘

After adding the two lines above, bounce the MySQL server, then run the MySQL shell to see the results.

Leave a Reply

Back to top