Hi all,

I have some problem with configuring phpmyadmin on my computer. I have read that others had some trouble as well with Vista, but I just can not sort it out.

Let me tell you what I have done so far:

-I have Apache 2.2(working fine tested several php files)

-I have php 5.2.11

-mysql 5.1 server installed

 

Mysql can be seen on the php test page, so that should be ok.

Loaded configuration file of php is c:\\php\php.ini which is also fine

I have copied the phpmyadmin into a folder called "phpmyadmin" and put it in htdocs folder.

Changed php.ini file:

-extension=php_mcrypt.dll

-extension=php_mbstring.dll

-extension=php_msql.dll

-extension=php_mysqli.dll

-session.save_path = "C:\php\session\"

-extension_dir = "c:\php\ext"

I have changed the httpd conf file in apache:

-LoadModule alias_module modules/mod_alias.so

<IfModule mod_alias.c>

Alias /phpmyadmin "C:/www/phpmyadmin"

</IfModule>

 

<Directory "C:/www/phpmyadmin">

Options None

AllowOverride None

order deny,allow

deny from all

allow from 127.0.0.1

</Directory>

 

I have copied the libmcrypt.dll from the php folder to c:\windows\system32 folder.

 

I have changed the phpmyadmin config.inc.php file:

it 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 setup/

*

* All directives are explained in Documentation.html and on phpMyAdmin

* wiki <http://wiki.phpmyadmin.net>.

*

* @version $Id: config.sample.inc.php 12304 2009-03-24 12:56:58Z nijel $

* @package phpMyAdmin

*/

 

/*

* This is needed for cookie based authentication to encrypt password in

* cookie

*/

$cfg['blowfish_secret'] = 'holla'; /* YOU MUST FILL IN THIS FOR COOKIE AUTH! */

 

/*

* Servers configuration

*/

$i = 0;

 

/*

* First server

*/

$i++;

/* Authentication type */

$cfg['Servers'][$i]['auth_type'] = 'config';

/* Server parameters */

$cfg['Servers'][$i]['host'] = 'localhost';

$cfg['Servers'][$i]['connect_type'] = 'tcp';

$cfg['Servers'][$i]['compress'] = false;

$cfg['PmaAbsoluteUri'] = 'http://localhost/pma/';

$cfg['Servers'][$i]['user'] = 'eva'; // username

$cfg['Servers'][$i]['password'] = 'csok6lade'; // password

/* Select mysqli if your server has it */

$cfg['Servers'][$i]['extension'] = 'mysql';

$cfg['Servers'][$i]['extension']= 'mysqli';

/* rajk - for blobstreaming */

$cfg['Servers'][$i]['bs_garbage_threshold'] = 50;

$cfg['Servers'][$i]['bs_repository_threshold'] = '32M';

$cfg['Servers'][$i]['bs_temp_blob_timeout'] = 600;

$cfg['Servers'][$i]['bs_temp_log_threshold'] = '32M';

$cfg['PmaAbsoluteUri'] = 'http://localhost/phpmyadmin/';

$cfg['Servers'][$i]['user'] = 'root';

$cfg['Servers'][$i]['password'] = 'root';

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

/* Contrib / Swekey authentication */

// $cfg['Servers'][$i]['auth_swekey_config'] = '/etc/swekey-pma.conf';

 

/*

* End of servers configuration

*/

 

/*

* Directories for saving/loading files from server

*/

$cfg['UploadDir'] = '';

$cfg['SaveDir'] = '';

 

?>

 

I am not sure about :$cfg['Servers'][$i]['auth_type'] = 'config';

somwhere it was written that it should look like this:

$cfg['Servers'][$i]['auth_type'] = 'cookie';

 

The problem is that i still get the error page

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

 

I have checked the error log in apache and it does not say anything!!!

Does anyone have any ideas what on earth can be wrong? i am going mad!!!

 

please help if you can, thanks in advace!!!

To be honest I'd download the free version of navicat (navicat lite) from here

http://www.navicat.com/en/download/download.html

It's far better than phpmyadmin

(I would also highly recommend the full version if you use mysql often - It's very useful)

I might be wrong but did you install php, apache and mysql separately before installing phpmyadmin.

 

If so you will have to uninstall all the seperate installations before installing phpmyadmin as phpmyadmin installs and configures all the above products.

 

Pat

Hey i have vista and phpmyadmin works perfect i'd suggest u just downloading xampp and it will self install the following products

 

1.php

2.mysql

3.phpmyadmin

 

 

Works perfect on vista hoped this helped

i use wamp works a treat

I also use wamp - never had problems.