Customer Login



Recover Password

WorkOrder TS Support Database

 

Bookmark: Root \ Installation Guides \ Part II - Install the MySQL 5 database server on a Windows Computer/Server

Part II - Install the MySQL 5 database server on a Windows Computer/Server


Last Updated: 2012-05-10
This is Part II of a three part guide on how to install Apache2, PHP 5 and MySQL on a Windows computer or server.
Part I covers the Apache 2.4 Web Server
Part II covers the MySQL Database Server
Part III covers the PHP 5.3 installation

PART II - Install the MySQL5 database server on a Windows Computer/Server

Double click on the .msi file to start the setup programm.
Follow the instructions given to you by the installer and choose the "Typical" installation method when prompted.

Once the installation is complete ensure that the box next to "Launch the MySQL Instance Configuration Wizard" is checked, then click on "Finish".


At the MySQL installation type prompt, please select "Detailed Configuration"


Server Role should be Server Machine


It is very important that you install MySQL 5 as a "Multifunctional Database" since Work order Processing is currently using MyISAM but might switch to InnoDB in the future.


Set the MySQL5 connection limit to 20-50. Expect one connection for each active user, database connection time per user request is less then 1 second on most high-speed connections.


The MySQL 5 options below should be selected by default. Please ensure they are.


Keep the Standard Character Set, Latin1.


Please check the box "Include Bin Directory in Windows Path".


Please enter a secure root password, I have written a Online Random Password Generator


Almost Done, time to execute the configuration. Please click on "Execute"


I received this Firewall error on Windows XP Home SP2 (no updates) without receiving the Windows Firewall notice I received during the Apache installation. A simple "Retry" took care of this error.


MySQL 5 installation complete without errors.


MySQL 5 is now installed and running, but how do we know?
Click on Start => Run and enter cmd into the box, command for Windows 98 and ME and Click on OK


Once the black window, Command Prompt, is open, type "netstat -an"
Make sure that you can find port 80 (apache) and 3306 (mysql) on the list.


That's it for Part II of this guide, your MySQL database server is now up and running. Please click here for Part III

This guide has been written by WorkOrder TS.com to provide a simple step by step guide on how to get Apache 2.4, MySQL 5 and PHP 5.3 to talk to each other. You did not write it so please don't copy the content!
Feel free to link to it using the tiny URL: http://www.workorderts.com/tiny.php?id=22

 

No Comments yet .....

 

Add Your Comment:

Note: All posts require administrator approval. Please allow 24 hours for message approval.

Name:
E-Mail:
Title
Plain text only, less then 65 000 characters.

What color do you get when you mix yellow with red?

Please answer the question above and type the answer into the text box below.