PHP(Part: III):-MySQL Installation

MySQL 4.1

1.Download MySQL v4.1

Download MySQL from http://dev.mysql.com/downloads/mysql/4.1.html Just make sure you get a Windows Essentials (x86) binary version. (after you click "pick a mirror," skip all the questions part and scroll down to the mirrors list)

My file was named: mysql-essential-4.1.22-win32.msi

2.Install MySQL v4.1

• Run the MSI file and use the following settings
• Typical Setup
• Skip Sign-Up
• make sure "Configure the MySQL Server now" is checked
• "Detailed Configuration"
• "Developer Machine"
• "Multifunctional Database"
• "InnoDB Tablespace Settings" - leave everything default
• "Decision Support (DSS)/OLAP"
• make sure "Enable TCP/IP Networking" is checked and leave the port number at 3306 (at this point, if you have a firewall, it will usually try to access itself on the localhost)
• "Standard Character Set"
• check "Install As Windows Service"
• enter your root password and I would recommend leaving "Enable root access from remote machines" unchecked
• then hit "execute" and it'll install and set it up.

3.Getting PHP5 to work with MySQL -

Unfortunately PHP5 removed built-in support for MySQL. To get it to work, the easiest way is to copy the mysql library file by hand. Open the folder you unzipped your PHP to. Copy the libmysql.dll file (should be located like E:\php\libmysql.dll ) into your Window's System folder (usually C:\Windows\System32\ although might be C:\WinNT\System\ or something).

Then open up your php.ini in a text editor and search for ;extension=php_mysql.dll and remove the ; infont of that line

Restart Apache and see if you get any errors. If it complains about "php_mysql.dll" either your extension directory isn't correct or windows can't find libmysql.dll

Testing MySQLTesting MySQL is not exactly easy. However, here are the common connection strings for PHP and CGI. I recommend downloading phpMyAdmin and using it to create and manage your databases, etc.

PHP Connection test

?>?>?>?>?>?>