Home arrow Apache arrow Page 4 - Creating a VAMP (Vista, Apache, MySQL, PHP) Setup

MySQL - Apache

With the abundance of communication between the browser and a server in these days of AJAX and JSON data interchange, there has never been a better time to get your own development web server set up so that you can test all those dynamic scripts you’re writing. This article will show you how to do it using some of the most popular software.

TABLE OF CONTENTS:
  1. Creating a VAMP (Vista, Apache, MySQL, PHP) Setup
  2. Installing and Configuring Apache
  3. PHP
  4. MySQL
  5. Configuring
By: Dan Wellman
Rating: starstarstarstarstar / 41
May 20, 2008

print this article
SEARCH DEV SHED

TOOLS YOU CAN USE

advertisement

Speaking of MySQL, installing this is our next task. Run the installer and click through all of the install wizard screens, selecting the defaults. Once the installer has finished, the configuration wizard will launch; you can click through each screen, mostly just going with the default options. On the Enable TCP/IP Networking screen, make sure the Add Firewall exception for this port checkbox is selected to prevent your firewall blocking the port used by the MySQL server. You'll also want to set a password on the Modify Security Settings page. The application should then configure itself.

Now we need to test that everything worked as it should. To open the MySQL command line interface go to:

Start -> All Programs -> MySQL -> MySQL Server 5.0 -> MySQL Command Line Client

You'll be prompted for a password. Use the one that you chose when installing MySQL. You should then see the welcome message and command prompt. At the prompt type SHOW DATABASES;

 

These are the built-in databases that come with MySQL and this shows that the database server is running. Enter the command USE test; in the CLI to select the test database, and then enter the command:

CREATE TABLE people (name VARCHAR(20), likes VARCHAR(20));

This will create a new table called people in the test database. To add some data to the table use the following command: INSERT INTO people VALUES ('Dan', 'House music');



 
 
>>> More Apache Articles          >>> More By Dan Wellman
 

blog comments powered by Disqus
escort Bursa Bursa escort Antalya eskort
   

APACHE ARTICLES

- Apache Unveils Cassandra 1.2
- Apache on ARM Chips? Dell and Calxeda Help M...
- The Down Side of Open Source Software
- VMware Unveils Serengeti for Apache Hadoop
- SAP Takes Steps to Improve Hadoop Integration
- Looking to Hone Apache Hadoop Skills?
- How to Install Joomla on WAMPP
- Working with XAMPP and Wordpress
- GUI Available for Apache Camel
- Reduce Server Load for Apache and PHP Websit...
- Creating a VAMP (Vista, Apache, MySQL, PHP) ...
- Putting Apache in Jail
- Containing Intrusions in Apache
- Server Limits for Apache Security
- Setting Permissions in Apache

Developer Shed Affiliates

 


Dev Shed Tutorial Topics: