Problem with phpMyAdmin install

Questions about the MySQL, PostgreSQL, and most other databases, as well as using it with PHP can be asked here.

Moderator: General Moderators

Post Reply
HogHunter
Forum Newbie
Posts: 1
Joined: Wed Feb 27, 2008 12:28 pm

Problem with phpMyAdmin install

Post by HogHunter »

On a Windows XP SP2 PC, I am running MySQL 5.0, PHP 5.2.5, Apache 2.2.6.

MySQL is working, PHP is working, Apache is working.

However, when I tried to install phpMyAdmin 2.11.3, it keeps saying it can't log in and that it is probably because I haven't setup my configuration file. I have a file named config.inc.php in my \USR\Apache2.2\htdocs\phpMyAdmin\config folder.

Every time I load phpMyAdmin, I get the following error:
#1045 - Access denied for user 'root'@'localhost' (using password: NO)
I have tried using ['auth_type'] = 'http' and ['auth_type'] = 'config'. No difference. I have restarted both Apache and MySQL. Is there way to tell whether the config file is being read?

Also, when I try to use the tests that come with phpMyAdmin under the test folder, I get the following errors:
Warning: require_once(PHPUnit/Framework.php) [function.require-once]: failed to open stream: No such file or directory in E:\USR\Apache2.2\htdocs\phpMyAdmin\test\PMA_transformation_getOptions_test.php on line 13

Fatal error: require_once() [function.require]: Failed opening required 'PHPUnit/Framework.php' (include_path='.;C:\php5\pear') in E:\USR\Apache2.2\htdocs\phpMyAdmin\test\PMA_transformation_getOptions_test.php on line 13
Any guidance would be welcome,
Thom
User avatar
Benjamin
Site Administrator
Posts: 6935
Joined: Sun May 19, 2002 10:24 pm

Re: Problem with phpMyAdmin install

Post by Benjamin »

If you haven't got it sorted yet, here is a config.inc.php file that works.

Code: Select all

 
<?php
/* vim: set 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>.
 *
 * @version $Id: config.sample.inc.php 10142 2007-03-20 10:32:13Z cybot_tm $
 */
 
/*
 * This is needed for cookie based authentication to encrypt password in
 * cookie
 */
$cfg['blowfish_secret'] = ''; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */
 
/*
 * Servers configuration
 */
$i = 0;
 
/*
 * First server
 */
$i++;
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'config';
$cfg['Servers'][$i]['user'] = 'root';
$cfg['Servers'][$i]['password'] = '';
/* 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'; // add an i here if you have mysqli
/* User for advanced features */
// $cfg['Servers'][$i]['controluser'] = 'pma';
// $cfg['Servers'][$i]['controlpass'] = 'pmapass';
/* 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';
// $cfg['Servers'][$i]['designer_coords'] = 'pma_designer_coords';
 
/*
 * End of servers configuration
 */
 
/*
 * Directories for saving/loading files from server
 */
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';
 
?>
 
 
Post Reply