Install Web Server in Windows XP with Apache2, PHP5 and MySQL4 - Part 4

Part 4 - Install MySQL 4.1

Run the MySQL Essentials Installation package setup.exe that downloaded in Part 1. Follow on screen instruction for the whole installation. Halfway into the installation, choose the installation path you want. Anywhere is fine, but recommended to install inside the Apache2 root level (i.e. C:\Server\mysql).

Then choose “Typical” for installation type. Installation is finished after that. Make sure Configure MySQL is clicked, so that once you click finished, MySQL Server Instance Configuration Wizard will be lauched.

For the MySQL Configuration Wizard:

  • Choose Detailed Configuration.
  • For Server Type, you may choose Developer Machine, Server Machine or Dedicated MySQL Machine depends on your configuration.
  • For Database Usage, you may choose Multifunctional Database, Transactional Database Only or Non-Transactional Database Only depends on your configuration. Generally, Multifunctional Database works best.
  • Leave InnoDB Tablespace Settings as default.
  • Choose your desired concurrent connections to MySQL server. It’s possible to re-configure it when usage grows.
  • Ensure TCP/IP Networking is enabled.
  • Choose UTF8 as default character set, unless you’re certain that you’re using English or Western Europe languages only.
  • Enable Install As Windows Service and Include BIN Directory in Windows PATH, so that you can call mysql executables anywhere from DOS Command Prompt.
  • Key in the password for root user. Never enable the Anonymous Account, it’s less secure.

Press Execute to configure MySQL Server. Installation for MySQL is done.

MySQL creates two shortcuts in Start menu. MySQL Server Instance Config Wizard enables you to re-configure or configure if you have’t done so, the MySQL Server. MySQL Command Line Client enable to login to MySQL and uses SQL to query it.

Testing MySQL Server

Login to MySQL Command Line Client with the root password that used during the installation. After that try to run a simple query (use mysql; or show databases; etc). If it returns valid results, then installation is successful.


This entry was posted on Sunday, October 16th, 2005 at 12:44 am and is filed under Databases, Programming Languages. You can follow any responses to this entry through the RSS 2.0 feed. You can leave a response, or trackback from your own site.

8 Responses to “Install Web Server in Windows XP with Apache2, PHP5 and MySQL4 - Part 4”

  1. NavBrat14
    April 11th, 2008 14:45
    8

    It is one of things I can never understand … how people can think that way. It’s so illogical that it can only be based upon moronity.

  2. Richard
    February 25th, 2008 23:32
    7

    ok I try to make a sight log into the SQL database, and I get an error that tells my I do not have the module loaded.. I rechecked this info with your site many times and con not find out what I did wrong.. Please if someone knows reply via e-mail to admin@mysticcorp.com

  3. Johan
    August 25th, 2007 14:28
    6

    This tutorial was really easy, I’ve done this installation in the past but it wasn’t as easier as this one. Thanks

  4. roshan
    June 20th, 2007 02:25
    5

    An error has occurred during installation :
    The PHP configuration on your server doesn’t support the database type that you chose

    what is this?? I followed every steps carefully…but finally i got this message when i hit the start install button..
    please help me..

  5. Robert K S
    June 12th, 2007 01:36
    4

    That “Ensure TCP/IP Networking is enabled.” step is key–neglect disable it at the peril of getting Error 2017 (failed security settings setup) at the execute phase of the installation!

  6. lazynavd
    February 14th, 2007 08:56
    3

    Good tutorial… a fast alternative method is
    to try VertigoServ … all-in-one package. http://vertrigo.sourceforge.net/

  7. b.b.goyal barnala
    June 9th, 2006 01:30
    2

    i installed xampp. how to enable inndb in it? regards.

  8. ravinder singh
    April 23rd, 2006 14:28
    1

    thanks dear.

Leave a Reply

You can use these tags: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <strike> <strong>

Subscribe to comments feature has been disabled. To receive notification of latest comments posted, subscribe to My Digital Life Comments RSS feed or register to receive new comments in daily email digest.
« Install Web Server in Windows XP with Apache2, PHP5 and MySQL4 - Part 3
Install, Setup and Configure CGI and Perl in Windows XP »

Custom Search

New Articles

Incoming Search Terms for the Article