Search
print PDF
Installation of phpMyAdmin

Recovering software

For all plans
First of all, you must download phpmyadmin () :
http://prdownloads.sourceforge.net/phpmyadmin/phpMyAdmin-2.5.7-pl1.tar.gz
example :


For 720 and xxl
For the 720 and xxl offers, it is possible to work directly through ssh. To do this, enter this command in your shell with ssh:

$ wget http://prdownloads.sourceforge.net/phpmyadmin/phpMyAdmin-2.5.7-pl1.tar.gz
$ tar xzf phpMyAdmin-2.5.7-pl1.tar.gz


example :
$ wget http://prdownloads.sourceforge.net/phpmyadmin/phpMyAdmin-2.5.7-pl1.tar.gz
$ tar xzf phpMyAdmin-2.5.7-pl1.tar.gz


Setting up the FTP
After having downloaded and unzipping the necessary files, upload the directory directly to your FTP in your www directory.

Upload finished and now you can configure the file config.inc.php present in this directory.
Configure the parts below:

In the lines below, you must replace the following information with your personal data: Address_permitting... , server_sql, login_sql, pass_sql

/**
*Your "phpMyAdmin" url
...
*/
$cfg['PmaAbsoluteUri'] = 'Address_permitting_access_to_phpmyadmin';

/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfg['Servers'][$i]['host'] = 'serveur_sql';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'login_sql';
$cfg['Servers'][$i]['password'] = 'pass_sql';
$cfg['Servers'][$i]['only_db'] = 'login_sql';
...


example :

/**
* Your "phpMyAdmin" url
...
*/
$cfg['PmaAbsoluteUri'] = 'http://explication.com/phpMyAdmin-2.5.3/';

/**
* Server(s) configuration
*/
$i = 0;
// The $cfg['Servers'] array starts with $cfg['Servers'][1]. Do not use $cfg['Servers'][0].
// You can disable a server config entry by setting host to ''.
$i++;
$cfg['Servers'][$i]['host'] = 'sql3';
$cfg['Servers'][$i]['port'] = '';
$cfg['Servers'][$i]['socket'] = '';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = FALSE;
$cfg['Servers'][$i]['controluser'] = '';
$cfg['Servers'][$i]['controlpass'] = '';
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'explicatdb';
$cfg['Servers'][$i]['password'] = 'UiD59rtM';
$cfg['Servers'][$i]['only_db'] = 'explicatdb';
...


Conclusion

To conclude, it is highly recommended that you protect your phpmyadmin directory. If your SQL database is not protected, it may be accessible to anybody. To protect your database, follow the HtaccessProtection guide that explains how to protect directory access with authentication.