Hi there
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:
;extension=php_gd2.dll
;extension=php_mbstring.dll
;extension=php_mcrypt.dll
;extension=php_mysql.dll
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:
<?php
/ 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
/
$i++;
/ 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
Louise