Versions Compared

Key

  • This line was added.
  • This line was removed.
  • Formatting was changed.

...

Child pages (Children Display)

Install MySQL

Search for mysql community server, and download and run the installer. Choose a custom setup, and select the 64-bit MySQL server, the workbench, and the Connector/J.

2014-10-02: Australia: The installer crashes when the date format is not US (for details see down page). To run the installer, go to Control Panel, Region, and under formateselect on one computer, so I downloaded the installation files directly.

Upgrading from previous version

Sometimes prior versions can cause problems. It is best to export the database, uninstall the MySQL server and other components, and restart so the services are removed. Make a note of any MySQL users (other than root), as you may want to re-create these to ensure consistency.

If you have trouble upgrading (there is one step where an old password is requested, which can be difficult to figure out), you should Make sure you delete the MySQL data, which  which is the MySQL folder under C:\ProgramData\ in Windows 7. The fodler folder is hidden, so you need to type it into the address line of Explorer.

If you upgraded without uninstalling, and had problems

You may You also need to delete servicesthe old MySQL or MySQL56 service, if it is running or present.

Command Prompt, Run As Administrator, sc delete "service name".

...

Command Prompt, Run As Administrator, sc ??? "service name" to get PID; then taskkill /F /PID <the PID>

Crashing win Australia

When you select the product ("MySQL Server 5..21 below), the installer crashes with something about a strong and datetime error.

Image Removed

Go to Region as below (Control Panel); change the Location to United States, then the Format to English (United States). Click Apply to keep the Window open, so you can easily change it back when done.

Image Removed

Image RemovedIf you have trouble upgrading (there is one step where an old password is requested, which can be difficult to figure out), you should delete the MySQL data,