PhpMyAdmin Installation for a domain is so easy.
Enter into your webdirectory (public_html)
Download the source into it.
From shell
wget http://jaist.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-3.1.1-english.tar.gz
or download the source from http://jaist.dl.sourceforge.net/sourceforge/phpmyadmin/phpMyAdmin-3.1.1-english.tar.gz and upload it via FTP to your public_html
extract the contents
tar -zxf phpMyAdmin-3.1.1-english.tar.gz
Alternatively you may use the filemanger extract option for the purpose.
you can now access your phpmyadmin using the link
www.yourdomain.com/phpMyAdmin-3.1.1-english/
Before that you need to configure that.
You need to have
1 database
2 database user
3 database user password.
Now navigate to the directory libraries under /phpMyAdmin-3.1.1-english/ you will have a file named config.default.php.
You need to edit this file
===================
$cfg['Servers'][$i]['host'] = ’1002-2.lowesthosting.com’; // MySQL hostname or IP address
$cfg['Servers'][$i]['port'] = ’4455′; // MySQL port – leave blank for default port
$cfg['Servers'][$i]['socket'] = ‘/tmp/mysqlt.sock’; // Path to the socket – leave blank for default socket
$cfg['Servers'][$i]['connect_type'] = ‘socket’; // How to connect to MySQL server (‘tcp’ or ‘socket’)
$cfg['Servers'][$i]['extension'] = ‘mysql’; // The php MySQL extension to use (‘mysql’ or ‘mysqli’)
$cfg['Servers'][$i]['compress'] = FALSE; // Use compressed protocol for the MySQL connection
// (requires PHP >= 4.3.0)
$cfg['Servers'][$i]['controluser'] = ‘username’; // MySQL control user settings
// (this user must have read-only
$cfg['Servers'][$i]['controlpass'] = ‘password’; // access to the “mysql/user”
// and “mysql/db” tables).
// The controluser is also
// used for all relational
// features (pmadb)
$cfg['Servers'][$i]['auth_type'] = ‘http’; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = ‘username’; // MySQL user
$cfg['Servers'][$i]['password'] = ‘password’; // MySQL password (only needed
// with ‘config’ auth_type)
$cfg['Servers'][$i]['only_db'] = ‘trial’; // If set to a db-name, only
// this db is displayed in left frame
====================
Update the above with database name, username, password, control user and password which can be the same as db user and password.
Now try accessing the link www.yourdomain.com/phpMyAdmin-3.1.1-english/
enter the login credentials.
Thats all.
