PHPMYADMIN Setup and config

[Paul Herrmann]

Hi,
I am new to this forum and to PHP. I have set up a local Apache server with MYSQL and PHP and in an attemp to use the mysqldump function came accross PHPMyAdmin. A simple download and placed a folder in htdocs, made a config folder and (successfully) ran setup.php.

Problem 1 - Using setup.php, none of the buttons appears to do anything
Problem 2 - While it did produce a config.inc.php file, this had no content

Tried to then manually setup the config.inc.php file trying numerous different options for auth_type, including password or not, including port or not, adding a line for extension= mysqli etc but every time I try to run it, all I get is

MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

I feel sure that there is some setting that needs to change either in PHP or Apache but all my searching cannot tell me what it is.

I'd appreciate your help

[ronverdonk]

The are actually 2 config files in the root of the phpMyAdmin folder.

1 config.inc.php which is (almost) empty
2. config.sample.inc.php which you must adapt to your setup

The sample config must, after adaptation, be stored as 'config.inc.php' in the 'config' subdirectory. All directives are explained in Documentation.html and on phpMyAdmin wiki at http://wiki.cihar.com


I will include the sample config I have, so you can see what is looks like [php]
<?php

/* $Id: config.sample.inc.php,v 2.1.2.2 2006/08/28 08:14:14 nijel Exp $ */
// vim: expandtab sw=4 ts=4 sts=4:

/**
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use scripts/setup.php
*
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki <http://wiki.cihar.com>.
*/
/*
* This is needed for cookie based authentication to encrypt password in
* cookie
*/
$cfg['blowfish_secret'] = '0a2bc3f68d'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
/*
* Servers configuration
*/
$i = 0;
/*
* First server
*/
$i++;
$cfg['Servers'][$i]['user'] = 'xxx'; // use here your userid
$cfg['Servers'][$i]['password'] = 'yyy'; // use here your password
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';
/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';
/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'xxx'; // use here your controlling userid
$cfg['Servers'][$i]['controlpass'] = 'yyy'; // use here password of previous userid
/* Advanced phpMyAdmin features */
$cfg['Servers'][$i]['pmadb'] = 'phpmyadmin';
$cfg['Servers'][$i]['bookmarktable'] = 'pma_bookmark';
$cfg['Servers'][$i]['relation'] = 'pma_relation';
$cfg['Servers'][$i]['table_info'] = 'pma_table_info';
$cfg['Servers'][$i]['table_coords'] = 'pma_table_coords';
$cfg['Servers'][$i]['pdf_pages'] = 'pma_pdf_pages';
$cfg['Servers'][$i]['column_info'] = 'pma_column_info';
$cfg['Servers'][$i]['history'] = 'pma_history';
/*
* End of servers configuration
*/
/*
* Directories for saving/loading files from server
*/
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
?>[/php]

Ronald :cool:

[Paul Herrmann]

Thanks for your help! With a bit of additional fiddling I managed to get it working.

Cheers

[ronverdonk]

You are welcome! See you again.

Ronald :cool:

[drewan]

Hi Paul,

I am new to phpMyAdmin, and I encounter the exact same problem you did with the setup.php, the page loaded with all the buttons except none of them seems to work even i click on it hundrad times. How could I fix this problem?

Thanks,

Drew