How to Install phpMyAdmin on Everleap

Overview

phpMyAdmin is a web based tool for managing MySQL databases. Everleap does not install it for you, but you can upload it to your own site and point it at your Everleap MySQL database. This article covers downloading it, editing its configuration for our environment, uploading it and enabling PHP.

Step 1: Download phpMyAdmin

Download the .zip file from the phpMyAdmin site.

Step 2: Extract the files

Extract the contents of the .zip file on your local computer.

Step 3: Find your MySQL server name

You need to know which MySQL server your database is on before you can edit the configuration file.

1. Log in to the Everleap Control Panel at cp.everleap.com.
2. From the top menu click Databases, then Shared MySQL (or Private MySQL if you have a private server).
3. Click Manage next to your database.
4. Read Database Server in the General Information panel. It is in the form my##.everleap.com, where ## is your server number.

Step 4: Edit the configuration file

Open the file called config.sample.inc.php and change this line from:

$cfg['Servers'][$i]['host'] = 'localhost';

to:

$cfg['Servers'][$i]['host'] = 'my##.everleap.com';

using the server name you found in step 3.

In the same file, add this line:

$cfg['TempDir'] = '../../tmp';

right after this one:

$cfg['SaveDir'] = '';

This prevents an error about writing to a cache file. If you make the temp folder /site/wwwroot/tmp it will not save the file, because the file path name is too long.

Save the file and rename it to config.inc.php.

Step 5: Create a .user.ini file

Create a .user.ini file with at least the following setting:

session.save_handler = files

Place it in your root directory, that is /site/wwwroot.

Step 6: Upload the files

Upload the files to the Everleap server using an FTP client such as FileZilla (see How to Configure FTP for FileZilla). Place them either in the root directory, for example /site/wwwroot/phpMyAdmin, or in a sub directory, for example /site/wwwroot/sub/phpMyAdmin.

If you place it in a sub directory, modify the temp directory setting from step 4 by adding an extra parent path:

$cfg['TempDir'] = '../../../tmp';

Step 7: Enable PHP on the site

1. In the Control Panel, click Shared Sites in the top menu.
2. On the Shared Cloud Sites Overview page, click Manage next to the applicable site.
3. On the Site Overview page, click the SETTINGS tab.
4. Click the General tab.
5. Select the latest version in the PHP dropdown.
6. Click Update General Settings.

Step 8: Launch phpMyAdmin

Enter your primary domain name, or the secondary URL we provide you, in a browser. For example:

http://www.mydomainname.com
http://1234-12345.el-alt.com

If you uploaded phpMyAdmin to a sub directory, append the sub directory name to the URL:

http://www.mydomainname.com/sub-directory_name
http://1234-12345.el-alt.com/sub-directory_name

Verify it worked

The phpMyAdmin login page appears. Enter your database login credentials, which are the Database User and password from the MySQL Database Overview page, and you are in.

Notes

• If you have forgotten your database password, you can set a new one from the Edit link next to Database Password on the MySQL Database Overview page.
• phpMyAdmin is third party software. Everleap hosts it for you but does not support the application itself.

Related Articles

• How to Backup or Restore a MySQL database using MySQL Workbench
• How to Configure FTP for FileZilla
• How to enable PHP
• Getting Started with Private MySQL Server