PhpMyAdmin

1
PhpMyAdmin

• Matthew Walsh
• April 28, 2003
• CMSC 485-04
• Shawn Sivy

2
What is phpMyAdmin?

• PhpMyAdmin is a Web-based front end for managing
  mySQL databases.
• It has GUI screen for many common functions in
  mySQL.
• Makes mySQL more user friendly.

3
About phpMyAdmin

• Project started in 1998
• Uses GNU General Public License
• Easy to install
• Platform independant
• http//www.phpmyadmin.net

4
What can phpMyAdmin do?

• Create and drop databases and tables.
• Work with multiple MySQL servers.
• Manage users and privileges.
• Export table data.
• Execute any SQL statement.
• 42 different languages.
• And more.

5
Installing phpMyAdmin

• Requirements
• PHP3 gt 3.0.8, or PHP4.
• PHP must be compiled with MySQL support
• MySQL 3.21.x 3.23.x or 4.0.x

6
Installing phpMyAdmin

• Download phpMyAdmin.
• Unzip it somewher in the document root of your
  web server.
• Create a control user in MySQL.
• Edit config.inc.php.
• http//www.phpmyadmin.net/documentation/config

7
The Future

• phpMyAdmin development is ongoing.
• Their next goal is to add support for the new
  features in MySQL4.

8
Questions

• PhpMyAdmin uses what two other open source
  applications?
• What is the config file for phpMyAdmin?

9
the end.