installing apache 2.2



Install MySQL 5.1 on Microsoft Windows

(MySQL 5.1.51 Page 8 of 8)

MySQL TroubleShooting:

If you encountered an error here. The most likely cause is that you have had a previous installation of MySQL and there are config files interfering with your new setup. Windows XP has a folder in Documents and Settings with your old MySQL setup info. Win Vista, 2008 and 7 like to keep this in the newer location, ProgramData. In either case, those files should be deleted or backed up. Using the Windows uninstaller (though recommended) does not catch all files. Always back-up before deletion if you have a functioning database you have been using and would like to keep. You may need to check path and program settings. This type of scenario always dictates you use extreme care. Read to the end of this section before attempting to debug your error. There is a very good debug link listed in this section.

If upgrading, ensure your version is compatible to this upgrade as noted on page one of this tutorial under the section: Preliminary MySQL 5.1 Installation Steps.

Of course, UAC can interfere too. Check our other install guides for more data on handling the UAC or review the Microsoft link given on page one of this guide..

MySQL 5.1 Troubleshooting
(Fig. 20)
Installing MySQL MySQL51. Error: 0 Pic

Your first resource to use when troubleshooting MySQL 5.1 server issues is to check the error log. Check the file errmsg.sys in the shared/english (or other language) folder. Toggle hex modes in your hex reader (eg. ultra edit) if you have any difficulty reading the file. It will be located in a path similar to C:\Program Files\MySQL\MySQL Server 5.1\data or in C:\ProgramData\Mysql on Windows 7 and Windows Server 2008. The C:\ProgramData directory is hidden by default.

Also, a great troubleshooting resource for MySQL 5.1 under Windows is the mysql trouble shooting page.


Module Completion

If you are confident with what you have learned here, then you have also gained a couple of very basic entry level skills in mastering your PHP Software. Pat your self on the back, you have completed this course module.


Module Length:

  • 1 Hour


The website administrator has previously attained the following computer skills:

  • Ability to download an installation file and execute it.
  • Ability to code a basic .php script (and/or)
  • Ability to navigate a Dos session

Applicable OS Platforms :

  • Windows 7
  • Windows 2008
  • Windows Vista
  • Windows 2003
  • Windows XP (SP3)

Hardware-requisites: (on Windows OS)

  • x86 family processor - All (eg. Intel, AMD)
  • x64 family processor - All (eg. Intel, AMD)

Share this MySQL 5.1 Tutorial with your Friends:

Share this Study Guide by email
e-mail page link to Selected Friends & Colleagues
Valid XHTML 1.0 Strict Valid CSS!

Copyright © 2010
Website Administration Services
Module created by: Steve Campisi
(Graduate of the Australian Nationally Accredited Certificate IV in Training and Assessment course. Formal certificate for formal Training and Assessing in Australia.)
This guide is intended for use as a quick reference set only. Any discrepancies should be clarified by, and favor, consultation with official MySQL documentation.
Header Photo Credit: Glenn Grant, National Science Foundation

Many Website Hosting companies offer Apache HTTP server, PHP and MySQL as a default website configuration as this trio make for a robust website backbone which is one of the most popular website setups today.

With Apache HTTP Server powering close to 112 million Webservers world-wide today and thanks to Apache and other developers, Windows users can now run this triumvirate of must have server software on their Windows computers.