How to manually setup phpMyAdmin?

The following will show you how to obtain and configure phpMyAdmin for the
administration of your MySQL Database on 1&1 server. We recommend that you
obtain an SSH client called PuTTY

First get the following information from your 1&1 Control Panel by following the
FAQ: Where can I find the necessary information to connect to MySQL Database?
Database Name
User Name
Host Name
Password

1. Use PuTTY to login to your SSH account.

2. Once in type in the following:
wget http://aleron.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-2.5.3-php.tar.gz
Note: There are latest versions of phpMyAdmin available. Please check website
http://www.phpmyadmin.net/home_page/
This will start downloading phpMyAdmin into your home directory. Depending on
network speed, this should not take long.

3. Once the download is complete decompress phpMyAdmin-2.5.3-php.tar.gz file. To do
this type the following command:
tar xvfz phpMyAdmin-2.5.3-php.tar.gz

4. You have to configure phpMyAdmin to recognize 1&1 server settings. To do so,
change to the phpMyAdmin-2.5.3 directory and edit the config.inc.php file with

myShell:~> cd phpMyAdmin-2.5.3
myShell:~> vi config.inc.php

After the file is open click on insert key on the keyboard.

5.

Only the following changes must be made:

$cfg['PmaAbsoluteUri'] = 'http://justonedomain.com/phpMyAdmin/';
Change this setting to reflect the full pathname and the directory where phpMyAdmin 
is located.  For example: 1and1.com/phpMyAdmin/

$cfg['Servers'][$i]['host'] = 'dbxx.perfora.net';
Place the host name here

$cfg['Servers'][$i]['auth_type'] = 'config';
Make certain this option is set to config.  It may be there by default.

$cfg['Servers'][$i]['user'] = 'dboxxxxxxxx';
Your mySQL user name

$cfg['Servers'][$i]['password'] = 'xxxxxxxx';
Your mySQL password

$cfg['Servers'][$i]['only_db'] = 'dbxxxxxxxx';
Your database name

To save the changes, click the Esc key on the keyboard. Type :x. Now exit out of
the directory by typing in the command:
myShell:~> cd ..

6. Change the name of phpMyAdmin-2.5.3 to phpMyAdmin by typing the command
myShell:~> mv phpMyAdmin-2.5.3/ phpMyAdmin

7. Protect the directory(phpMyAdmin) in Control Panel under
Web Space & Access -> Protected Directories. Select phpMyAdmin directory, create
a user name and password.

8. Now to view the contents of your database go to
www.yourdomain.com/phpMyAdmin

Note: Not all packages have SSH Access. If you don't have SSH access, then
you can set it up using FTP.

1. Download the file from http://www.phpmyadmin.net/home_page/

2. You can untar the file using WinRAR.

3. Then edit the file config.inc.php using any text editor (notepad is fine).

Only the following changes must be made:

$cfg['PmaAbsoluteUri'] = 'http://justonedomain.com/phpMyAdmin/';
Change this setting to reflect the full pathname and the directory where phpMyAdmin 
is located.  For example: 1and1.com/phpMyAdmin/

$cfg['Servers'][$i]['host'] = 'dbxx.perfora.net';
Place the host name here

$cfg['Servers'][$i]['auth_type'] = 'config';
Make certain this option is set to config.  It may be there by default.

$cfg['Servers'][$i]['user'] = 'dboxxxxxxxx';
Your mySQL user name

$cfg['Servers'][$i]['password'] = 'xxxxxxxx';
Your mySQL password

$cfg['Servers'][$i]['only_db'] = 'dbxxxxxxxx';
Your database name

Save the changes.

6. Change the name of phpMyAdmin-2.5.3 folder to phpMyAdmin.

7. Upload this folder into the directory your domain is pointing to.

8. Protect the directory(phpMyAdmin) in the Control Panel under
Web Space & Access -> Protected Directories. Select phpMyAdmin directory, create
a user name and password.

9. Now to view the contents of your database go to
www.yourdomain.com/phpMyAdmin

Print Article

Feedback

Overview	Search
Sitemap	Glossary