PRESOON.COM

PhpMyAdmin Installation

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.

No Comments yet »

RSS feed for comments on this post. TrackBack URI

Leave a comment