MV Technical Website  Windows»MySql for Windows»Install 32 or 64 bit MySQL 5.5
  
Page Collections
Attributes
Hierarchy
  • RSS Feed

Last modified on 1/14/2019 1:30 PM by User.

Tags:

Install 32 or 64 bit MySQL 5.5

Table of Contents
  1. Install MySQL
  2. Edit my.ini to support multiple services of MySQL

It is important to download the .msi version of the setup.exe because it is the most automated method of installation (It has the wizard).

A copy of the download is on OneDrive  \SoftwareTools\mysql

   For 32 bit machines use the file named mysql-5.5.40-win32.msi
   For 64 bit machines use the files named mysql-5.5.40-winx64.msi, vcredist_x64_2013.exe, vcredist_x64_2010.exe and vcredist_x86_2010.exe
or you might be able to still download it from http://dev.mysql.com/downloads/mysql/5.5.html
 

NOTE: for Windows 2012 64-bit installation you MUST go to the control panel and verify that 3 different versions of the "Microsoft Visual C++ Redistributable" package are already installed before installing MySQL. 

  • x64 2013 (for MySQL Workbench)
  • x64 2010 (for MySQL 64-bit ODBC connectors 5.3.x)
  • x86 2010 (for MySQL 32-bit ODBC connectors 5.3.x and 3.5.x)

You won't be able to install the ODBC connector you need later if they aren't installed before you start.  You can get the installation files from OneDrive \SoftwareTools\mysql.  They are simple installations.  Just double click on the .exe and choose all default entries.

  • vcredist_x64_2013.exe (for MySQL Workbench)
  • vcredist_x64_2010.exe (for 64 bit ODBC connectors version 5.3.x)
  • vcredist_x86_2010.exe (for 32 bit ODBC connectors versions 5.3.x and 3.5.x)

Install MySQL

This page covers the questions asked by the above .msi versions.

You may need to start over and just re-install the same version of MySQL again for some reason. If so, uninstall the previous copy of MySQL first.  Clicking on the download file when an installation already exists will show an option for removing the installation.  You should delete the "C:\Program files\MYSQL\MySQL Server 5.5\" subfolders after uninstalling because it doesn't delete all the files. 

Your login should have administrative privileges.

  • Click on the .msi file to start the installation.
  • The welcome screen displays. Press Next.
  • Check the box for "I accept the terms in the License Agreement" and press Next.
  • Choose Setup Type: Custom click Next.
  • Custom Setup: leave all features checked for installation except for "Documentation"
  • Keep default installation location : "C:\Program files\MySQL" (or 64 bit version is "C:\Program files\MySQL\MySQL Server 5.5\")
  • click Next.
  •  
  • Ready to install MySQL Server 5.5. Click Install.
  • During the install it might display 2 screens about the Enterprise subscription features. Just press Next at each panel.
  • Complete the MySQL Server 5.5 Setup Wizard. Check the box for "Launch the MySql Instance Configuration Wizard". Click Finish.
  •  
  • Welcome screen for Instance configuration Wizard 1.0.17.0. Click Next.
  • Please select a configuration type: Click "Detailed Configuration". click Next.
  • Server type: Choose "Server Machine"
  • Database usage: Choose "Non-Transactional Database Only". Click Next.
  • Concurrent Users: Choose "Manual Setting" set connections: 20. Click Next.
  • Network options: check the box for "Enable TCP/IP Networking. Port number: 3306.
  • Check "Add firewall exception for this port".
  • Check box for "Enable Strict Mode".
  • Click Next.
  • default character set: choose "Standard Character Set". Click Next.
  • Windows options: Check the box for "Install as Windows Service".
  • Here you will name the service as mysql55_xxx where xxx is a 3 character lowercase abbreviation of the Profits Plus customer, example Excelda would be mysql55_exc. Or if this is a Maxene Reporter service the service name should be MySQL55_xxx_mr.
    • Service name: mysql55_xxx
    • check box for "Launch the MySQL Server automatically"
    • check box for "Include Bin Directory in Windows PATH"
    • click Next.
  • Security options:
  • On the security options window, check the box for "Modify Security Settings". give a root password of mysql1 and check the box for "Enable root access from remote machines". Un-check the box for "Create An Anonymous Account".
  • Ready to execute: Click Execute.
    • If you are re-installing MySQL it might timeout  at the "starting service" step and display this pop-up window message:

    • The security settings could not be applied to the database because the connection has failed with the following error: 

      Error Nr. 1045

      Access denied for user 'root'@'localhost' (using password: NO)

You can ignore the rest of the message in the window.  You don't have to do anything different here.  Just click "cancel" and continue as if it didn't happen.  When it comes time to start the mysql.exe client later you'll be told in these instructions that you shouldn't include the password in the command line arguments.

  • Wait for completion: Click Finish.
     

Edit my.ini to support multiple services of MySQL

WARNING! You have to pay close attention to the actual location of the "live" data template folder that was installed.  All new services must start with a copy of this template folder.  Different versions of Windows will put it in different folders and sometimes multiple folders.  Windows 2003, 2008, 2012 use the "C:\Program files\MySQL\MySQL SERVER 5.5\data" folder but Windows 7 installs two data folders; one in  "C:\Program files\ and another identical copy in C:\ProgramData  but only the C:\ProgramData one is the live data template folder. So always use the datadir= path in the [mysqld] section of the "C:\Program files\MySQL\MySQL SERVER 5.5\my.ini" file for the correct live data template folder.

 

Caution: The 2003 hosted server has two different versions of MySQL installed.  Profits Plus uses the version 5.5.  Do not use the MySQL files in  "C:\Documents and Settings\All users"  or C:\MySQL because they are for an older version than we use. 

Profits Plus uses the "C:\Program files\MySQL\MySQL SERVER 5.5" folder for the data folder and my.ini on the 2003 hosted server. 

  • The installation for 5.5 does not let you specify the path for the data folder.  You have to go back and change it manually after the fact before you make any changes to the database. 
  • The installation started the MySQL55_xxx service so go into Windows services and stop it now.
  • Convert the installed my.ini file to support multiple services. 
  • Follow these instructions for setting up a new service of MySQL for Profits Plus  or Maxene Reporter or ODAS.