Install & Test phpMyAdmin

i m a newbie

[esha_salz]

I need help with the installation & testing of phpmyadmin.. i think i installed it but how do i connect it to my mysql? All the programmin is done in command propmt and i haf no idea wat to do.. I m usin a local host.. And the manuals arent alot of help.

[Timotheos]

Hi there,

Here's the Quick Install instructions [phpmyadmin.net]

1. Untar or unzip the distribution (be sure to unzip the subdirectories): tar -xzvf phpMyAdmin_x.x.x.tar.gz in your webserver's document root. If you don't have direct access to your document root, put the files in a directory on your local machine, and, after step 3, transfer the directory on your web server using, for example, ftp.

2. Open the file config.inc.php in your favorite editor and change the values for host, user, password and authentication mode to fit your environment. Here, "host" means the MySQL server. Also insert the correct value for $cfg['PmaAbsoluteUri']. Have a look at Configuration section for an explanation of all values.

Here's what mine look like for local development:
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed
// with 'config' auth_type)

$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';

3. It is recommended that you protect the directory in which you installed phpMyAdmin (unless it's on a closed intranet, or you wish to use HTTP or cookie authentication), for example with HTTP-AUTH (in a .htaccess file). See the multi-user sub-section of the FAQ for additional information, especially FAQ 4.4.

4. Open the file <www.your-host.com>/<your-install-dir>/index.php in your browser. phpMyAdmin should now display a welcome screen and your databases, or a login dialog if using HTTP or cookie authentication mode.

Let's us know where you are stuck.

Tim

[esha_salz]

Maybe i should start from the beginning
1) I downloaded 'phpMyAdmin-2.5.7-pl1'

2) Unzipped it and i went to configure the "config.inc.php" file (It opened in macromedia dreamweaver, so i just edited it there)

3) I keyed in the same commands u told me to
$cfg['Servers'][$i]['host'] = 'localhost'; // MySQL hostname
$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?
$cfg['Servers'][$i]['user'] = 'root'; // MySQL user
$cfg['Servers'][$i]['password'] = ''; // MySQL password (only needed // with 'config' auth_type)

$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';

4) But i cant open the website, " [localhost...]

I am using my school wireless network.. So what exactly is my localhost? In the manual there is one called yrex.com.
So could u pls help me out..

[Timotheos]

Ok. So you're doing this on a remote web server not on your local machine?

Change this line
$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';
to
$cfg['PmaAbsoluteUri'] = 'http://www.yoursite.com/phpmyadmin/';

Now you should be able to get to it at...

http://www.yoursite.com/phpmyadmin/

assuming you have it in that directory.

BTW, it's fairly easy to download the complete php/mysql package (with phpmyadmin) from [firepages.com.au...] so that you can do development work on a local machine and then upload to your server.

Tim

[esha_salz]

Erm.. Remote web server? N wat site do i use for the "http://www.yoursite.com/phpmyadmin"..
I mean the yoursite? I dun haf a site...