)
Follow these steps to install mysql 4.1 on Windows XP/Windiws Vista.
Recommended Requirements: php 5.1, apache 2.2.3
Installing MySQL
- Download the installation file from http://www.mysql.com/
- Double click on the exe file to begin installation.
- Follow the on-screen instructions.
-
Select ‘Custom’ in SetUp Type and continue.
- Click on ‘Change’ to change the installation folder.
- Follow the on-screen instructions.
- Select ‘Skip Sign-Up’ and continue when you are asked to sign-up.
- Click on ‘Finish’ to complete the installation.
Configuring MySQL
- Search and open ‘MySQL server Instance Configuration Wizard’.
- Select ‘Standard Configuration’ when given a choice.
- Select ‘Install as Windows Service’ and ‘Launch the MySQL server automatically’
- Select ‘Modify Security Settings’ and enter root password (username is ‘root’).
- Click on ‘Execute’ to save the configuration details.
Change configurations in php
- Open ‘php.ini’ in notepad.
- Search for ‘extension_dir=”.” and replace with
extension_dir = "C:\Web Server\php\ext"
- Search for this line and uncomment it
extension=php_mysql.dll
- Copy ‘libmysql.dll’ file (should be located in ‘C:/Web Server/php’ folder ) into your Window’s System folder (usually C:/Windows/System32 )
- Save and close the file.
- Restart apache.
Install phpMyAdmin
- Download zipped folder of ‘phpMyAdmin from http://www.phpmyadmin.net/
- Extract the file.
- Move the folder to the web-server root directory (C:/Web Server/www)
- Open a web browser. Type the following and press enter. If there is no error, then the installation was successful.
For any query please send email to saurabh(at)techwhiz(dot)in