Easy guide for installing WAMP and using phpMyAdmin

September 21, 2007

Installing PHP'>WAMP

PHP'>WAMP (Windows, Apache, MySQL, Php) is very easy to install and you can obtain it from PHP'>WAMP Server home page. It is convenient to install the PHP'>WAMP bundle than to install Php, Apache, MySql as separated modules.

Just follow the next steps:

  • Download a copy of PHP'>WAMP from server home page. Launch the wamp5_X.XX.exe to begin the installation. The WAMP5 Setup Wizard will appear and for begin click Next.
  • As we are accustomed in the License Agreement select Accept the agreement and click Next.
  • In the Select Destination Location screen we can change the default path by choosing Browse. Now click Next.
  • Select Start Menu Folder: we will use the default WampServer.
  • Select Additional Task: you can check Automatically lunch WAMP5 on startup. If you don’t choose this you can manually start the PHP'>WAMP Server.
  • Ready to install: just click install
  • Installing: here is the screen that appears with the progress of installation process.
  • Now you have to select the default publishing folder or DocumentRoot folder. Any files that are stored here can be access in the Internet by typing the IP address of the machine
  • Now comes the screen for selecting the default web browser.
  • Finally click Finish to complete the installation.

You can observe that a new icon appeared on the task bar to the left side of the clock. You can choose to start or to stop the server on your computer. To starting the server click Start > All Programs > WampServer > Start WampServer. Click the WAMP5 Server icon in the task bar and select Start All Services.

There are articles in this websites about working with Php or MySQL, so here I choose to present the phpMyAdmin script. PhpMyAdmin is a popular open source software that allow manager-ing MySQL databases in a pleasant visual way. It is a lot easier to query databases using PhpMyAdmin than typing queries in the command line. Why shouldn’t use phpMyAdmin as long as it comes with the PHP'>WAMP packages.

A short description of using phpMyAdmin

Importing Files

After you lunched phpMyAdmin click the SQL menu icon sql.jpg. This will open a new browser window with a menu at the top of the screen. Just click Import Files and now you will have to choose the file for importation (only .sql files) and click Go to complete the import process.

Working with Databases and Tables

Important! Before starting editing a database you have to select a database to work with. In the left side there is a drop menu for this. After selected a database, it will appear a list of tables with detailed information.

table.jpg

The menu allows to perform actions such as: checking the table structure, SQL commands, exporting tables data and structure to files, searching the database, performing queries and operations to databases and dropping the database.

As we seen in the previous image there are action buttons like : browsebrowse.jpg(for displaying data in the table), searchsearch1.jpg(for searching data in the table), insertsearch.jpg(for inserting records in the table), structurestructure.jpg(for displaying records in the table), emptyempty.jpg(for deleting the table contents) and dropdrop.jpg(for deleting the table).

The records column shows the number of individual records within a table. The type column indicates the type of table used. Collation is the language/character set and size indicates the KB of the table.

By clicking any table name it will be displayed the table fields, types, character sets, special attributes, Null (if the field is empty), the default content, extra information, and another set of action buttons. The action button allows handling the data stored in each field of the table. The actions you can do are: changing the structure of the data field, deleting the field, setting the field as a primary key, index the field, make the field unique and adding full text.

Inserting Data

You can insert data into the table by clicking the Insert tab. All you have to do is to complete the form and click Go to add a record to the table. As you see it is easiest to complete a form than to type the query “insert into table values(…)” because we might have omitted an apostrophe and trying to fix it might be difficult.

Exporting a Database

Being able to make a backup of your databases is very usefully if we have to move our databases on another server. PhpMyAdmin is usable when it comes to it. Of Course it has limitations of database size ( it’ll do the export even if the database is big but the import part is not like that. Cant import a file without considering the size. That’s because it uses PHP as a processing language and PHP limits the uploaded file size. But anyways, PhpMyAdmin is a great tool and is used probably on each MySql server on this world ;)

So, go to Export Menu and in the export page un-check Add Auto_Increment Value. Check Save As File and type a filename in the template box or let the engine to use the templated name. Click Go for finishing the process.

I thought it’s enough what I said here but if anyone there needs a better, detailed tutorial about using this awesome script I would be happy to publish it. Use our forums if you have any question ;)

 

11 Comments for “Easy guide for installing WAMP and using phpMyAdmin”

  1. michel Says:

    nice tutorial
    Thanks

  2. Brian Finneran Says:

    This was a fine summary of loading the PHP'>WAMP environment, and getting phpmyadmin off the ground.

    But what do I do if everything seems fine within the WAMPSERVER process, and php programming functions, etc.working well, until it is time to work with mysql. In starting phpmyadmin, on the welcome page it says “ACCESS DENIED”??
    I’ve tried to find solutions, changing a couple of .conf files to say allow before deny .. but nothing has changed.

    Thanks for your help.

    Brian in NY

  3. bobby mcgee Says:

    I had the PHPMyAdmin 404 Error Access Denied “You don’t have permission to access /phpmyadmin/ on this server.”

    How I fixed it:

    1) If you have anything stored in the MySQL database, find a way to dump it so you can repopulate the data in a new installation.

    2) Download the latest version of PHP'>WAMP / WAMP5.

    3) Uninstall the old version from your windows Control Panel / Program Files.

    4) Close all of your folder / apps / browsers that might have anything to do with the wamp installation.

    5) Delete the c:/wamp folder (WARNING! THIS WILL DELETE ANYTHING IN YOUR MySQL DATABASE.)

    6) Re-install PHP'>WAMP and it should probably work.

  4. ali Says:

    sancis

  5. s Says:

    i ve installed wamp server 2 on windows 2003 server. before installed it i remove iis. everyday when i start server machine wamp database which i created was automatically removed. i have clicked both install services(appache and mysql) and i put it online , set to automatically start with widows startup. why auto remove that created database?

  6. tina Says:

    would like a detailed quide on how to use phpmysqladmin.
    thank you

  7. Divyashwar raj Says:

    I del the index.php file and create on my site ….
    Then I just type http://localhost/phpmyadmin/ there is no page is open …. there is bank page .
    so, help me how to solve problem

  8. Sophus Says:

    I also get the “Access denied” error… I solved the problem by typing “127.0.0.1/phpmyadmin” instead of “localhost/phpmyadmin”

  9. Saurabh Says:

    Thanks Sophus it worked for me too.
    No password or user name change required.
    Just type 127.0.0.1/phpmyadmin

  10. Lawrence Says:

    I tried the above url but received an error message like this #1045 - Access denied for user ‘root’@'localhost’ (using password: No)

  11. Lawrence Says:

    Please what do I do!! Urgent reply please

Post a comment

Name (required)

Mail (will not be published) (required)

Website

*
To prove you're a person (not a spam script), type the security text shown in the picture. Click here to regenerate some new text.
Click to hear an audio file of the anti-spam word