All right, so you want to install phpMyAdmin.
First, go to http://www.phpMyAdmin.net and download phpMyAdmin.
(Note: The following instructions were written for phpMyAdmin version 2.7.0-
pl2. If you are installing a different version, there may be some slight
changes.)
TIP: Before beginning this installation, make sure you have the following
information on hand: name of the MySQL 'host' server, your username for MySQL
access, and your MySQL password. You can find the information for the host name
and username by visiting the MySQL Account Manager in your CNC
(Command'N'Control) panel. If you have forgotten your MySQL password, you will
also be able to reset it through your MySQL Account Manager. Note that doing so
will change the MySQL password for all of your MySQL databases.
Next, unzip/untar all the files and directories.
If there is not one, you will need to create a file named config.inc.php. That file will need to contain the following lines:
<?php
$i=1;
$cfg['PmaAbsoluteUri'] = 'http://example.com/pma/';
$cfg['Servers'][$i]['host'] = 'MySQL.example.com';
$cfg['Servers'][$i]['auth_type'] = '';
$cfg['Servers'][$i]['user'] = '';
$cfg['Servers'][$i]['password'] = '';
$cfg['blowfish_secret'] = '';
?>
Your settings need to be entered in between the ' ' marks after the equal signs. A description of the settings follows:
$cfg['PmaAbsoluteUri'] = 'http://example.com/pma/'; -- replace
example.com with your domain and pma with the location where you
will install phpMyAdmin on your account
$cfg['Servers'][$i]['host'] = 'MySQL.example.com'; -- replace example.com with your domain
$cfg['Servers'][$i]['auth_type'] = ''; -- dictates the authentication
method used when connecting to your phpMyAdmin installation.
The three options for authentication are:
- config (the default method)
- http
- cookie (recommended method)
config method - This method is the least secure, as it requires storing
your MySQL username and password in the file on the server. Anyone who would
find the directory to your phpMyadmin installation would then be able to access
your databases. This is the default method, however. *See important note.
http or cookie authentication methods - These methods are more secure, as
your username and password are not stored on the server in your configuration
file.
The 'http' option uses the Apache http authentication method. The 'cookie'
method uses cookies, and has the advantage that you can "Log Out" at the end of
your session, deleting the cookie. The development team for phpMyAdmin notes,
however, that for certain browsers, these two authentication methods may be a
bit buggy.
$cfg['Servers'][$i]['user'] = ''; -- MySQL username if you are using config method - otherwise leave blank
$cfg['Servers'][$i]['password'] = ''; -- MySQL password only if you are using config method - otherwise leave blank
$cfg['blowfish_secret'] = ''; -- used with the cookie method only. If you
specified cookie in the auth_type above, type in a random passphrase for this
setting. The passphrase is just used internally to encrypt the password - you
will not be prompted for it later.
Make sure you don't have any blank lines at the end of the file, and save it as config.inc.php.
Now, create a new directory in your "www" directory titled something like
"pma" (same as the directory named above by $cfg['PmaAbsoluteUri']).
Then, upload ALL of the phpMyAdmin files to this directory, including the
config.inc.php file.
Finally, open a web browser, and go to http://www.example.com/pma/index.php (replace
example.com with your domain name and pma with whatever directory phpMyAdmin is
in) and you should see the welcome page and be able to start configuring your
databases!
Important Note: If you use the
'config' authentication method, it is strongly recommended that you secure the
directory in which phpMyAdmin is installed. For information on how to password
protect directories, visit the
Password Protection Tutorial.
This extra step is not needed when using either the 'http' or 'cookie' authentication methods.
Back to Top
|
