MySQL 5.0 setup guide for web server

MySQL5 is not a necessary component for a Web server machine, but many web programs such as forum softwares use it. It is better to have one so you can make use of many free web programs on the internet.

To work with MySQL5 for Windows, we strongly recommend You to use the PHP5 version of RaidenHTTPD, which can be downloaded from here.

1. Download latest v5.0x for Win32 from www.mysql.com

mysql's page: http://www.mysql.com/

mysql 5.0.x download page: http://dev.mysql.com/downloads/mysql/5.0.html#win32

Note: Please download Windows downloads versions if you are running Win32 Platform

2. Un-zip the package and run setup.exe.

Please make sure to install to the c:\program files\mysql\mysql server 5.0\ , the default location. We'll use this path throughout the whole tutorial. Unless you know what you are doing, otherwise, please do not change it.

3. Begin to setup.

Skip the sign-up, You probably don't need an account.

Check the checkbox for Configure the mysql server now.

4. Now begin to configure MySQL 5.

Select detailed configuration and click next.

Select proper server type from developer (which may consumes fewer memory but lower performance) to server machine (balanced) or dedicated MySQL server machine (which uses more system resource but with best performance).

Select database type:
multifunctional database: the most powerful choice.
transactional database: supplies sql transactions capabilities through inno-db.
non-transactional database: suitable for small bussiness web sites which don't need transactional database support. *recommended

Select the expected max con-current connections.
DSS for 20 connections
OLTP for 500 connections
or Manual setting to specify Your own desired number.

Enable MySQL server through the TCP/IP networking: this is probably a must have, and usually You do not need to change the default port for MySQL server, 3306. Make sure to configure Your Firewall and Router properly if You want to allow MySQL accesses from remote machines.

Select the default character set, for european or american users it is safe to use Standard character set or Best Support for multilingualism.

Specify the windows service name for MySQL 5 server, we recommend You to set it to MySQL5 to be distinguishable from other MySQL installations.

Now here comes the most important part, set the password for Your root account, and You have to write this down. If You don't turn on enable root access from remote machines, You will be only able to connect to localhost MySQL Server.

Click execute to finish the setup, remember that Your account is root, and Your password, and default MySQL server address is localhost and the port is TCP 3306.