Book Image

phpMyAdmin Starter

By : Software Freedom Conservancy Inc, Marc Delisle
Book Image

phpMyAdmin Starter

By: Software Freedom Conservancy Inc, Marc Delisle

Overview of this book

phpMyAdmin is an extremely popular, free and open source tool intended to easily handle the administration of MySQL with the use of a web browser. It can perform a variety of tasks in order to efficiently manage web databases. With this helpful step-by-step guide, we will build a solid understanding of the core capabilities of phpMyAdmin.If you are new to phpMyAdmin this is the perfect companion for getting you off to a flying start. No previous experience with phpMyAdmin is required as you will be guided through downloading and installing it on your system. After installation we will explore the use of top features and the vibrant online community surrounding phpMyAdmin.The amount of things that you can do with phpMyAdmin is overwhelming, so the quick start guide will show you how to create your very first tables. The list of resources will help you to become familiar with the phpMyAdmin community, which is a valuable part of any Open Source project. Finally, you will see how to use five key features of phpMyAdmin ñ including browsing, searching, and changing data, exporting to Excel, and creating relations between tables - that will allow you to perform simple tasks to learn the basics and set off on your own.
Table of Contents (8 chapters)

So, what is phpMyAdmin?

phpMyAdmin is a PHP application that provides a complete interface to manage MySQL databases over the Web. The following image depicts the product's home page; the main sections — MySQL and Web server — indicate that phpMyAdmin relies on a PHP-enabled web server to send commands to a MySQL server and receive data from the server:

As MySQL is the database of choice on the Web and PHP is a popular web scripting language, web host providers often provide phpMyAdmin for their users as the de facto mechanism to administrate their databases.

Typical users

Users of phpMyAdmin can be broken down into these categories:

  • Web developers

  • Database administrators

  • IT students and teachers

The authors of other web applications often advise administrators to use phpMyAdmin, either for initially populating the required database, or as a back entry in case they are locked down from their application.

Available functions

phpMyAdmin offers panels to manage the structure of data: creating, editing, deleting various elements like databases, tables, columns, indexes, views, and foreign keys (relations). The software also enables you to deal with the data itself: inserting, editing, and deleting data; sorting; searching in tables or databases; importing and exporting to various file formats.

A system administrator can also use phpMyAdmin to acquire status information about the MySQL server; this information can be used to fine-tune the server. Moreover, maintenance of MySQL usernames and privileges is available.

Advanced functions include:

  • Generating system documentation, including table relations in graphical form

  • Transforming data (for example to show a thumbnail of an image stored as a BLOB (Binary Large Object); see

  • Tracking changes on structure and data

  • Keeping bookmarks of frequently-used queries

  • Maintaining users' preferences about phpMyAdmin's settings

  • Synchronizing databases between servers

Volunteers all over the world help the development team by providing translations for the interface in many languages.