Solved

how to install mysql and php locally on local computer running on Windows 7

Posted on 2010-11-17
8
386 Views
Last Modified: 2012-05-10
Hello. I may have made up some mistakes on my system in order to get me to test a simple database scritpt I created online. I want to be able to create and test php/mysql script on my computer first before putting it online. The problem is that everyone has a different method of installing what in what order and this coupled with reading many different installation procedures have been giving me no end of problems. Here is what I did.
I installed IIS which was recommended and installed 3 different php servers with different settings from developer to server settings. I also installed mysql.
so I would like to remove all versions of mysql and php and ISS and start from scratch. I have files in a directory that work online and are stored in a directory on my computer. So what is the recommended course of action to resolve this????? Any help would be appreciated.
0
Comment
Question by:PawloA
8 Comments
 

Expert Comment

by:sangramp
ID: 34161680
Hi,

Just unstall php from control panel and remove the "php" viz folder on your c or d drive where your software gets installed. and re-install the php software.
0
 
LVL 3

Expert Comment

by:boraganesh
ID: 34161685
if you would like to use the IIS refer below
install php, mysql with IIS  
http://wiki.phpgedview.net/en/index.php?title=Install_IIS_with_PHP_and_MySQL
or if would like to use apache server insted of IIS
just try XAMP..one click to install everything..
0
 
LVL 5

Expert Comment

by:-null-
ID: 34162360
Hi,

Remove all of the versions of PHP and mysql, along with IIS and install WAMP (http://www.wampserver.com/en/).

This installer will install and configure mysql, php and apache web server for you, so that everything works out of the box.

hth

-null-
0
 
LVL 3

Expert Comment

by:boraganesh
ID: 34162588
using apache+php makes life easy and faster...so try with apache server insted of IIS
0
Free Gift Card with Acronis Backup Purchase!

Backup any data in any location: local and remote systems, physical and virtual servers, private and public clouds, Macs and PCs, tablets and mobile devices, & more! For limited time only, buy any Acronis backup products and get a FREE Amazon/Best Buy gift card worth up to $200!

 
LVL 4

Expert Comment

by:eli_cook
ID: 34164111
As -null- suggests WAMP is a very powerful testbed for PHP and MySQL - I find it a great solution as you can choose your version of apache, php and MySQL, this way if you are working with a CMS or another framework you can pick you specific versions of the software for testing.
0
 
LVL 3

Expert Comment

by:boraganesh
ID: 34170346
yes, you can choose the XAMP or WAMP
http://www.apachefriends.org/en/xampp-windows.html
0
 
LVL 1

Author Comment

by:PawloA
ID: 34178500
great. I installed both wamp and xampp and none of them will start the php or mysql services and I can't go into the admin panel in mysql to create a database.
0
 
LVL 3

Accepted Solution

by:
boraganesh earned 500 total points
ID: 34178890
sorry for let reply...
you can start mysql, apache server and php through xamp control panel
also configure it to auto start on boot up.

To create database use phpmyadmin, its get installed with xamp
you can very welll access it through xampp control panel
http://localhost/xamp/
htpp://localhost/phpmyadmin/
0

Featured Post

How to improve team productivity

Quip adds documents, spreadsheets, and tasklists to your Slack experience
- Elevate ideas to Quip docs
- Share Quip docs in Slack
- Get notified of changes to your docs
- Available on iOS/Android/Desktop/Web
- Online/Offline

Join & Write a Comment

If you get continual lockouts after changing your Active Directory password, there are several possible reasons.  Two of the most common are using other devices to access your email and stored passwords in the credential manager of windows.
Meet the world's only “Transparent Cloud™” from Superb Internet Corporation. Now, you can experience firsthand a cloud platform that consistently outperforms Amazon Web Services (AWS), IBM’s Softlayer, and Microsoft’s Azure when it comes to CPU and …
Windows 8 comes with a dramatically different user interface known as Metro. Notably missing from the new interface is a Start button and Start Menu. Many users do not like it, much preferring the interface of earlier versions — Windows 7, Windows X…
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

743 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

11 Experts available now in Live!

Get 1:1 Help Now