469,267 Members | 1,091 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,267 developers. It's quick & easy.

PHPMYADMIN Setup and config

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
Mar 13 '07 #1
4 15870
ronverdonk
4,258 Expert 4TB
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:
Mar 13 '07 #2
Thanks for your help! With a bit of additional fiddling I managed to get it working.

Cheers
Mar 13 '07 #3
ronverdonk
4,258 Expert 4TB
You are welcome! See you again.

Ronald :cool:
Mar 13 '07 #4
drewan
1
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
Apr 17 '07 #5

Post your reply

Sign in to post your reply or Sign up for a free account.

Similar topics

4 posts views Thread by Adams-Blake Co. | last post: by
7 posts views Thread by 'bonehead | last post: by
reply views Thread by TERMAN, IRA, ALABS | last post: by
1 post views Thread by Wilson Ricardo Passos Oliveira | last post: by
22 posts views Thread by James Stroud | last post: by
reply views Thread by andrew.douglas11 | last post: by
reply views Thread by zhoujie | last post: by
reply views Thread by suresh191 | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.