3.9. Installing phpMyAdmin

In this book, we use the popular MySQL administration program, phpMyAdmin, when we show how to perform the tasks required for MySQL database administration. phpMyAdmin is a free, open source Web application written in PHP, and it provides a complete Web interface for managing MySQL databases.

You can download and install phpMyAdmin on your local machine to access MySQL databases on your machine or on other machines over a network. Many Web hosting companies provide phpMyAdmin for you to use when accessing your databases on their computers.

You must install MySQL and PHP before you can install phpMyAdmin. If you installed XAMPP, you probably installed phpMyAdmin during the installation procedure. If not, you can uninstall XAMPP and reinstall it with phpMyAdmin included. Instructions for installing XAMPP are provided in Chapter 5 in this minibook.

The following sections provide instructions for downloading, installing, and testing phpMyAdmin by itself, after you've installed your Web server, MySQL, and PHP.

3.9.1. Obtaining phpMyAdmin

You can obtain phpMyAdmin by downloading it from the phpMyAdmin Web site. Follow these steps:

  1. Locate the box in the upper-left corner with the heading Quick Downloads.

  2. Click the Zip link under the entry Latest Stable Version.

    The phpmyadmin-version-all-languages-utf-8-only.zip file downloads. (For example, the filename for version 2.10.3 would be phpmyadmin-2.10.3-all-languages-utf-8-only.zip.)

Get PHP & MySQL® Web Development All-in-One Desk Reference for Dummies® now with the O’Reilly learning platform.

O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.