Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 615
  • Last Modified:

phpMyAdmin setup problem

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\common.inc.php 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 config.inc.php 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 now...am at a loss now!!!
Can anyone suggest how I can fix this and get the graphical interface to MySQL up and running?
Thank you
1 Solution
Please check if mysqli php module is installed, eg. phpinfo(); Try changing mysqli into mysql
James LooneySr. Programmer/AnalystCommented:
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.
take a look at /libraries/config.default.php, copy and rename it /config.inc.php
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

Jimi_JerseyAuthor Commented:
I have taken a look at /libraries/config.default.php, and copied and renamed it config.inc.php 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

What does it mean to be "Always On"?

Is your cloud always on? With an Always On cloud you won't have to worry about downtime for maintenance or software application code updates, ensuring that your bottom line isn't affected.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now