Using mysql_upgrade command line

Using mysql_upgrade command line

When you upgrade mysql , the things that you will encounter are some errors said that you need to fix somethings . The mysql_upgrade command line (only unix)  is a command that checks all tables in all databases for incompatibilities with your current version of the MySQL Server.

Another feature of mysql_upgrade is that it saves the MySQL version number into a file named mysql_upgrade.info. Contained within the data directory, this file is used to quickly review if all tables are current for this release, allowing future table-checking to be skipped.

Using

# mysql_upgrade -u yourusername -ppassword