How to install MySQL 5.0 on Windows XP?

Asked By christ hilyard 10 points N/A Posted on - 06/17/2012

 

Hi experts, I want to install MySQL 5.0 on windows XP? Will you please provide me a step by step solution? That I could do this easily?  

 

• Status: Open
• Question Views: 1426
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: Yes
• Question Category: MySQL Server

Best Answer by Gayronwatu

Go To Solution

Best Answer

Best Answer

Answered By Gayronwatu 0 points N/A #154012

How to install MySQL 5.0 on Windows XP?

Hello Christ,

 

You will do the subsequent steps otherwise you can move to this address 

http://ww38.alldon.info/install-mysql-windows.php

 

And you'll get some ideas.

 

You can transfer MySQL five.0. Latest version from https://dev.mysql.com/downloads/mysql/5.0.html. 

It is named as: mysql-essential-5.0.16-win32.msi

Go to the subsequent steps to put in it to your laptop. 

1. Run the MSI file and use the subsequent settings.
2. Typical Setup
3. Skip Sign-Up
4. Make sure ""Configure the mySQL server now"" is checked.
5. Detailed Configuration""
6. Developer Machine""
7. Multifunctional Database""
8. InnoDB Tablespace Settings"" – leave everything defaulted
9. Decision Support (DSS)/OLAP""
10. Make sure ""Enable TCP/IP Networking"" is checked and leave the port range at 3306 (at now, if you've got a firewall, it'll sometimes try to access itself on the local host)
11. ""Standard Character Set'""
12. Check ""Install As Windows Service""
13. I recommend the departure ""Include Bin Directory in Windows PATH"" checked to
14. Enter your root positive identification
15. Then hit ""execute"" and it´ll install and set it up.

Getting PHP5 to figure with mySQL

Unfortunately, PHP5 removed constitutional support for mySQL. Therefore, you´ll have to be compelled to copy some files by hand. Open the folder you unzipped your PHP to. Copy thelibmysql.dll file (should be settled like c:php5libmysql.dll ) into your Window´s System folder (usually C:WindowsSystem32 though could be c:WinNTSystem or something). 

 

Then open up your php.ini in a very text editor and search for;extension=php_mysql.dll and take away the; ahead of that line. 

Do a similar for ;extension=php_mbstring.dll while not the mbstring extension phpMyAdmin is unable to separate strings properly, and it should end in surprising results. 

 

Restart Apache and see if you get any errors. If it complains aboutphp_ mysql.dll. Either your extension directory isn´t correct or windows can´t notice libmysql.dll

 

If you don´t need to maneuver files outside your php5 directory, you will conjointly add the php5 directory to the trail on Windows. Please browse through the subsequent article in a way to try this.

 

Examining MySQL is not exactly easy. But the usual connection strings for PHP and CGI are grouped together. I will suggest downloading the phpMyAdmin and oppress it to make and supervise your databases and more.

About Gayronwatu

Questions
0

Answers
20

Best Answers
5

• Vote Up 0 Vote Down

• Posted on - 06/17/2012
• Question Category: MySQL Server