Description:
The following code is placed inside my .bashrc file. With MySQL version 5.5 my prompt was then colored blue and had various parts bold / inverse.
GTSENV='081'
setblue='\033[38;5;26m'
setbold='\033[1m'
setinvs='\e[1;7m'
unset='\033[00m'
MYSQL_PS1="${setblue}\D \u@${setbold}\h:E${GTSENV}${unset}${setblue}${setinvs}(\d)${unset}\nmysql> "
export MYSQL_PS1=`echo -e "$MYSQL_PS1"`
After upgrading the MySQL Server from 5.5 to 5.6 this code now produces the following prompt:
$ mysql --defaults-group-suffix=_simulation -h prmdbsclu -P 18100
Welcome to the MySQL monitor. Commands end with ; or \g.
Your MySQL connection id is 632603
Server version: 5.6.21-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial)
Copyright (c) 2000, 2014, 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.
38;5;26mWed Dec 23 10:07:35 2015 albrshe[1mprmdbsclu:E08[00[38;5;26[1;7m((none)[00mysql>
How to repeat:
Install MySQL 5.6.21-enterprise-commercial-advanced
Place the above code into the .bashrc file, source it, and attempt to enter mysql.
Suggested fix:
Find out why it worked with older versions (5.5) and attempt to make it work again. :)
Description: The following code is placed inside my .bashrc file. With MySQL version 5.5 my prompt was then colored blue and had various parts bold / inverse. GTSENV='081' setblue='\033[38;5;26m' setbold='\033[1m' setinvs='\e[1;7m' unset='\033[00m' MYSQL_PS1="${setblue}\D \u@${setbold}\h:E${GTSENV}${unset}${setblue}${setinvs}(\d)${unset}\nmysql> " export MYSQL_PS1=`echo -e "$MYSQL_PS1"` After upgrading the MySQL Server from 5.5 to 5.6 this code now produces the following prompt: $ mysql --defaults-group-suffix=_simulation -h prmdbsclu -P 18100 Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 632603 Server version: 5.6.21-enterprise-commercial-advanced MySQL Enterprise Server - Advanced Edition (Commercial) Copyright (c) 2000, 2014, 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. 38;5;26mWed Dec 23 10:07:35 2015 albrshe[1mprmdbsclu:E08[00[38;5;26[1;7m((none)[00mysql> How to repeat: Install MySQL 5.6.21-enterprise-commercial-advanced Place the above code into the .bashrc file, source it, and attempt to enter mysql. Suggested fix: Find out why it worked with older versions (5.5) and attempt to make it work again. :)