Documentation Home
MySQL 5.6 Reference Manual
Related Documentation Download this Manual
PDF (US Ltr) - 31.4Mb
PDF (A4) - 31.5Mb
PDF (RPM) - 29.8Mb
HTML Download (TGZ) - 7.5Mb
HTML Download (Zip) - 7.5Mb
HTML Download (RPM) - 6.5Mb
Man Pages (TGZ) - 177.2Kb
Man Pages (Zip) - 287.5Kb
Info (Gzip) - 3.0Mb
Info (Zip) - 3.0Mb
Excerpts from this Manual

2.3.8 Upgrading MySQL on Windows

There are two approaches for upgrading MySQL on Windows:

  • Using MySQL Installer

  • Using the Windows ZIP archive distribution

The approach you select depends on how the existing installation was performed. Before proceeding, review Section 2.11.1, “Upgrading MySQL” for additional information on upgrading MySQL that is not specific to Windows.

Upgrades between milestone releases (or from a milestone release to a GA release) are not supported. Significant development changes take place in milestone releases and you may encounter compatibility issues or problems starting the server. For instructions on how to perform a logical upgrade with a milestone release, see Logical Upgrade.

Upgrading MySQL with MySQL Installer

Performing an upgrade with MySQL Installer is the best approach when the current server installation was performed with it and the upgrade is within the current release series. MySQL Installer does not support upgrades between release series, such as from 5.5 to 5.6, and it does not provide an upgrade indicator to prompt you to upgrade. For instruction on upgrading between release series, see Upgrading MySQL Using the Windows ZIP Distribution.

To perform an upgrade using MySQL Installer:

  1. Start MySQL Installer.

  2. From the dashboard, click Catalog to download the latest changes to the catalog. The installed server can be upgraded only if the dashboard displays an arrow next to the version number of the server.

  3. Click Upgrade. All products that have newer versions will appear in a list.

    Note

    For server milestone releases in the same release series, MySQL Installer deselects the server upgrade and displays a warning to indicate that the upgrade is not supported, identifies the risks of continuing, and provides a summary of the steps to perform a logical upgrade manually. You can reselect server upgrade and proceed at your own risk.

  4. Deselect all but the MySQL server product, unless you intend to upgrade other products at this time, and click Next.

  5. Click Execute to start the download. When the download finishes, click Next to apply the updates.

  6. Configure the server.

Upgrading MySQL Using the Windows ZIP Distribution

To perform an upgrade using the Windows ZIP archive distribution:

  1. Always back up your current MySQL installation before performing an upgrade. See Section 7.2, “Database Backup Methods”.

  2. Download the latest Windows ZIP Archive distribution of MySQL from https://dev.mysql.com/downloads/.

  3. Before upgrading MySQL, stop the server. If the server is installed as a service, stop the service with the following command from the command prompt:

    C:\> NET STOP MySQL

    If you are not running the MySQL server as a service, use mysqladmin to stop it. For example, before upgrading from MySQL 5.5 to 5.6, use mysqladmin from MySQL 5.5 as follows:

    C:\> "C:\Program Files\MySQL\MySQL Server 5.5\bin\mysqladmin" -u root shutdown
    Note

    If the MySQL root user account has a password, invoke mysqladmin with the -p option and enter the password when prompted.

  4. Extract the ZIP archive. You may either overwrite your existing MySQL installation (usually located at C:\mysql), or install it into a different directory, such as C:\mysql5. Overwriting the existing installation is recommended. However, for upgrades (as opposed to installing for the first time), you must remove the data directory from your existing MySQL installation to avoid replacing your current data files. To do so, follow these steps:

    1. Unzip the ZIP archive in some location other than your current MySQL installation.

    2. Remove the data directory.

    3. Move the data directory from the current MySQL installation to the location of the just-removed data directory

    4. Remove the current MySQL installation

    5. Move the unzipped installation to the location of the just-removed installation

  5. If you were running MySQL as a Windows service and you had to remove the service earlier in this procedure, reinstall the service. (See Section 2.3.5.7, “Starting MySQL as a Windows Service”.)

  6. Restart the server. For example, use NET START MySQL if you run MySQL as a service, or invoke mysqld directly otherwise.

  7. As Administrator, run mysql_upgrade to check your tables, attempt to repair them if necessary, and update your grant tables if they have changed so that you can take advantage of any new capabilities. See Section 4.4.7, “mysql_upgrade — Check and Upgrade MySQL Tables”.

  8. If you encounter errors, see Section 2.3.6, “Troubleshooting a Microsoft Windows MySQL Server Installation”.


User Comments
User comments in this section are, as the name implies, provided by MySQL users. The MySQL documentation team is not responsible for, nor do they endorse, any of the information provided here.
  Posted by Jacob Pérez on January 12, 2012
