Installing and Configuring phpMyAdmin
This topic explains how to install and configure phpMyAdmin on Zend Server.
phpMyAdmin is a free software tool written in PHP, intended to handle the administration of MySQL over the Web. This tool is not supported by Zend.
Deploying phpMyAdmin
This procedure describes how to download and deploy the phpMyAdmin application package on Zend Server.
Currently, deployment of phpMyAdmin on Zend Server can only be performed on Apache and nginx servers.
|
To install phpMyAdmin:
- In the Zend Server UI, go to the Getting Started page.
- In the Deploy Sample Apps section, click the phpMyAdmin icon.
The Deploy Application wizard is displayed, and Zend Server begins downloading the application package.
- After the application package is successfully downloaded, click Next.
The Readme dialog is displayed.
- Click Next.
The Application Details dialog displays.
- Enter the following information:
- Display Name - The name that Zend Server
will display for this application.
- Virtual Host - This field automatically displays the default server that is defined on the Administration | Settings page. If you have not yet defined a default server, the default virtual host
on your server will be used. You can add a new virtual host by clicking
Add New.
- Path - The second part of your
base URL, which can only be a directory. As you type, Zend Server offers path suggestions, and updates the URL below.
Specifying a
file will cause the application to deploy with errors.
Leaving this field empty will deploy the application on
the virtual host's root.
The base URL (or root URL) is the URL where
the application is available after it has been deployed. The base
URL is unique and cannot be shared between two applications, and
each application is required to have a base URL. Using a pseudo
URL is also acceptable.
- When finished, click Next.
The License Agreement dialog displays.
- Read and accept the end user license agreement, and click Next.
The Prerequisites Validation dialog is displayed.
- If the parameters
have been validated, skip to step 9.
If your system does not qualify, an error message is displayed at the top of the dialog and the prerequisite in question appears in red:- Click the adjacent link to open Zend Server in another tab in your browser.
- Go to the PHP | Extensions page.
- Locate and select the extensions that need to be enabled, and in the Action bar, click .
- Return to the Deploy Application wizard, and click .
- Click Next.
The User Parameters dialog displays.
- Configure HTTP basic authentication on Apache for securing access to phpMyAdmin (or skip to step 11):
- Select the Use HTTP (Apache) Basic Authentication check-box.
- In the HTTP (Apache) Authentication Login field, enter a login username (default: DBadmin).
- In the HTTP (Apache) Authentication Password field, enter a password.
HTTP basic authentication for Apache servers should not be used in conjunction with phpMyadmin's built-in HTTP Authentication.
- Enter your MySQL database IP, port and access credentials, and click Next.
The Deployment Summary dialog opens.
- Click to deploy your application.
Your application is deployed and added to the Applications list on the Applications | Manage Apps page.
- To access phpMyAdmin, select the newly deployed application from the Applications list, and click the App URL in the expanded view.
If you selected to add HTTP basic authentication in step 10 above, you will be required to enter your credentials to access phpMyAdmin.
|
|
Configuring phpMyAdmin
Once deployed, phpMyAdmin should be configured to best suit your system requirements and personal preferences.
From the User Interface
Use the supplied setup script:
- In phpMyAdmin, select the Settings tab, and under More settings, click Setup script.
-OR-
- In your browser, go to:
http://<server>/phpmyadmin/setup/index.php
From the File System
Access the application's 'config.inc.php' file, at:
- Windows - <Zend Server installation directory>\data\apps\http\<deployed application path>\config.inc.php
- Linux - /usr/local/zend/var/apps/http/<deployed application path>/config.inc.php