Creating a MySQL database in phpMyAdmin. MySQL is a database. phpMyAdmin written in PHP, intended to handle the administration of MySQL over the World Wide Web. It can perform various tasks such as creating, modifying or deleting databases, tables, fields or rows, executing SQL statements, Run SQL query/queries. A database holds one or multiple tables. A database is an organized collection of data. To Export data, go to the Export tab in phpMyAdmin.