[SOLVED] CentOS upgrade mysql 5.1 to 5.6 unable to run mysql_upgrade - bash: bT: command not found

Issue

I have just installed mysql 5.6 and imported some tables from 5.1. Now I am trying to run mysql_upgrade in the shell to upgrade all the tables.

sudo mysql_upgrade -u <myuser> -p <mypassword>
[3] 12487
-bash: bT: command not found

I receive the error above about bT command not found.

Tried googling but there does not seem to be anything on this error.

Any help?

The box is CentOS 7.

Thanks,

Solution

It seems that your password contains special chars like $& or something related. Make sure you specify the command in the following way:

sudo mysql_upgrade -u <myuser> -p'<mypassword>'

The password should be in quotes with no space, so the chars will be escaped. If your pass contains single quotes, escape them as well.

Answered By - Miglen.com

Answer Checked By - David Marino (WPSolving Volunteer)