Mysql_upgrade on windows

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.

 

 

About The Author

I have worked in the computer repair field since the early '90s. I was a technician and then Coordinator of Computer Repair for Regional Education Service Agency II (RESA 2) for 18 years. I am currently working for Wayne County Schools as a Network Engineer/Technology Specialist. I am responsible for the schools' Internet access, Wi-Fi, networks, servers, laptops, desktops, and operating systems and software.

Related posts

Leave a Reply

Your email address will not be published. Required fields are marked *

sixty five − = sixty three