Install MySQL

Knowledge Base / Manual Installation

This article will help you install and configure MySQL server. The installation is compatible with WITSuite family of products.

Save Your Time with EasyInstaller

Install Apache, MySQL, PHP in just a few clicks.

witsuite.com/products/installer/

Manage Your Web Environment

Install many Apache, MySQL, PHP versions and other packages with EasyManager.

witsuite.com/products/manager/

Overview

Using this installation gude you can:

• install many MySQL versions on the same operation system;
• simplify upgrading MySQL in future.

Pre-installation notices

The directory layout is described in the Create Directory Layout article.

During installation your firewall software may ask you what to do with the mysql executable that listens for incoming connections on some port. Depending on desired security settings and firewall features, you can allow incoming connections from any computer, from a network or only a few computers. Disabling all network access for the MySQL executable makes connecting to the service impossible, even from localhost.

You can change the name of the folder with MySQL installed to something like MySQL, MySQL5, MySQL-5.0.51b, etc. Just use it instead of MySQL-5.0 in the commands below.

Continue with Download and unpack.

Download and unpack

Download the MySQL 5.0.x brach ZIP package for your system atrchitecture (eigher x86 or x64) from the MySQL download page  to the C:\WITSuite\Packages folder. Optionaly, verify the integrity  of the downloaded file. The path of the downloaded file may be the following (for the MySQL server 5.0.51b):

C:\WITSuite\Packages\mysql-noinstall-5.0.51b-win32.zip

Unpack C:\WITSuite\Packages\mysql-noinstall-5.0.51b-win32.zip\mysql-5.0.51b-win32 to the C:\WITSuite\Servers\MySQL-5.0 folder.

Optionally, delete mysql-test and sql-bench in the C:\WITSuite\Servers\MySQL-5.0 folder.

Optionally, create the "C:\WITSuite\Documentation\MySQL-5.0 Documentation.lnk" shortcut to the C:\WITSuite\Servers\MySQL-5.0\Docs\manual.chm file.

Continue with Creating MySQL service.

Creating MySQL service

The service is identified by its name. For example, assume that the service is called "MySQL-5.0".

Create the following folders:

• C:\WITSuite\Configuration\MySQL-5.0
• C:\WITSuite\Data\MySQL-5.0

Copy C:\WITSuite\Servers\MySQL-5.0\data to C:\WITSuite\Data\MySQL-5.0 (you should not have the data subfolder in the MySQL-5.0 folder).

Copy C:\WITSuite\Servers\MySQL-5.0\my-medium.ini to C:\WITSuite\Configuration\MySQL-5.0\my.ini.

Make the following changes in the C:\WITSuite\Configuration\MySQL-5.0\my.ini file:

• if you want MySQL listen non-staqndard port, change the value of the port directive;
• set the basedir directive to C:\WITSuite\Servers\MySQL-5.0;
• set the datadir directive to C:\WITSuite\Data\MySQL-5.0.

Register and start MySQL-5.0 (execute commands in command prompt):

C:\WITSuite\Servers\MySQL-5.0\bin\mysqld.exe --install "MySQL-5.0" --defaults-file="C:\WITSuite\Shortcuts\MySQL-5.0\my.ini"
net start "MySQL-5.0"

Create the C:\WITSuite\Shortcuts\Service.MySQL-5.0.bat file with the following content:

@echo off
set PATH="C:\WITSuite\Servers\MySQL-5.0\bin"
C:\WITSuite\Servers\MySQL-5.0\bin\mysql.exe -P 3306 %*


To test the connection to MySQL execute in the command prompt the following command:

C:\WITSuite\Shortcuts\MySQL-5.0.bat

You should see command prompt window with MySQL welcome notice. Type commands and check the result or just enter quite command.

Questions/Feedback

If you have question/feedback or see an error feel free to send it to us through the email address contact@witsuite.com.

(This page content is available under a Creative Commons Attribution-Noncommercial-No Derivative Works license.)