Creating a MySQL Database Using phpMyAdmin

phpMyAdmin is a component that comes bundled with Zend Server in order to handle the administration of your MySQL databases. For more information see Working with phpMyAdmin to Manage MySQL in the Zend Server online documentation. Creating a database in MySQL is necessary in order to debug your PHP/Flex application. The PHP code in your project will use the database to access the information when needed, as defined by the code.

Before creating a MySQL database, you must have a sql file available on your machine.

Instructions on how to complete a procedure

To create a MySQL database using phpMyadmin:

Open your Zend Server UI by entering “http://localhost:10081” into a browser, and enter your username and password.
If this is your first time opening Zend Server see Getting Started with Zend Server.
Go to Monitor | Dashboard and in the Tasks area click Open phpMyAdmin.

phpMyAdmin opens in a new browser.
Enter the username “root” and leave the password empty (as defined when setting up your phpMyAdmin during Zend Server installation) and click Go.

Go to the Import tab, browse to the sql file and click Go.

The database has been created, and is already located on your machine.

To see the tables located in your database, select the database from the left menu of the phpMyAdmin UI and go to the Structure tab.