MySQL database installation guide
<accesscontrol>Main:MyGroup</accesscontrol>
MySQL database installation guide
MySql distribution to install
Version 5.0
How to get MySql
http://dev.mysql.com/downloads/mysql/5.0.html
Installing MySql on Windows
Installation Package : indows (x86) ZIP/Setup.exe
Install MySql with the Automated Installer : Unzip the package, and run setup.exe file
Installation Steps : After double clicking the setup file, the Setup Wizard is started. Click Next button to start on Step 1.
Step 1 - Choose the setup type
Click Custom radio button in order to select the needed features to install. Click Next button to go to step 2.
Step 2 - Custom Setup
Click Developer Components button and choose This feature will not be available to have developer components not to be installed.
Click Change… button to modify the location for installing MySql (if necessary). Click Next button to go to Step 3
Step 3 - Install the program
Read the current settings summary before starting to install. Click Install button to start installing.
The installation progress is shown.
At the final step of the installation progress, you are asked to sign up to MySql.com.
Finalizing the wizard
Check Configure the MySql Server now checkbox to start configuration wizard or uncheck to start it later.
Configuration Wizard
Click Next button to go to Step 1.
Step 1 - Select configuration type
Click Detailed Configuration radio button and press Next button to go to step 2.
Step 2 – Select a server type
Click Server Machine radio button to have server applications to run on the current machine. Press Next button to go to Step 3.
Step 3 – Select database usage
Click Non – Transactional Database Only radio button to activate only the non – transaction MyISAM storage engine. Press Next button to go to Step 4.
Step 4 – Number of concurrent connections
Click Manual Setting radio button and set the approximate number of concurrent connections to the server to 100. Click Next to go to Step 5.
Step 5 - Enable TCP/IP Networking and Strict mode
Step 6 - Set the default character set
Step 7 - Set the Windows options
Check Install As Windows Service checkbox and change the service name (if necessary).
Check Launch the MySql Server automatically checkbox.
Check Include Bin Directory in Windows PATH checkbox in order to be able to access MySql via the command line.
Step 8 - Set the security options
It is very important to check Enable root access from remote machines checkbox in order to make the Data Cache Specification module work.
Finalizing steps
System variables settings
File to modify
§ …\MySQL\MySQL Server 5.0\my.ini
§ (C:\Program Files\MySQL\MySQL Server 5.0\my.ini if you have not changed the default directory for installing MySql)
System variables
§ query_cache_size=0M
§ max_connections = 100
§ table_cache = 256
§ tmp_table_size = 100MB
§ myisam_sort_buffer_size=5MB
§ key_buffer_size = 100MB
After changing any system variables, restart MySql service.
Disk issues
Data directory should be on a fast drive.
System variable to modify
§ datadir="…/Data/"
Before modifying the value of datadir, stop MySql service.
After setting the datadir system variable to a different place, move the Data subfolder (…\MySQL\MySQL Server 5.0\data) to that location and then restart the service.
