Problems Configuring phpMyAdmin

shacho used Ask the Experts™
I have installed MySQL server and it is runningI can access and operate properly through the command line interface (XP) and MySQL GUI Tools.  I am testing the waters with phpMyAdmin.  I believe I have followed the configuration instructions correctly, but I'm getting a peculiar error.

 Here are the steps I took:
1) Unzipped the phpMyAdmin package to ~apache2.2\htdocs\phpmyadmin
2) created the folder ~phpmyadmin\config
3) copied the file to ~\config and renamed to
4) accessed ~phpmyadmin/scripts/setup.php
5) Clicked Servers->"ADD"
6) Changed the authentication type to "cookie"
7) Entered "root" for  "User for config auth"
8) Entered my password for "Password for config auth"
9) Clicked "ADD"

When I did this, phpMyAdmin displays this message at the top of the page:
"You didn't set phpMyAdmin database, so you can not use all phpMyAdmin features."

What does this mean and how can I solve this problem?

I cleaned up the file a bit.  Here is the file in its entirety:
$cfg['blowfish_secret'] = 'Blah';
$cfg['Servers'][1]['auth_type'] = 'cookie';
$cfg['Servers'][1]['host'] = 'localhost';
$cfg['Servers'][1]['connect_type'] = 'tcp';
$cfg['Servers'][1]['compress'] = false;
$cfg['Servers'][1]['extension'] = 'mysql';
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';


Watch Question

Do more with

Expert Office
EXPERT OFFICE® is a registered trademark of EXPERTS EXCHANGE®


I'm not convinced that phpMyAdmin is actually looking at my config file.  If I click "DISPLAY"  under configuration, it displays a page that looks like the config script default.  Is that what it's supposed to do?

Here is what gets displayed:

 * Generated configuration file
 * Generated by: phpMyAdmin setup script by Michal ihaY <>
 * Version: $Id: setup.php 11423 2008-07-24 17:26:05Z lem9 $
 * Date: Thu, 06 Nov 2008 06:35:04 GMT

/* Servers configuration */
$i = 0;

/* Server localhost (cookie) [1] */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['extension'] = 'mysql';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;
$cfg['Servers'][$i]['auth_type'] = 'cookie';

/* End of servers configuration */

$cfg['blowfish_secret'] = '49128f89d06085.02874880';

I'm not entirly sure, but I never placed the file in a seperate folder. I think it should be in ~apache2.2\htdocs\phpmyadmin


If I try to put it anywhere else, phpMyAdmin/scripts/setup.php says:

Can not load or save configuration.
Please create web server writable folder config in phpMyAdmin toplevel directory as described in documentation. Otherwise you will be only able to download or display it.


Starting with Angular 5

Learn the essential features and functions of the popular JavaScript framework for building mobile, desktop and web applications.

"phpMyAdmin toplevel directory", so that means that it indeed cannot be in a subdirectory.
Is the phpMyAdmin directory writable like the message says?


I see what's happened here. needs to be in the /phpmyadmin/config directory while it's being edited by /phpmyadmin/scripts/setup.php.  The error I am getting is from setup.php.  The problem doesn't seem to be with phpMyAdmin.  I think there's a problem with the PHP configuration.  Here is the error phpMyAdmin gives me on top:

Could not load either mysql or mysqli extension, you might not be able to use phpMyAdmin! Check your PHP configuration.

This suggests to me that I have a configuration problem with PHP or Apache.  Do you have an idea what might be the cause?


Use phpinfo() to see if mysql is enabled, I think there should be something like:
in the configure command. And there should also be a mysql section further below in the phpinfo().
Another thing, you are on Windows right? Check your php.ini file for:
This line should not have a semicolon (;) before it.

Do more with

Expert Office
Submit tech questions to Ask the Experts™ at any time to receive solutions, advice, and new ideas from leading industry professionals.

Start 7-Day Free Trial