phpMyAdmin is an excellent administration software tool to handle the administration of MYSQL over the World Wide Web. This open source software supports a wide range of operations that includes tasks such as creating databases, tables, fields, etc. The award winning open source admin software supports 65 languages.
Features
- Intuitive web interface
- Support for most MySQL features:
- browse and drop databases, tables, views, fields and indexes
- create, copy, drop,rename & alter databases, tables, & indexes
- maintenance server, databases and tables, with proposals on server configuration
- execute, edit and bookmark any SQL-statement, even batch-queries
- manage MySQL users and privileges
- manage stored procedures and triggers
- Import data from CSV and SQL
- Export data to various formats: CSV, SQL, XML, PDF, ISO/IEC 26300 - OpenDocument Text and Spreadsheet, Word, LATEX and others
- Administering multiple servers
- Creating PDF graphics of your database layout
- Creating complex queries using Query-by-example (QBE)
- Searching globally in a database or a subset of it
- Transforming stored data into any format using a set of predefined functions, like displaying BLOB-data as image or download-link
- And much more...
phpMyAdmin is a open source software and it is available for free download. It requires at least PHP 5.2 and MySQL 5.