LD SoftwareBespoke Software, Web Design, Security Consultants and Host Services.


You have been warned!
We have caught 5848 shameful hackers.


Paypal Referral
Sign up for PayPal and start accepting credit card payments instantly.

Link Exchange
Join our free link exchange

Click Here
phpMyAdmin: How to administer MySQL via Web

3.4. phpMyAdmin: How to administer MySQL via Web

Once you have opened your phpMyAdmin (to do this, if you are working locally, you would have to open http://localhost/phpmyadmin with your browser), you will get a screen that offers you the possibilities of

  • Select a database through a drop-down list.

  • Create a new database

as in Figure 3-7.

Figure 3-7. phpMyAdmin: Select database.

phpMyAdmin: Select database.

Once you have chosen the desired operation, you arrive at the administration interface of your phpMyAdmin. Newer versions contain a navigation bar, located at the top (Figure 3-8), offering the following options:

  • Structure: See the database structure.

  • SQL: Execute SQL operations (e.g. load an existing database).

  • Export: Make a backup of the database.

  • Search: Search for data.

  • Query: Display the structure of an SQL query (useful for programmers).

  • Drop: Delete a database (be careful!).

Figure 3-8. phpMyAdmin: Navigation bar.

phpMyAdmin: Navigation bar.

As far as we are concerned here, we only need to explain the first 3 items:

You can syndicate our News with backend.php And our Forums with rss.php
You can also access our feeds via Feedburner Site News and LD Software Forums
© 2009 ld-software.co.uk All Rights Reserved.
PHP-Nuke Copyright © 2005 by Francisco Burzi. This is free software, and you may redistribute it under the GPL. PHP-Nuke comes with absolutely no warranty, for details, see the license.
Page Generation: 0.36 Seconds