View Full Version : PHP and phpMyAdmin help needed

11-13-2007, 11:09 AM
Please help with phpmyadmin

I have been desperately trying to install PHPmyadmin for the last week but have failed miserably every time! I just want to install it on my local computer so that I can create databases etc etc locally.

I have installed PHP successfully (which I have checked in my browser using a test page with the following php code: <?php phpinfo(); ?> )

I have installed mysql successfully and have set a password. This seems to be working fine as well.

I am working on Windows Vista 32-bit operating system, with IIS7 installed and have installed mysql 5, php 5.2.5 and am trying to install phpMyAdmin2.11.2.1.

I have found some useful tutorials but then all of a sudden they don’t tell you exactly how to do something or refer to versions before 2.8 which had the config.inc.php file in the downloaded package. I even bought the book “Mastering phpMyAdmin 2.8” so that I could learn PHPmyadmin – the installation instructions in this book are not clear at all!

Please please could someone help me:

1. I have downloaded the .zip file and extracted all info to C:\inetpub\wwwroot\phpmyadmin.

2. I have enabled these extensions in the php.ini file:

3. I then made a copy of config.sample.inc to config.inc.php

4. I added these settings - my code now looks like this:

/* vim: set expandtab sw=4 ts=4 sts=4: */
* phpMyAdmin sample configuration, you can use it as base for
* manual configuration. For easier setup you can use scripts/setup.php
* All directives are explained in Documentation.html and on phpMyAdmin
* wiki <http://wiki.cihar.com>.
* @version $Id: config.sample.inc.php 10142 2007-03-20 10:32:13Z cybot_tm $

* This is needed for cookie based authentication to encrypt password in
* cookie
$cfg['blowfish_secret'] = 'SanDeRs55687'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

* Servers configuration
$i = 0;

* First server
/* Authentication type */
$cfg['Servers'][$i]['auth_type'] = 'cookie';

/* Server parameters */
$cfg['Servers'][$i]['host'] = 'localhost';
$cfg['Servers'][$i]['connect_type'] = 'tcp';
$cfg['Servers'][$i]['compress'] = false;

/* Select mysqli if your server has it */
$cfg['Servers'][$i]['extension'] = 'mysql';

/* User for advanced features */
$cfg['Servers'][$i]['controluser'] = 'pma';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';

/* Advanced phpMyAdmin features */
$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';

* End of servers configuration

* Directories for saving/loading files from server
$cfg['UploadDir'] = '';
$cfg['SaveDir'] = '';

$cfg['docSQLDir'] = 'docsql';
$cfg['ShowPhpInfo'] = true;
$cfg['ShowChgPassword'] = true;
$cfg['AllowArbitraryServer'] = false;
$cfg['LoginCookieRecall'] = 'something';
$cfg['LoginCookieValidity'] = 1800;
$cfg['AllowAnywhereRecoding'] = true;
$cfg['DefaultCharset'] = 'iso-8859-1';
$cfg['RecodingEngine'] = 'iconv';
$cfg['IconvExtraParams'] = '//TRANSLIT';
$cfg['GD2Available'] = 'yes';


5. I then went to my browser and typed in http://localhost/phpmyadmin/index.php
6. It comes up with this error message:

phpMyAdmin - Error
Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly.

7. I do not know where to find these log files and would not know how to read them either!
8. Although my test file for PHP shows that it is installed and working, do you think I need to re-install it and if so what are the instructions for installing PHP on IIS7? (Because this is where I could have gone wrong…
9. Pleeeeeease help this is driving me crazy…. Any step by step solutions would be greatly appreciated!

Many Thanks

11-13-2007, 11:43 AM
Have you considered WAMP/ LAMP

11-14-2007, 06:21 AM
thanks I think I need to install WAMP otherwise I might waste even more days trying to install everything correctly. What is the difference between WAMP and WINLAMP and what do you recommend?

11-14-2007, 07:07 AM
First, I recommend using the mysql GUI tools instead of phpmyadmin - http://dev.mysql.com/downloads/gui-tools/5.0.html

Next, do you specifically want to use the IIS web server at this time or does the Apache web server meet your needs?

I believe under IIS, PHP errors are written to the Windows event log. You can also modify php.ini to create an error log in the location of your choice.

Based on the session error message, either the default session save path folder does not exist or the windows user account PHP is running under does not have proper permissions for the folder that is getting used. The error log will provide more specific info.

A common problem with php installations is that the php.ini that you are making changes to is not the one that php is using. In your phpinfo() output, there are a couple of lines in the first section that state if and what the actual php.ini is that is being used. At least for Win XP, you must stop and start the IIS service (or reboot your computer) to get changes made to php.ini to take effect. Just stopping and starting the web site under the management console won't get changes made to php.ini to be read (at least when php is running as an ISAPI module.)

Also in the phpinfo() output, check if the extensions you enabled are getting loaded (as will checking the error log.) This will tell you if the php.ini that you have been making changes to is actually getting used, if the extensions folder path setting in php.ini is correct, and if the extension .dll files are present and are getting found.

For the mysql extension there are a couple of auxiliary .dll files. The easiest way to get these to be found, per the current php.net installation instructions, is to add the php folder to the Windows path statement (you must either reboot your computer or log off and back on to get changes made to the Windows path to take effect.)

11-14-2007, 10:19 AM
I usually just type WAMP in to google and click download.

11-14-2007, 07:54 PM
what do you recommend?

I usually recommend XAMPP (http://www.apachefriends.org/en/xampp-windows.html).