I just got phpMyAdmin installed perfectly following your guide .. & I just wanted to thank you .. So,

Thank You ..

Thanks for the comment. Happy the guide was able to help out!
----------------
Dominic Ryan
3 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Hi,

First of all i would like to say that this tutorial is one of the most detailed ones I've come across...
I tried many tutorials and finally tried yours...

I've got the MySQL and PHP running... No probs there.
But when I unzip the phpmyadmin to a folder, make the changes to the config file and try to open the site. the troubles start...

Sometimes it opens, sometimes it doesn't. It also doesn't show the nice colors it normally has.
When I give in the credentials for the MySQL it tries to login... but no effect. It seems to hang or gives me the page not found error. After I got this error The site doesn't load at all. I need to reboot the IIS to get back some action...

I downloaded and installed:
mysql-essential-5.0.45-win32.msi
php-5.2.4-Win32.zip
pecl-5.2.4-Win32.zip
phpMyAdmin-2.11.1.1-all-languages.zip

I also have ActivePerl installed... maybe that's the "badass"?

This all I've got installed on a clean W2K3 Server machine with all updates, .NET Frameworks and IIS notging more...

Do you have any idea?

Thanx

Sounds like a permissions issue to me, maybe something to do with your PHP environment. Sorry I don't have an answer off the top of my head, so it looks like we're going to have to do some digging. Things I would check are;

- Event Viewer
- PHP Log
- IIS Log files

----------------
Dominic Ryan
3 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

I checked the Event Viewer and this it wat it said:

2 errors eventid 2214 and 2268
2214 says it can't load the php_mysql.dll
2268 says it can't load all the isapi filters

I'm not sure where to find the PHP log or the IIS log...

But i know i need to do something about the 2 errors I mentioned before.
Not sure how to fix it.
I'll keep you posted.

Thanx a lot for the help already :-)

Kindest regards,

Stijn

Ok, first thing I would be doing is double checking the extension_dir directive in php.ini, and perhaps try entering the absolute path if you haven't done so already. Also make sure you only have the bare essential PECL extensions loaded (as described in the guide) until this is sorted.

Your php log is defined in your php.ini file, and your IIS log files are located by default in %windir%\system32\logfiles
----------------
Dominic Ryan
3 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Thanx a lot for the help.
I completely uninstalled PHP and reinstalled PHP.
PHPMyadmin afterwards wasn't a problem anymore.

Great help, good tutorial.

Thank you,

Kindest regards,

Stijn

The Tutorial is no longer there can some one please repost it thanks so much for your time

Best Regards,

yeutragop

Thanks for notifying me yeutragop. Should be fixed now.
----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

this is it i can figure out everything installed but i cant get to myadmin. im new to server but not to the program. i can see phpinfo but when i got php myadmin i get Cannot start session without errors, please check errors given in your PHP and/or webserver log file and configure your PHP installation properly. im not sure about the logs either.please in you can help me. other than that i love ur guieds there great.

Make sure you have set up your sessions directive in php.ini as detailed on page 4 of my guide on installing PHP 5 on IIS in 5 simple steps
----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

well everything is exactly done as the guide says to but still no luck. id be happy if you looked at the php info, maybe you can see the issue. my site is http://keeper695.no-ip.org

forgot one my email

Ok, for a start you're running PHP 5.2.5RC4. The RC4 indicates you are running release candidate 4, i.e not yet production stable. As you're just starting out I'd highly recommend you stick with the latest stable build, which at present is PHP 5.2.5. Two other things, have a look at the "upload_tmp_dir" value in your php.ini file as it looks as if it is loading a good chunk of your php.ini file instead of just the path to your uploads directory. Finally, can you let me know what users/groups have permissions to you upload and session directories?
----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

i have made a chose that i am good with. Due to the fact that i am new to server 2003 i have this habit that allot of people most likly do and thats play and learn. i am going to clear the system and redo it. This way i can start from scratch with what i have learned. This time though i am going to come right back to the guides that you have writen i thank you very much for the time and help. you have been great, and believe you to be a very noble person for taking the time to help. I know that with the work you do and have acomplished it takes a good hearted person to offer there time to other. thankyou and ill be leting you know how it goes
thanks again -tim
ps. you dont have to post this i just want to say it.

I'm trying to install phpMyAdmin on iis7 and having done the same as i have done before, everyone time i go and test http://localhost/phpMyAdmin i get the error

"Cannot load mysql extension. Please check your PHP configuration. - Documentation"

I have followed all the tutorials for setting up php and that works fine, but phpMyAdmin will not ....

Any suggestions please ;):)

Two things to check;

1) Is the MySQL/MySQLi extension loaded in php.ini?

2) Is your php.ini been loaded?

----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

Hi, I found youre tutorial and read it through. I also read through the PHP and MySQL tutorials and that worked. I can acces the phpinfo.php page and it loads perfectly. The tutorials are very helpfull.
Whenever i want to load phpmyadmin i get this error:

""Cannot load mysql extension. Please check your PHP configuration. - Documentation"

I checked the php.ini in my php directory and it has php.mysql.dll and php.mysqli.dll enabled.

I really hope you can help me with this problem cause i need phpmyadmin to manage my MySQL server.

Thanks in advance

Walter

sorry it took so long to get back but as soon as i fixed the server my using the right programing i didnt stop. Like i said i have a bad learning curve and you made it so even i could learn to set this up right. thank you again and please feel free to visit again it thank to you that it works.
http://keeper695.no-ip.org

I gather you mean you have php_mysql.dll and php_mysqli.dll enabled in php.ini? Perhaps try only loading one of them, and check your php info page to ensure that the correct php.ini file is being loaded, the extensions are being loaded correctly and that the extensions directory is correctly defined. Have a read of my article on enabling PHP PECL extensions for Windows for further information.

----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

that's a great tutorial....................very useful.Cab you tell me how to
configure SSL connection in phpMyAdmin with 'cookie' authentication?

Are you wanting to secure the connection between your PHPMyAdmin server and MySQL, or between PHPMyAdmin and your browser?
----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

thanks sir i 've did what you said in this great topic but i got this problem

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

what i do in this case

thanks in advance

Make sure the IIS user account has write permissions to the directory you've set to save your sessions in php.ini .
----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

When I try to run the file "create_tables_mysql_4_1_2+.sql" I get the following error
Error
No data was received to import. Either no file name was submitted, or the file size exceeded the maximum size permitted by your PHP configuration. See FAQ 1.16.

Have you checked out the information in FAQ 1.16?
----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster

$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';
--
where to copy all these plz

Copy these settings into your config file as detailed on page 2 of the guide.
----------------
Dominic Ryan
4 x Microsoft IIS MVP, MCSE, MCSA
IIS Aid owner/webmaster