how to run mysql_upgrade on windows
Solution 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