I was browsing log files the other day and noticed that the mysql server was throwing a bunch of errors in its log.

After doing a little checking it appears that whoever upgraded the mysql server to version 5.6 didn’t run the mysql_upgrade command on this windows server to upgrade the database tables.

Solution

Turns out the fix for this was fairly simple.

Open an administrative command prompt and change directory to your mysql bin folder. Yours should look something like C:\Program Files\MySQL\MySQL Server 5.6\bin if you are running mysql 5.6 and didn’t change the default path.

Type mysql_upgrade -u root -p and supply your root password when prompted. You should see a bunch of output on the screen and viola you’re done. Now when you start mysql you shouldn’t see any of those error messages in the log.