Solved

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

Posted on 2010-11-17
8
394 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
PRTG Network Monitor: Intuitive Network Monitoring

Network Monitoring is essential to ensure that computer systems and network devices are running. Use PRTG to monitor LANs, servers, websites, applications and devices, bandwidth, virtual environments, remote systems, IoT, and many more. PRTG is easy to set up & use.

 
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
 
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

Netscaler Common Configuration How To guides

If you use NetScaler you will want to see these guides. The NetScaler How To Guides show administrators how to get NetScaler up and configured by providing instructions for common scenarios and some not so common ones.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

While working, an annoying popup showing below will come and we cannot cancel or close it form the screen. The error message will come again and again.
Lease-to-own eliminates the expenditure of hardware replacement and allows you to pay off the server over time. Usually, this is much cheaper than leasing servers. Think of lease-to-own as credit without interest.
In this video, we discuss why the need for additional vertical screen space has become more important in recent years, namely, due to the transition in the marketplace of 4x3 computer screens to 16x9 and 16x10 screens (so-called widescreen format). …
This Micro Tutorial will give you a introduction in two parts how to utilize Windows Live Movie Maker to its maximum editing capability. This will be demonstrated using Windows Live Movie Maker on Windows 7 operating system.

838 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