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

Last modified on 8/14/2015 12:47 PM by User.

Tags:

Install 64 bit MySQL 5.5

NOTE:

You should not install this version of MySQL on any other servers.  It didn't contain all the required components and you'll have to download and install extra items.   You can avoid the hassle by always using  the web page for Install 32 or 64 bit MySQL 5.5 instead.   You get the same results with a lot less work.

Before the MYSQL 5.5 installation.

This is what I had to do on the Dongan Windows 2012 server 64 bit. which was mysql.5.5.34.0

Download Visual C++ 2010 Redistributable Package (x64) which comes in the filename vcredist_x64.exe.

Copy vcredist_x64.exe to the c:\u\mvs\au\mvs_tools\download folder so we'll always have it.

Install vcredist_x64.exe then copy c:\Windows\System32\MSVCR100.dll to C:\Windows\SysWOW64 folder.



64 bit MYSQL 5.5 installation.
A copy of the download is on Google Drive \My Drive\Applications and tools\mysql\mysql-installer-community-5.5.40.0.msi  or you might be able to still download it from http://download.softagency.net/MySQL/Downloads/MySQLInstaller/

Move it to c:\u\mvs\au\mvs_tools\download folder
double click on the "mysql-installer-community-5.5.40.0.msi" to start the installation.
warning: once you do the first installation, you will not see the "Welcome" screen again, after the first time, you'll see a different
"update" screen with different choices that the ones documented here.

"Welcome" screen. click "Install MySQL Products"
"Find latest products" screen. click the "Execute" button.
It will say "The operation is complete. Please click 'Next >' to continue. Click Next.
"Choosing a Setup Type" screen.
    - Click the Custom radio button
    - Change Data Path: to C:\u\mvs\mysql (use the correct MVS_ROOT)

"Feature Selection" screen.
"Product Catalog:" MySQL 5.5 Community Edition
   - Check MySQL Server 5.5.40
   - Check Applications. Let it install everything it allows.
   - Check MySQL Connectors. Let it install everything it allows.
   - Check Documentation. Let is install everything it allows.

"Check Requirements" screen.

- It might say some component cannot be installed because requirements are not met.
- If it says "Microsoft .NET Framework 4 Client Profile" is required for MySQL Notifier 1.1.4 and is checked then
go ahead with the install because it means the requirement is met.
- If the component isn't checked it means the component will not be installed, but that is probably ok too. We don't need all
components.

"Installation Progress" screen.
- It will show the list of components to be installed. Click execute.
- It displays progress for each component. Watch for errors or failures.

If you didn't install the "Visual C++ 2010 Redistributable Package (x64)" before this then MySQL Workbench CE 6.0.7 installation fails with
this message.

python.exe - System Error.
The program can't start because MSVCR100.dll is missing from your computer. Try reinstalling the program to fix this problem.

and you'll get "Connector/ODBC 5.2.6 install error" message
5: Error 1918.Error installing ODBC driver MySQL ODBC 5.2 ANSI Driver, ODBC error 13: The setup routines for the MySQL ODBC 5.2 ANSI Driver ODBC driver could not be loaded due to system error code 126: The specified module could not be found. (C:\Program Files\MySQL\Connector ODBC 5.2.6\myodbc5S.dll).. Verify that the file MySQL ODBC 5.2 ANSI Driver exists and that you can access it.

"Configuration Overview" screen.

- The following products will now be configured.
MySQL server 5.5.40
Click next.

"MySQL Server Configuration" screen

- Server Configuration Type: Config Type: choose "Server Machine":
- check "Enable TCP/IP Networking" Port 3306
- Check "Open Firewall port for network access"
- Advanced Configuration. Check "Show Advanced Options".  Click next.
- Root Account Password: mysql1
- Don't add the mvuser account here, we'll do that later in the instructions.

"Windows Service Details" screen.

- Windows Service name: MySQL55
- Check "Start the MySQL Server at System Startup
- Run Windows Service as ... check "Standard System Account"
- Click Next

"Logging Options" screen

- Error Log: DE-MV.err
- Uncheck "General Log"
- check "Slow Query log" name: DE-MV-slow.log
- Uncheck "Bin Log"
- Click Next. There will be a delay while configuration continues. Click "Show Details" to see progress.

