mysql: symbol lookup error: /usr/local/lib/libreadline.so.6: undefined symbol: UP

Error Symptom:

when you run $mysql -u root -p command in the linux you get an error message ” mysql: symbol lookup error: /usr/local/lib/libreadline.so.6: undefined symbol: UP”

Solution:

Step 1: Login as root

Step 2: Go to folder path #cd/usr/local/lib

there was a bunch of readline libs in there (libreadline.so.BLAH-BLAH) so i:

Step3: Create a directory #mkdir temp

Step 4: Move the files # mv /usr/local/lib/libreadline* temp

Step 5:  #ldconfig

Step 6: #apt-get update