Problems Configuring phpMyAdmin

Posted on 2008-11-05
Last Modified: 2013-12-13
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'] = '';


Question by:shacho

    Author Comment

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

    LVL 6

    Expert Comment

    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

    Author Comment

    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.


    LVL 6

    Expert Comment

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

    Author Comment

    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?


    LVL 6

    Expert Comment

    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().
    LVL 6

    Accepted Solution

    Another thing, you are on Windows right? Check your php.ini file for:
    This line should not have a semicolon (;) before it.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    How to improve team productivity

    Quip adds documents, spreadsheets, and tasklists to your Slack experience
    - Elevate ideas to Quip docs
    - Share Quip docs in Slack
    - Get notified of changes to your docs
    - Available on iOS/Android/Desktop/Web
    - Online/Offline

    This article will explain how to display the first page of your Microsoft Word documents (e.g. .doc, .docx, etc...) as images in a web page programatically. I have scoured the web on a way to do this unsuccessfully. The goal is to produce something …
    Part of the Global Positioning System A geocode ( is the major subset of a GPS coordinate (, the other parts being the altitude and t…
    The viewer will learn how to dynamically set the form action using jQuery.
    The viewer will learn how to count occurrences of each item in an array.

    759 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now