"Configuration Overview" screen: Points to "Samples and Examples 5.5.34" Click next

- There will be a delay while configuration continues. Click "Show Details" to see progress.
- When it says "Configuration Complete", click Next.
- Click "copy installation log to clipboard". Paste the clipboard to notepad and save in "c:\u\mvs\au\mvs_tools\download\mysql_installation_log.txt"

Grant privileges and set passwords:
The GRANT commands below will create 4 users:
   mvuser is for command line client
   mvuser_pp is for Softworks RUN client and uses old_password format
   mvuser_mr is for Maxene Reporter client
   root is for admin

Put the 64 bit version of the mysql client into our win32\bin folder so it is always in the path.
     copy "C:\Program files\MySQL\MySQL SERVER 5.5\bin\mysql.exe" to c:\u\mvs\win32\bin

Logon to the MySql client as root in a dos prompt window by entering this command:

mysql.exe -uroot -Pxxxx (where -Pxxxx is the port # you assigned to this instance of MySQL, if it is 3306 you don't need to give a -P argument)

The client will prompt for a password. Use the password mysql1. It will give you a MySQL command line so you can copy/paste the following commands directly into the mysql client prompt:

GRANT ALL PRIVILEGES ON *.* TO 'mvuser'@'localhost' IDENTIFIED BY 'mvuser1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'mvuser'@'%' IDENTIFIED BY 'mvuser1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'mvuser_pp'@'localhost' IDENTIFIED BY 'mvuser_pp1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'mvuser_pp'@'%' IDENTIFIED BY 'mvuser_pp1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'mvuser_mr'@'localhost' IDENTIFIED BY 'mvuser_mr1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'mvuser_mr'@'%' IDENTIFIED BY 'mvuser_mr1' WITH GRANT OPTION;
GRANT ALL PRIVILEGES ON *.* TO 'root'@'localhost' IDENTIFIED BY 'mysql1' WITH GRANT OPTION;
SET PASSWORD FOR 'mvuser_pp'@'localhost' = OLD_PASSWORD('mvuser_pp1');
SET PASSWORD FOR 'mvuser_pp'@'%' = OLD_PASSWORD('mvuser_pp1');

CREATE TABLE `SoftWork`.`inmemo_00000000` (jn BIGINT UNSIGNED not NULL,db VARCHAR(255) not NULL,tbl VARCHAR(255) not NULL,rn INT UNSIGNED not NULL,E INT not NULL,lw INT UNSIGNED not NULL,PRIMARY KEY(jn,db,tbl,rn,E,lw),INDEX(db,tbl,rn,E));

Note:
The installer automatically configured MySQL for "default-storage-engine=INNODB" which is what we need here, but if you try to add the
softwork table while the my.ini default_engine is set to MYISAM you'll get an error about the key being too long.
The softwork table can only be added with the INNODB engine. And that is the only table we want to add that way.


Edit c:\u\mvs\mysql\my.ini

The installer automatically configured MySQL for "default-storage-engine=INNODB" in the c:\u\mvs\mysql\my.ini file which is what we needed
for adding the softwork.inmemo table but after the softwork table is added we MUST change the default engine to MYISAM.
Why? Because INNODB is ridiculously slow and MYISAM is acceptably fast.


- edit c:\u\mvs\mysql\my.ini and change "default-storage-engine=" from INNODB to MYISAM
Note: keep the "skip-innodb" option commented out (the default) because we still need innodb for the softwork table.
- go to the services window and stop then restart the MYSQL55 service so it accepts the new default engine


Set MYSQL_VERSION environment variable.

Make sure the following batch files have the following command: SET MYSQL_VERSION=5.5

win32\startup\ProfitsPlus.bat and test.bat
win32\env\setup_env.bat


You might as well add a Windows SYSTEM variable for it too. MySQL 4.1 does not need this variable.


Miscellaneous notes:

You shouldn't delete the two innodb log files; c:\u\mvs\mysql\data\ib_logfile0 and ib_logfile1
because MySQL will just re-create them again when you start the service up.


If you have to start all over and re-install everything the installer won't let you re-use the service name MYSQL55 until you delete it
yourself (uninstall doesn't remove it).
to delete the service from the services window go to a dos prompt and enter:
sc delete "MYSQL55"