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?
mysql_upgrade command is system command, rather than a MySQL command.
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