phpMyAdmin setup problem

Posted on 2008-11-17
Last Modified: 2013-12-13
I am trying to get into dynamic web development using databases and have got a basic grip of php and XHTML.  I am following a book to guide me through obtaining and installing phpMyAdmin alongside MySQL but everytime I try to launch by putting http://localhost/phpMyAdmin/ into the browser the fatal error message comes up:  Call to a member function getName() on a non-object in C:\Users\Main User\Documents\My Websites\phpMyAdmin\libraries\ on line 688
I have been using a local testing environment with php successfully for several weeks now so am assuming Apache is set up correctly.
I have also added the file as shown in my guide that contains the following code:
$i = 1;
$cfg['Servers'][$i]['extension'] = 'mysqli';
$cfg['Servers'][$i]['auth_type'] = 'http';
and have been over the setup for MySQL several times at a loss now!!!
Can anyone suggest how I can fix this and get the graphical interface to MySQL up and running?
Thank you
Question by:Jimi_Jersey
    LVL 2

    Expert Comment

    Please check if mysqli php module is installed, eg. phpinfo(); Try changing mysqli into mysql
    LVL 6

    Expert Comment

    Honestly, I would download phpMyAdmin again and reinstall. With it being so easy to install I would do that first. Use it's in-browser wizard to set it up and configure the database.
    LVL 14

    Accepted Solution

    take a look at /libraries/config.default.php, copy and rename it /
    then run /scripts/create_tables_mysql_4_1_2+.sql
    and change the following lines :
    $cfg['blowfish_secret'] = 'your secret phrase';
    $cfg['Servers'] = array();
    $i = 1;
    $cfg['Servers'][$i]['host'] = 'localhost';
    $cfg['Servers'][$i]['connect_type'] = 'tcp';
    $cfg['Servers'][$i]['extension'] = 'mysqli';
    $cfg['Servers'][$i]['auth_type'] = 'cookie';
    $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';

    Open in new window


    Author Comment

    I have taken a look at /libraries/config.default.php, and copied and renamed it in the same folder as the index.php.  The next step you have suggested I don't understand...(really am completely new to this!!!)
    How do I run scripts/create_tables_mysql_4_1_2+.sql ?
    I have searched for scripts (folder/file) everywhere.
    I am running php version 5.2.6; MySQL 5.0; Apache 2.2.  The phpMyAdmin is version and i am using windows vista....if any of this helps at all
    Hope ur solution works as I'm gong crazy..!
    Thanks for your help!


    Featured Post

    Threat Intelligence Starter Resources

    Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

    Join & Write a Comment

    Part of the Global Positioning System A geocode ( is the major subset of a GPS coordinate (, the other parts being the altitude and t…
    Load balancing is the method of dividing the total amount of work performed by one computer between two or more computers. Its aim is to get more work done in the same amount of time, ensuring that all the users get served faster.
    Learn how to match and substitute tagged data using PHP regular expressions. Demonstrated on Windows 7, but also applies to other operating systems. Demonstrated technique applies to PHP (all versions) and Firefox, but very similar techniques will w…
    The viewer will learn how to look for a specific file type in a local or remote server directory using PHP.

    734 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

    19 Experts available now in Live!

    Get 1:1 Help Now