For time reason I'll make my comment on spanish languaje, later I'll translate at english languaje.

I hope can help at someone this contribution:

Actualización de MySQL Server en Windows
1. Descargar la nueva versión de MySQL en archivo .zip
2. Detener el servicios de MySQL
a. Inicio – Panel de control – Sistema y seguridad – Herramientas administrativas – Servicios
b. Seleccionar el nombre del servicio de MySQL y detenerlo
3. Eliminar el servicio de MySQL
a. Inicio – Ejecutar
b. Escribir regedit y dar aceptar
c. Eliminar el siguiente registro HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Service
d. Reiniciar el equipo
4. Actualizar MySQL Server
a. Inicio – Equipo
b. Ubicarse en la ruta donde se instaló MySQL Server
C:\Program Files\MySQL\MySQL Server x.x
c. Abrir el archivo .zip y descomprimir el contenido en la carpeta donde está instalado MySQL Server
d. Reemplazar todos los archivos
5. Configurar el servicio e instancia de MySQL Server
a. Inicio – Todos los programas – MySQL – MySQL Server x.x - MySQL Instance Configuration Wizard
b. Siguiente – Siguiente – Siguiente – Siguiente – Siguiente
c. En algunos casos reconoce dónde ha sido instalado MySQL Server, por lo que bastará con dar Siguiente, en caso contrario dar Modificar – Sí – Siguiente
d. Siguiente – Indicar el puerto con el que se va a trabajar y agregar la excepción del puerto en Firewall – Siguiente
e. Indicar Selección manual de caracteres por defecto e indicar utf8 – Siguiente
f. Siguiente
g. Desmarcar Modicar las configuraciones de seguridad – Siguiente – Ejecutar

  Posted by Jacob Pérez on January 13, 2012
I'll post my suggest on English Language, for upgrading MySQL Server on Windows OS.

Upgrading MySQL Server on Windows
1. Donwload the new version of MySQL on zip format
2. Stopping MySQL Service
a. Start – All programs - Control Panel – System and security – Administrative tools - Services
b. Select the MySQL Services name and stopped
3. Delete MySQL service
a. Start – Run
b. Type regedit and Ok
c. Delete the next item HKEY_LOCAL_MACHINE/SYSTEM/CurrentControlSet/Service
d. Restart the computer
4. Updating MySQL Server
a. Start - Computer
b. Look for the path was installed MySQL Server C:\Program Files\MySQL\MySQL Server x.x
c. Open the .zip file and uncompress the files on the folder was installed MySQL Server
d. Replace all the files
5. MySQL Instance Configuration
a. Start – All programs - MySQL – MySQL Server x.x - MySQL Instance Configuration Wizard
b. Next – Next – Next – Next – Next
c. Some times recognize the path where was installed MySQL Server, on this case clic on Next, if don’t recognize the path clic on Modify – Yes – Next
d. Next – Indicated the port for the MySQL Service and check Add firewall exception for this port – Next
e. Check Manual Selected Default Character Set / Collation and indicated utf8 on Character Set – Next
f. Next
g. Uncheck Modify Security Settings – Next – Execute

I hope can help at someone.
  Posted by Attila R on April 8, 2013
I did unzipped 5.6.10 onto an older version 5.6.x on Windows.

my.ini did't overwrote and contained these lines:

[client]
password = something

From this point I lost _ALL_ access to MySQL:

ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)

I mean mysql.exe or mysql_upgrade.exe also didn't worked.

I figured out the problem was the password line in my.ini. I did commented out temporarily, ran mysql_upgrade.exe then I did uncommented then everything worked well.
  Posted by 庭豐 石 on November 7, 2013
Point 5 in this article implies that when upgrading from 5.1 to 5.5, we need to uninstall MySQL Server 5.1 first. That is, we cannot run installer for 5.5 and expect it to *upgrade* installed version 5.1 to 5.5.

To those who want to remove my comment, read the following first:
Please refer to
http://docs.oracle.com/cd/E17952_01/refman-5.1-en/windows-install-wizard.html#mysql-install-wizard-upgrading
In section 2.3.3.1.6 of that article, please pay attention to the 2nd paragraph that I include here below:
Automatic upgrades are available only when upgrading between installations that have the *same major and minor version numbers*. For example, you can upgrade automatically from MySQL 5.1.5 to MySQL 5.1.6, but not from MySQL 5.0 to MySQL 5.1.

As a matter of fact, I have MySQL 5.1.30 in a test computer. I run MySQL 5.5 setup WITHOUT previously uninstalling 5.1. Result: both versions are displayed in "Add/Remove Program" applet (and the new server is not using old data, but this is another topic)
Sign Up Login You must be logged in to post a comment.