tag:blogger.com,1999:blog-6480555434853676325.post452870223395506262..comments2023-07-13T04:04:51.867-06:00Comments on MySQL DBA - An Oracle DBA's Journey: Create aliases to make MySQL administration easierAnonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.comBlogger2125tag:blogger.com,1999:blog-6480555434853676325.post-89291066841036994572007-12-19T08:12:00.000-07:002007-12-19T08:12:00.000-07:00Thanks for the addition. Customizing your prompt...Thanks for the addition. Customizing your prompt to identify your environment in MySQL is important.Anonymoushttps://www.blogger.com/profile/00291214843973166978noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-54116283699267183602007-12-19T06:21:00.000-07:002007-12-19T06:21:00.000-07:00Another thing I find useful is to change the promp...Another thing I find useful is to change the prompt of the mysql client. I think it's in the manual somewhere, but in ~/.my.cnf (or any other my.cnf type file) you can add a line like this to the [mysql] section:<BR/><BR/>prompt=mysql\\_\\u@\\h/\\d>\\_<BR/><BR/>This one shows user, host, and database in the prompt, like so:<BR/><BR/>mysql dba@melody/mail>Anonymousnoreply@blogger.com