Still celebrating National IT Professionals Day with 3 months of free Premium Membership. Use Code ITDAY17

x
?
Solved

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

Posted on 2010-11-17
8
Medium Priority
?
403 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
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
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
Survive A High-Traffic Event with Percona

Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.

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

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Question has a verified solution.

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

When you start your Windows 10 PC and got an "Operating system not found" error or just saw  "Auto repair for startup" or a blinking cursor with black screen. A loop for Auto repair will start but fix nothing.  You will be panic as there are no back…
When you try to extract and to view the contents of a Microsoft Update Standalone Package (MSU) for Windows Vista, you cannot extract the files from the MSU. Here we are going to explain how to extract those hotfix details without using any third pa…
This Micro Tutorial will teach you how to change your appearance and customize your Windows 7 interface to your unique preference. This will be demonstrated using Windows 7 operating system.
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.

722 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