phpMyAdmin
phpMyAdmin is an open source tool written in PHP intended to
handle the administration of MySQL over the World Wide Web.
This tool can perform various tasks such as creating,
modifying or deleting databases, tables, fields or rows; executing SQL
statements; or managing users and permissions.
phpMyAdmin can manage a whole MySQL server as well as a single
database. To achieve the latter you need a properly set up MySQL
user who can read/write only the desired database.
Features include:
- Intuitive web interface
- Browse through databases and tables
- Create, copy, rename, alter and drop databases
- Create, copy, rename, alter and drop tables
- Perform table maintenance
- Add, edit and drop fields
- Execute any SQL-statement, even multiple queries
- Create, alter and drop indexes
- Load text files into tables
- Create and read dumps of tables or databases
- Export data to SQL, CSV, XML, Word, Excel, PDF, ISO/IEC
26300 (OpenDocument Text and Spreadsheet), LaTeX
formats and others
- Administer multiple servers
- Manage MySQL users and privileges
- Check server settings and runtime information with
configuration hints
- Check referential integrity in MyISAM tables
- Create complex queries using Query-by-example (QBE),
automatically connecting required tables
- Create PDF graphics of the database layout
- Search globally in a database or a subset of it
- Transform stored data into any format using a set of
predefined functions, such as displaying BLOB-data as image or
download-link
- Active query monitor
- Manage InnoDB tables and foreign keys
- Fully internationalized and localized in dozens of languages
Return
to MySQL Tools Home Page
Last Updated Thursday, April 05 2012 @ 08:22 PM EDT
| 
