I resolved to find a more generic way. I tried all sorts of google searches, all of which came up unhelpful. With no choice left, I headed to the MySQL docs. After some clicking around, I came upon this page, http://dev.mysql.com/doc/refman/5.0/en/mysql-commands.html.
This is great news! Apparently, I have several options.
- /etc/my.cnf - Globally change the mysql client for all users of a given machine
- ~/.my.cnf - Change for just me on a given machine
- export $MYSQL_PS1 - Change just my prompt without requiring any new files
Since all of the machines I use are already controlled with puppet, it was a simple change for me to add a definition for $MYSQL_PS1 in my profile.