how to run mysql_upgrade on windows

by Reece   Last Updated August 14, 2019 17:00 PM

I have just upgraded (uninstall, restart, download new installer and installed) MySQL Server for Windows on my 2008 R2 box.

In the upgrade procedure webpage it says:

To use mysql_upgrade, make sure that the server is running, and then invoke it like this:

shell> mysql_upgrade [options]

But I can't figure that bit out... I'm probably having a mental blank but if I run mysql_upgrade; through the mysql command line client, I get an error 1064: you have an error in your sql syntax etc...

What am I doing wrong?

Answers 1

The mysql_upgrade command is system command, rather than a MySQL command.

Execute "mysql_upgrade" from the Command Prompt (cmd.exe). If it is not in your path, you can most likely find it at the following location: C:\Program Files\MySQL\MySQL Server 5.6\bin

Or otherwise in the "bin" subdirectory of your MySQL server installation path.

You will likely want to pass it the root username and request it to prompt for your password as follows:

mysql_upgrade -u root -p

Trent Lloyd
Trent Lloyd
September 13, 2013 03:31 AM

Related Questions

Mysql Servers with crossover cable in windows

Updated April 14, 2015 20:00 PM