Problems Configuring phpMyAdmin

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'] = '';


Who is Participating?

[Product update] Infrastructure Analysis Tool is now available with Business Accounts.Learn More

I wear a lot of hats...

"The solutions and answers provided on Experts Exchange have been extremely helpful to me over the last few years. I wear a lot of hats - Developer, Database Administrator, Help Desk, etc., so I know a lot of things but not a lot about one thing. Experts Exchange gives me answers from people who do know a lot about one thing, in a easy to use platform." -Todd S.

shachoAuthor Commented:
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
shachoAuthor Commented:
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.


10 Tips to Protect Your Business from Ransomware

Did you know that ransomware is the most widespread, destructive malware in the world today? It accounts for 39% of all security breaches, with ransomware gangsters projected to make $11.5B in profits from online extortion by 2019.

"phpMyAdmin toplevel directory", so that means that it indeed cannot be in a subdirectory.
Is the phpMyAdmin directory writable like the message says?
shachoAuthor Commented:
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.

Experts Exchange Solution brought to you by

Your issues matter to us.

Facing a tech roadblock? Get the help and guidance you need from experienced professionals who care. Ask your question anytime, anywhere, with no hassle.

Start your 7-day free trial
It's more than this solution.Get answers and train to solve all your tech problems - anytime, anywhere.Try it for free Edge Out The Competitionfor your dream job with proven skills and certifications.Get started today Stand Outas the employee with proven skills.Start learning today for free Move Your Career Forwardwith certification training in the latest technologies.Start your trial today

From novice to tech pro — start learning today.