Good info for getting a lil personal web server up for local testing, or development! 🙂

Hello:

I followed the instructions on installing PHP and MySQL written in this post.

I have run into a problem installing phpMyAdmin.

When I go to my browser and type: http://localhost/phpMyAdmin/index.php, I receive the following error message:

Cannot load MySQL extension. Please check your PHP configuration. - Documentation

I read this material and I still am not quite sure what to do to fix the problem.

I was getting this error after applying your instruction:

However, I just changed everything back to the original state and I get no errors. However, a window pops up asking me where I want to save index.php. Is that supposed to happen?

I never had a message regarding index.php. I guess one of the changes you made to fix the original problem caused this one. I would do the installation again.

Is the index.php in the main phpMyAdmin directory under wwwroot? Also, make sure that you have a config.inc.php in the same directory as index.php.

Also, check your PHP.ini file and set these two lines:

extension_dir = "C:/PHP/ext"
extension=php_mysql.dll

Make sure to remove the semi colon for this statement

Ok, part of that worked only I got an error at the bottom of the page about couldn't load php_mysql.dll so I put the ; back in there and the error went away. Also, this is what I get at the top of the setup page:

How do I correct this I replaced the $cfg['Servers'][$i]['auth_type'] = 'config'; with http and vice versa, still the same warning 😕

The "ext" directory was created during the PHP install. At least it did with my install. Don't forget you need to download 2 files to install PHP.

PHP 5.1.1 zip package
PHP 5.1.1 installer

Here's the download URL: https://www.php.net/downloads.php
The files are sitting under "Windows Binaries". It is the first and third file you need to download.

Try reinstalling PHP. See if you have any luck.

Does the php-5.1.2-Win32 get extracted into the PHP folder?

When you run the installer, which is the second file you download, it will prompt you for a directory. The default is C:\PHP - leave it at that. All the files should be placed in their appropriate spots.

Im not talking about that, I did the installer thing. The php-5.1.2-Win32 I downloaded has files and folders inside, do they belong in the PHP folder? if so it asks me if I want to replace certain files, all off the files match as far as name and size except one the php-win. Dont mind me I am just a bit frustrated ive been at this for quite awile...

Yes, in C:\PHP, create the following directory: ext. Copy all those files into C:\PHP\ext.

These are the extensions that are needed.

Here is what your PHP.ini file should have:

extension_dir = "C:/PHP/ext"
extension=php_mysql.dll

Remember no semi colon after those entries

this is what my line in the ini looks like:

extension_dir = "C:/PHP/ext"./'
is that correct or do you mean it should look like this:
extension_dir = "C:/PHP/ext"

Also I have to leave this line like this or I get an error at the bottom of the page:

;extension=php_mysql.dll

this is the error I get when I change it:

PHP Warning: PHP Startup: Unable to load dynamic library 'C:/PHP/ext./?\php_mysql.dll' - The specified module could not be found. in Unknown on line 0

Also could this be part of the problem? Im used to using an older version of MySQL and the default intall local is C:/MySQL but I am trying the newest version and its install directory is C:\Program Files\MySQL

The line for the ext directory was copied exactly from my PHP.ini file. So, the line should read like that.

At this point and I know your frustration, I did this install three times before I got it to work. I deleted and uninstalled everything and started from scratch.

One thing that should be done and I don't know if it was, go to Control Program, Add or Remove Programs, Add/Remove System Components. In the components box, make sure that you have a check mark next to Internet Information Services (IIS). You probably do it just a double check.

Sometimes starting over, now knowing for what to look, may go smoother.

hi:
i did what u guys was saying but i got an error , i have provided the link location.

could u plese help me on this.[/url]

The error tells you exactly what to do.

"Probably reason of this is that you did not create configuration file."

You need to create the config.inc per the installation instructions or use the setup link that is provided in the error message to generate one.

ok after i download the config file then where i need to save it, will this be last step.

Your config.inc file needs to be in the root of the phpMyAdmin directory.

Side note. I would strongly advise creating a different user than root for your database and don't use "no password" unless this will only be on your local machine and not accessible from the internet. root is the master user name for mySQL and if you're using that with no password for your database you're asking for security problems. Particularly since you've given us a link to the error and it's obvious now to the world you're using root no password for the DB access.

Hi there, i'm new to this forum and hopefully will get answers for my probs....i'm windows user, using IIS server, last nite install MySQL, went through all the wizards stuff but when the execute button prompt, clicked it but the when configurating it tries to access the internet which current dont have and the process wont continue unless i have access of the net....is it crucial to have internet to install mySql database?

Someone help me!

Malakite

Your question isn't entirely clear. The only part that I know of in the install that would require internet access is where you are prompted to register with MySQL.org That is an optional part of the install. You can skip that.

yeah i got that and skipped it!
basically after hitting execute button,
It has frozen up during the final step (MySQL Server Instance
Configuration).

I'm installing it on Windows XP, and I used all the
default settings, except that I changed "Detailed Configuration" to
"Standard Configuration".

At the "Start Service" item in the checklist,
I got a 1045 error message saying to allow TCP port 3306.

also after re-running it, it puts a red 'x' in the "Start service" checklist and says "The service could not be started. Error: 0"

i dont know what is wrong

It's because the service was most likely already running. I remember running into that a couple times myself. If I recall correctly, just reboot the computer and you should be fine.

As part of the install:
Make sure you update the MySQL client for PHP.

After installing MySQL copy libmySQL.dll from the MySQL installation to the c:\php directory, overwriting the previous.

Thanks a lot everyone! i got it working by using DOS commandline, thanks again.

Umm, I need the username and password? What would it be?

username is: root. Unless you set a password during install there is no default password. Just leave it blank.

Cant get it to work... And I didnt set a PW

its great to see a PHP how to guide. I just went through instaling a PHP database and it was a pain the but to do on my own with only basic knowledge. I found this just a day too late 🙂

Hi
I'm very frustrated 😟
I've followed the instructions for installing all the bits.
MySQL works
PHP works
My IIS works
MySQL Admin Tool works
phpMyAdmin doesnt work 😟

I'm continously getting the

Cannot load MySQL extension. Please check your PHP configuration. - Documentation

error - my PHP.ini file looks like this (at the moment, but has looked several different ways)

; Directory in which the loadable extensions (modules) reside.
extension_dir = "C:/PHP/ext"
extension=php_mbstring.dll

My config.inc.php file looks like this:

/ 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;
/ Select MySQLi if your server has it /
$cfg['Servers'][$i]['extension'] = 'MySQL';
/ User for advanced features /
$cfg['Servers'][$i]['controluser'] = 'pmausr';
$cfg['Servers'][$i]['controlpass'] = 'pmapass';

should i add in the other bits from the instructions to the config.inc.php file?
ie. these bits:

$cfg['Servers'][$i]['auth_type'] = 'config'; // Authentication method (config, http or cookie based)?

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

$cfg['Servers'][$i]['password'] = 'yourpassword'; // MySQL password (only needed

// with 'config' auth_type)

cos my config.default didnt have them so i didnt add them, could this be the problem?
I've tried moving the php_mbstring.dll file to different places within the PHP folder but no luck ... I'm completely baffled as to why this isnt working.
Thanks for any help
Sue

Under Windows extensions in PHP.ini uncomment

extension=php_mysql.dll

Make sure php_mysql.dll exists in the extensions folder.

hi
Thanks for that, it worked.
I now have a new problem - I know I should try to find the answer myself but I'm hoping you'll know quickly and save me a few hours searching and experimenting 🙂
Anyway, now I've got the error

MySQL said
#2003 - The server is not responding

I know the server is working (IIS)

where do i need to go to fix this?

Thanks
Sue

Nice tutorial, realy helped me in configuration. I was stuck from many days to do setup. thanks again

i follow the steps but when i type link of some PHP file, it give option to download instead to run the script. any clue, why is that.

brillaint ill try this later cheers

i follow the steps but when i type link of some PHP file, it give option to download instead to run the script. any clue, why is that.

You have to register the PHP extension in IIS.

i get

phpMyAdmin - Error
Cannot load MySQL extension. Please check your PHP configuration. - Documentation

MySQL.dll exists in the ext dir and i have uncommented it in PHP.ini, everything else is working i think but thats not :S

Reboot your computer or restart the MySql service.

Nice guide, everything else works but i get

phpMyAdmin - Error
Cannot load MySQL extension. Please check your PHP configuration. - Documentation

What version of MySql and PHP are you installing?

I uninstalled it all now am going to start from fresh. I don't really need that to work just trying to get java to work. I have 5 java files that were sent to me and I can't get them to work on tomcat. also when I go to http://x.x.x.x:8080 i get the router admin login when I'm on the local network so it is really annoying to rest. if I do localhost:8080 or 192.168.0.2:8080 it will work:s it always used to work just doing my external ip, but dosnt now on my new pc.

I am installing the latest of both whichever versions that is.

For PHP 5 the following should be uncommented in the extensions list

extension=php_mysql.dll
extension=php_mbstring.dll

(note there is a difference between MySQL.dll and php_mysql.dll

Make sure the path to the extensions directory is correct and make sure php_mysql.dll and php_mbstring.dll exist in the extensions directory.

cheers will try later because one of my websites hasnt got hosint at the moment

where is the extensions folder? i couldnt find it last time so just left it

You need to download the PHP 5.2.1 Windows Binaries from the download page and unzip it to the PHP folder. (it contains the extensions folder and the extensions. The Windows install file does not include them - they need to be added separately)

https://www.php.net/downloads.php

is there any tutorial on how to install PHP and MySQL on the new IIS 7.0 on Windows Vista?

thanks

Not here at OZZU, no. And unfortunately I don't have IIS 7.0 or Vista yet to mess around with it.

I'm not well versed in any of this.. I'm trying to install and learn PHP but i'm using Windows Server 2003. I followed the instructions on installing PHP but for some reason when I create the test file and place it in the wwwroot folder, it doesn't work.

Any ideas?

i get

phpMyAdmin - Error
Cannot load MySQL extension. Please check your PHP configuration. - Documentation

MySQL.dll exists in the ext dir and i have uncommented it in PHP.ini, everything else is working i think but thats not :S

I get the same thing, php_mysql.dll is unquoted, everything was done, i get the test to work, the setup.php to show, but index.php show that message. I check my extension folder, it was set corrected for C:/php/ext so I don't know what else I'm doing wrong. Please help

Nevermind, solved it by moving PHP.ini to windows directory. Argghhhhhh...wasted alot of my time.

I used your tutorial (Thanks for your work on that btw.) but I am having a problem connecting to any database. All of the following are on my local machine: PHP 5.2.2, IIS Server 5.1,MySql 5.0.41-cimmunity-nt and MS Server 2005 Developer. When I couldn't connect to Server 2005, I loaded MySql. I get similar errors while attempting to connect to either server. Mostly, no errors reported and no connection, the script just stops dead (I have tried a variety of connection strings but this is the latest).

$link_id = mysql_connect();
if($link_id) echo "Connected to the MySQL server successfully<br>";
else die ("Connection to the MySQL server was unsuccessful");

As mentioned, I am getting the similar results while trying to connect to MS Server 2005 using $link_id = mssql_connect(); .

Btw, I am having no trouble connecting to Server 2005 using ASP. But we have projects coming up that will require PHP.

PHP scripts that do not require a connection to the database are working fine. I have no trouble logging into MySql at the command prompt. It could be a separate issue, but when I try to log into Server 2005 thru an ODBC connection, I get a 18456, state 11 error.

I appreciate whatever help you folks can give on this. Thanks!

Check the comments in the post about using "old_password". Seems like most PHP programs I've tried on Windows do not like the default password encryption. Not sure why, but switching to old_password and creating new user accounts with old password encryption seemed to work. You can change existing users to old_password from a command line but I've run into glitches with that especially when trying to change root.

I changed the script to:

$link_id =  mysql_connect("localhost", $dbuser, $dbpass);
mysql_select_db($dbname);

if($link_id)
	echo"Connected! <br>";
else	
	die("Connection failed");

Still getting the error "Connection failed".

Hi,

I'm new to this forum and I'm seeking help in getting MySQL install working. The install went without any problems (XP2) but when I try to start the service I get these results:

Using the Command Line:
As soon as I hit "Enter" after typing the password, the black window disappears immediately.

Using the Config wizard: Error message that the service could not be started.

I checked the services page in "Admin. Tools" but MySQL is not listed there. I did a complete uninstall and a re-install but no change, the service just doesn't start. What can I do?

PS. I also have the Apache (2.2.4) server installed and it seems to work fine.

I have followed the instructions on this forum for installing PHP and MySQL on Windows XP IIS and all has gone well (amazing tutorial by ATNO).
But when installing phpMyAdmin the wheels come off.

I have been through everything posted on this forum and can't get it to run smoothly.
I have actually gotten to the http://localhost/phpMyAdmin/index.php page on a couple of occasions and its working but then I close the browser and try to access it again and I get this:
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

it will work/not work spiratically without me changing any setting at all. I am freaking out over here because I am trying to get all this set up so I can develop a database for the website I am working on which is due in less than a week. Admittedly my PHP/MySQL skills are rudamentary at best but I am usually pretty good at following directions and guidlines which gets me through. However, in this situation, I am completely stumped and would greatly appreciate any form of advice or help that anyone can offer me.

thank you

--edit--

On one of the times I was successfully able to log in to phpMyAdmin, I attempted to make a test database with a test table. The database is created, but when I attempt to create tables I get this error:

No tables found in database.
PHP Warning: session_write_close() [function.session-write-close]: open(C:\DOCUME~1\YEMI\LOCALS~1\Temp\php\session\sess_apbmimv71ugga9lji84saqshi3, O_RDWR) failed: Permission denied (13) in C:\Inetpub\wwwroot\phpMyAdmin\navigation.php on line 82 PHP Warning: session_write_close() [function.session-write-close]: Failed to write session data (files). Please verify that the current setting of session.save_path is correct (C:\DOCUME~1\YEMI\LOCALS~1\Temp\php\session) in C:\Inetpub\wwwroot\phpMyAdmin\navigation.php on line 82

I have installed IIS (through Control Panel), and when I go to http://localhost/, it says I need a password 😢

I've put in every password that I could think of, on every user account on my computer (damn parents) lol.

Any help = me being grateful!

Your Windows Login username and Password will work. However, that's the damnedest thing. I've been using IIS for years and http://localhost/ has NEVER required a password, but damned if I didn't open localhost on my laptop just now and it asked for a password too. Has never done that. My Windows / Domain Admin username and password worked, but have no clue why it's asking for username and pass.

Going to have to look into that. It may just be because you haven't set up a website yet and the default is the iisstart page. Might be that they changed it to prompt for administrative password

Well, on my computer there is no admin password (by Windows default of corse)

Still cant figure it out. Ive been messing with it for awhile now >.>.

You think that if I called a computer place (for instance dell, because my workstation is from dell), that they would be able to help?

have you tried your user name and leaving the password blank? Or just try Administrator and leave the pass blank.

Any more tutorials? like ASP,net and such..

have you tried your user name and leaving the password blank? Or just try Administrator and leave the pass blank.

I got this to work.. Sorry I didn't post earlier.

Just wondering if I can, hopefully, get some help with this. I followed the steps here to get PHP and MySQL setup on my system, using IIS, so that I can run Helpdesk Reloaded for work. It's a Windows 2000 Server system, ISS 5.1 (if memory serves me correctly, I'm pretty 2K comes with IIS 5.1, not 5.0), PHP 5.2.4, and MySQL 6.0.2, also I have installed MySQL Tools 5.0 and phpMyAdmin 2.11.1. The install of Helpdesk Reloaded worked fine, database has all the information imported into it from local version I was running using EasyPHP. The login page wasn't coming up at first, but that was just because a config.php file didn't have the DB password in it, that comes up fine now. But now, whenever I go to log in it comes up that the page can not be displayed and the error code is "HTTP 405 - Resource not allowed." So, obviously, this is a problem with IIS, and I'm guessing it's not agreeing with some verbs. I currently have .php set to All Verbs, instead of Limit to, because I figured that should fix the problem, but alas, no go. So, any help would be greatly appreciated.

did you reboot the computer after reseting PHP to All Verbs? I've found after making a change to the config that's sometimes all it takes.

did you reboot the computer after reseting PHP to All Verbs? I've found after making a change to the config that's sometimes all it takes.

Rebooted it after each change I made, hoping that'd work, since it usually works for most things. Any other ideas?

Have you seen this?

https://www.somacon.com/p126.php

It describes your error in IIS and provides resolutions.

Now, correct me if I'm wrong in this, but basically, what I'd do is replace where it says to choose ASP.dll with php5isapi.dll, since I'm using PHP, not ASP for the page, and I'd set up php5isapi.dll for .php extension, not the .html extension, yes? (Though, I tried for .html and .htm as well, just to see what would happen, and no go.)

Also, I discovered that if when I type in the URL, instead of going to http://www.domain.com, I go to http://www.domain.com/index.php it will let me log in, but certain PHP scripts, when I go to certain pages, won't run, and part of the page will be blank.

I found one site that said that the cause of that is if you have FrontPage setup in IIS, so I removed it, but it still happens.

For the mapping I used .php ext c:\PHP\php-cgi.exe verbs "all". Have never had a problem with any PHP file.

I got that from here when I set mine up.

https://www.visualwin.com/PHP/

Sorry for taking so long to respond. Well, I set up the server earlier to use PHP-CGI.exe, and once I finished configuring it because of the redirect, it still has the same exact problem. Anything else you can think of? (At this point, I'm thinking it might be easier to wipe it, install Fedora, then just yum install Apache, PHP, and MySQL.)

I seem to recall trying a couple programs once where I've got that error. Oddly I have about a dozen PHP apps running just fine on IIS with MySQL including phpMyAdmin, phpBB, and Coppermine as well as ones I wrote. I basically summed it up as something in the way the programs were written that IIS didn't like, couldn't figure out what, and just chucked the programs and found another solution.

hi anto,
quick question, im following thesesteps to install the php/mysql onto my existing iis 5 server running on a windows 2000 sbs server i have here.
im wanting to add a moodle website to my server, in addition to my existing websites already on the server.

in order to run the moodle site ineed PHP and MySQL.
my question is this, im installing PHP, and its asking what 'webserver setup'... what web server setup? 'do not setup a web server' since i already have my iis up and runnin fine?
thanks
marc
im very new to PHP, i had the wamp package running on a dedicated pc, but not an iis server previously!
thanks'
m

You know it's been nearly two years since I've set it up and I can't recall that part of the install. Perhaps someone with a more recent install experience could answer that for you.

Thank you for your great tutorial.

I am having some issues with the PHP. I can run the test page and it works but no other .php pages will load?

Any suggestions?

Hello there

First of all thanks for your tutorial. After four frustrating hours am more frustrated now(but every programmer goes through it), I've been trying to run PHP on windows xp machine which is used for development purpose. Am not sure where am going wrong. I have carefully followed the instructions in this tutorial but still am getting HTTP 500 error, Should I use php5isapi.dll for mapping purposes or PHP.exe? Sorry am totally confused and a newbie for PHP, so any help would be much appreciated.

Tons of thanks in advance

I have followed your instructions to the 'T' and I am getting an error when I goto my browser:

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

I can not find any errors or a log file for that matter.

My PHP.ini you said to edit is not where you said it would be it is in the c:\PHP directory. Although I did modify it according to your instaructions.

Also I am running the defaulr web server on port a non standard port.

Any insite would be great

Thank you

If you didn't do the standard Windows Install, then you need to copy and paste the PHP.ini to C:\Windows
That should fix the errors once PHP.ini is in the correct place.

I would first like to say awesome tutorial.

When I tried to follow it, I got to the part of installing PHP and got this error when trying to install it:

Here is the error:

It says "The installer has encountered an unexpected error installing this package. This may indicate a problem with this package. The error code is 2878."

I have tried re-downloading the installer 3 times already, and I've disabled the Bitdefender and registry mechanic programs that I have installed. I have also tried to restart the pc and none of those things helped.

This was apparently a problem with 5.2.5 and was reported on November 9th. This issue was addressed and closed by jmertic. Apparently, it's now fixed in the CVS but might take a few days for the installer. I'd suggest giving it a day or two and downloading it again, or if you want download the current CVS from the link provided in that post. If you aren't comfortable installing from a CVS, I'd suggest waiting until the installer is fixed.

thxs for the quick responce. i dont mind waiting so ill just wait for the installer.

nice tutorial.

I have an interesting problem and since you seem to have been really great in answering these fine people's questions, i thought I might pose it to you.

windows 2k3 standard server running iis = works fine
PHP is installed and working great.
MySQL is installed on another server in the same domain and it is working great

i want to link the PHP install on the PHP machine to the MySQL install ont he MySQL machine.

i have the MySQL.default_host = 192.168.1.141 (the server's ip on the network, i have also tried it's hostname) but when i open my test.php file to see what's installed and working in PHP, it does not list MySQL at all.

ultimately i want to use phpmyadmin to manage the MySQL install, but since my server running PHP can't see MySQL, that isn't going to work yet.

so besides installing PHP on the MySQL server, is there a way to get this setup to work?

Never done that but just a hunch, you probably need to include the port msySQL is using, example 192.168.1.141:3306

tried that, no dice. hmmm... i might try installing PHP on the MySQL server just to ensure that that local installation can find the MySQL using localhost.

I am having a hard time finding any documentation on how to troubleshoot a remote MySQL connection like this though online.

Looks like this is how.

https://www.cyberciti.biz/tips/how-do-i-enable-remote-access-to-mysql-database-server.html

Although the instructions assume a Linux install, it looks like it should be relatively similar for Windows. I'll see if I can find a Windows version.

This guy got it to work in Windows:

https://forums.techguy.org/threads/solved-how-to-enable-remote-access-to-mysql-server-on-windows-xp.623379/

thanks for the info, I tried what that guy said, but there's no change.

I am wondering if what I am trying to accomplish is even worth it...

I have a database server i wanted to use for all of my SQL and MySQL dbs and an IIS server that would run websites with various languages like ASP, PHP, etc. I was hoping that the PHP would link to MySQL on the other server to keep things uniform like that so I wouldn't have to put the MySQL dbs on the IIS server.

does this sound like a waste of time to you?

I kind of find it odd that I can't just define that MySQL is at that specific location and PHP wouldn't jsut communicate with it, but then again, i am not an expert so...

update: interesting twist to the issue. on a hunch i tried to telnet from the IIS server to the database server on port 3306. it doesn't allow it. so there may be hope yet and it may lie in permissions. I'll keep digging and let you know.

Check to make sure Window's firewall is NOT on. It will block it. I was reading a post yesterday with the same issue and all it was was the firewall. Once that was disabled everything worked peachy. (Sorry, had to leave quickly and didn't get to post or bookmark the page). If you use a 3rd party Firewall, make sure your Web Server is permitted.

Also if you use MySQL Administrator, log into it as root or an admin account and on the Startup section, General tab make sure "Disable Networking" is not checked. If it is, uncheck it and restart MySQL.

both servers are win2k3 standard, neither using any firewall. local router with firewlal on it allows all lan to lan traffic. i think i originally configed this instance of MySQL with remote connection disabled. i am attempting to remove it and readd it with remote connection enabled.

did that. now telnet works. it didn't automatically show up in my PHP file, but i'll try some things and see what i can come up with. i really think this is supposed to be able to work.

Yes it should work. I've just never done it so I'm guessing here.

In your php.config.ini how does this line read?

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

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

that's the ip of the database server

to tell you the truth though i am not even looking at phpmyadmin because PHP doesn't list MySQL or when you do a

<?php
phpinfo();
?>

i am assuming that this issue needs to be fixed first and then phpmyadmin will fall into line after that.

i just don't get what i am missing.

I have extension=php_mbstring.dll and extension=php_mysql.dll unquoted in PHP.ini

extension_dir = ".\ext"

MySQL.default_host = 192.168.1.141

the path to the PHP directory is set in windows... I'm not sure what else can be edited.

I also went to MySQL and ran a
GRANT ALL PRIVILEGES ON . TO USERNAME@IP IDENTIFIED BY "PASSWORD"; supplying my root username and password to it.

thoughts?

probably won't make a difference, but try adding the default port 3306 here around line 690

; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
MySQL.default_port =

remember after making any changes to PHP.ini you should reboot. I've driven myself nuts over issues that I fixed but didn't realize I had until after I rebooted.

Also from:

https://www.php.net/manual/en/ref.mysql.php

Try this I found in one of the comments:

<? php
Following PHP Script is useful to test PHP connection with MySQL.
*/

//$connect = mysql_connect("Your Host Name", "MySQL root directory", 'MySQL password, if any');
//$connect = mysql_connect("Host Name or Address - 127.0.0.1", "root", 'password');
$connect = mysql_connect("localhost", "root", 'password');
if ($connect){
echo "Congratulations!\n<br>";
echo "Successfully connected to MySQL database server.\n<br>";
}else{
$error = mysql_error();
echo "Could not connect to the database. Error = $error.\n<br>";
exit();
}

// Closing connection
$close = mysql_close($connect);
if ($close){
echo "\n<br>";
echo "Now closing the connection...\n<br>";
echo "MySQL connection closed successfully as well.\n<br>";
}else{
echo "There's a problem in closing MySQL connection.\n<br>";
}
exit();
?>

probably won't make a difference, but try adding the default port 3306 here around line 690

; Default port number for mysql_connect(). If unset, mysql_connect() will use
; the $MYSQL_TCP_PORT or the mysql-tcp entry in /etc/services or the
; compile-time value defined MYSQL_PORT (in that order). Win32 will only look
; at MYSQL_PORT.
MySQL.default_port =

remember after making any changes to PHP.ini you should reboot. I've driven myself nuts over issues that I fixed but didn't realize I had until after I rebooted.

tried both, no change.

tried the PHP connect script but for some reason it is erroring out with unexpected T_VARIABLE

wow...

i found the fix...

Add the following registry keys:

HKEY_LOCAL_MACHINE\SOFTWARE\PHP\5\IniFilePath -> c:\php5

that is... really... out there...

i'll see if i can get phpmyadmin working next.

phpmyadmin works great now.

awesome!

thanks alot for your help. I'll check out the rest of the forum and see whatelse is cooking around here 🙂

Interesting solution. Where is your PHP.ini located? I just assumed it was in C:\Windows. Regardless Glad you got it.

D:\PHP5

i added that to the system variables path in windows... i thought that would be enough.. aparently the reg key is needed in my case.

good to know. I'm sure down the road someone else will be playing with the same thing and benefit from the solution. (probably me *lol). Thanks for letting us know how you did it. For the record for those reading in the future, if you use the Windows Installer, PHP.ini will be installed in C:\WINDOWS and the environment variable path set correctly for PHP. However a manual install won't do that, and you should copy PHP.ini and place it in the Windows directory.

Hey ATNO/TW, thanks for the superb tutorial on installed PHP and MySQL on Windows Server 2003 with IIS. I'm new here and truly new to IIS. My situation is, I have PHP installed, it is running, I have MySQL installed (MySQL Admin reports that is it also running. My issue, I am not having any success at getting the two scripts to talk to each other.

I am installing Joomla 1.0.13 (Stable) on that particular server and this is the confirmation screen data:

PHP version >= 4.1.0 Yes

• zlib compression support Available
• XML support Available
• MySQL support Unavailable
  configuration.php Writeable
  Session save path Unwriteable
  Not set

MySQL Support - unavailable, why? What is going on? I've checked, double check and did everything form the PHP.ini file to dragging the libmysql.dll to the C:\Windows\system32 directory. PHP is running fine, MySQL is 'supposedly' running fine. Can someone please help me figure this problem out before I lose my insanity.

(*Note: Session save path is not important, Joomla does that on my working linux server sometimes and works properly.)

On the good note, everything works perfectly with usbwebserver from http://www.usbwebserver.com

Any help would be appreciated. Thanks in advance and Happy Holidays!

Thanks for the compliments on the tute. It's a little old and needs some updating. Hope to get to that soon.

Unfortunately, I've haven't installed Joomla on Windows yet, so not sure what kind of glitches might happen. I do have a friend that solely uses Joomla on IIS, though. If I catch him online I'll have him look at your post and see if he has any thoughts.

Might help to know which version of MySQL you installed.

Hi, I've been searching online for the last few hours trying to find the best (and most recently active) thread on the topic of Windows + PHP + MySql + phpMyAdmin installation. And, I'm pleased to report that this is by far the best resource that I could google.

I'm hoping that you can help me understand the problem that I'm currently experiencing with my installation.

I am using:

1. MySql 5.1.22-rc-win32
2. PHP 5.2.5-win32-installer
3. phpMyAdmin 2.11.4-rc1-english
4. Windows 2003 Server
5. IIS 6.0

I've tested a phpinfo.php file containing

<?php phpinfo() ?>

and a test.php containing

<?php 
// Connecting, selecting database 
$link = mysql_connect('localhost', 'root', '<password redacted>') 
or die('Could not connect: ' . mysql_error()); 
echo 'Connected successfully'; 
mysql_select_db('mysql') or die('Could not select database'); 

// Performing SQL query 
$query = 'SELECT * FROM user'; 
$result = mysql_query($query) or die('Query failed: ' . mysql_error()); 

// Printing results in HTML 
echo "<table>\n"; 
while ($line = mysql_fetch_array($result, MYSQL_ASSOC)) { 
	echo "\t<tr>\n"; 
	foreach ($line as $col_value) { 
		echo "\t\t<td>$col_value</td>\n"; 
	} 
	echo "\t</tr>\n"; 
} 
echo "</table>\n"; 

// Free resultset 
mysql_free_result($result); 

// Closing connection 
mysql_close($link); 

if ( !is_dir( session_save_path() ) ) {
	echo "'session.save_path' directory not set! Please set your session.save_path in your php.ini file.";
} else {
	echo "'session.save_path' is set. ";
	echo session_save_path();
}

?> 

The results are a succesful phpinfo output containing the following (most likely relevant) entries:

header (not titled)
Loaded Configuration File C:\PHP\php.ini

configuration
extension_dir C:\PHP\ext

MySQL
Client API version 5.0.45

session
Session Support enabled
Registered save handlers files user
Registered serializer handlers PHP php_binary wddx

session.save_path C:\PHP\sessions

The output of the test.php looks like this (modified to remove password output)

Connected successfully
localhost root *<password redacted> Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y Y 0 0 0 0
'session.save_path' is set. C:\PHP\sessions

Yet when I visit my myphpadmin page, I get

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.

I have reviewed the suggestions in this thread and granted both the IUSR_<machinename> and NETWORK_SERVICE users full control of the C:\PHP\sessions directory.

I would greatly appreciate your assistance. Please help me figure out what I'm doing wrong.

Thank you

Edit: Before you ask, I have tried to turn on log files and have been unsuccessful. I'm entirely willing to try to turn log files on but I will need instructions.

LOL 🤣

Well, I hate to remove my post as it might contain useful information for others who have similar problems... but after closing the web-browser and restarting it, I now get:

Welcome to phpMyAdmin 2.11.4-rc1

Probably reason of this is that you did not create configuration file. You might want to use setup script to create one.

Error
MySQL said:

#1045 - Access denied for user 'root'@'localhost' (using password: NO)

phpMyAdmin was unable to read your configuration file!
This might happen if PHP finds a parse error in it or PHP cannot find the file.
Please call the configuration file directly using the link below and read the PHP error message(s) that you receive. In most cases a quote or a semicolon is missing somewhere.
If you receive a blank page, everything is fine.

./config.inc.php

I should be able to solve the remaining problems from here. I will report results briefly (I'm sure you'd like to know how it ends.)

Ok, ran the ./phpmyadmin/scripts/setup.php script and generated my config, then opened a new browser window (lesson learned) and voila... since I chose HTTP auth_type, I get prompted for a username & password using the Microsoft CHAP window.

Enter the appropriate username/pass and I have a working phpmyadmin installation.

Hopefully this information is helpful to someone, and thank you for putting together a well documented installation process, it was very helpful

Regards. 😎

Thanks for updating. I just saw your PM. Sorry I couldn't get to it sooner. And thanks for the compliment on the tute.

Hello All:

Here's my scenario:

I have PHP, MYSQL running on Windows XP SP2, IIS V5.1.

Whenever I attempted to connect to MySQL via PHP, I was getting a nasty fatal error referencing and undefined mysql_connect...

I managed to clear that up by creating an environmental variable PHPRC.

Now, whenever I test a connection to MySQL, I get a blank browser page. Whenever, I attempt to insert data I get the HTML confirmation, but no entry has taken place.

I am at a lost. Has anyone experienced this before.

Thanks.

Update:

phpMyAdmin works fine. However, I cannot connect to MySQL via PHP. I still get a blank page.

There is probably something wrong with your connection string then. phpMyAdmin works on PHP and uses MySQL so it sounds like you are set up fine.

What's your connection string you're trying to use?

There is probably something wrong with your connection string then. phpMyAdmin works on PHP and uses MySQL so it sounds like you are set up fine.

What's your connection string you're trying to use?

I snagged this off the net:

<?
error_reporting(E_ALL);
$connection = mysql_connect("localhost:3306", "root") or die ("Cannot make the connection");
$db = mysql_select_db("word", $connection) or die ("Cannot make the connection");
$mynums = array(3,5,10,20);
if(in_array($_POST['select'],$mynums)) {
$SQL = "SELECT * FROM Random ORDER BY RAND() LIMIT {$_POST['select']}";
}
$result=mysql_query($SQL);
echo ($result);
?>

This test script actually worked:

<?php
$link = mysql_connect('localhost', 'mysql_user', 'mysql_password');
if (!$link) {
die('Could not connect: ' . mysql_error());
}
echo 'Connected successfully';
mysql_close($link);
?>

So, it must be the connection string.

I went through all of your steps..my set up is:

My setup:

WinXP Pro
IIS 5.1
PHP Version 5.2.5
MySQL Server 5.0
PHPMyAdmin 2.11.3

PHP works, and I can log onto MYSQL. When I try to run phpmyadmin i get:

"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."

Where are these logs under IIS?

Any pointers on how to troubleshoot this? I had all of this running well about 2 years ago but that must have been with older versions of everything......

turn on PHP error reporting to see what the exact error is. Here's a couple ways to do it

http://www.wallpaperama.com/forums/how-to-display-php-errors-in-my-script-code-when-display-errors-is-disabled-t453.html

The easiest way is to just edit your PHP.ini file

display_errors = On

Hey CrumpyBumpy,

I experienced the same error with PHP. The error message is vague. So, a solution for one may not be a solution for the other. Nevertheless, I'll tell you what I did.

In the PHP.ini file, I enabled the extension=php_mbstring.dll under the dynamic extensions section.

The IIS log files are located at: C:\WINDOWS\system32\Logfiles\W3SVC1

I spoke too soon.

Yes, the last test script I posted tells me that the user connected successfully. However, when I view MySQL Administrator, I see no connect.

Troubleshooting continues...

Finally, I found my error.

<?php is needed as opposed to <? when opening a PHP script.

Thank you ATNO/TW for the great tutorial. MySQL Administrator is a great tool (the first time I've seen it).

Thank you too for taking the time to help all of us noobs with this setup.

Now for my issue. I'm trying to set up PHPBB for our gaming group and just can't get it to work. It seems that PHP is installed correctly (I get the info.php screen). It seems that MySQL is installed correctly (I get the part where I enter the password in MySQL monitor and log in successfully). However, when I go to the setup for PHPBB it doesn't show MySQL as being installed. In MySQL Administrator, it shows 3 databases: information_schema, MySQL, and test.

I've totally removed everything (PHP, MySQL, PHPBB) and reinstalled it without luck. I did get stuck on one thing during your tutorial, the part about editing the PHP.ini file. I don't have one in my C:\Windows directory so I edited the one in my C:\PHP directory. C:\PHP is in my path so that should work.

I'm a newbie with PHP, PHPBB, and MySQL so I may have missed an easy thing but I'm just at a loss right now. Thank you for any help you can give me.

P.S. I did try the PHPBB forums and was unable to get any help.

Use MySQL administrator to create a new database. By default phpbb2 used forumdata as a database name (however you can name it anything you want). Then create a user in MySQL Admin and grant that user rights to the new database. phpbb does not create the database for you. You have to do that first. Then in the install enter the username and password of the user you assigned rights to the database. Then the phpbb install will create the tables and populate the database for you.

Then try the phpbb install. Make sure your config.php file is writeable by all.

btw, thanks for the compliments. Much appreciated.

You especially deserve the compliments. I realize how much time it takes to do your life, work and still moderate a forum like this.

Sorry it took me so long to try this out. That whole life thing keeps getting in the way. 😉 This is what I have so far.

I had an existing database from a previous install on an Apache server called PHP so I moved the folder to the "C:\MySQL\MySQL Server 5.0\data" folder. Restarted MySQL service and I can see it fine in MySQL Administrator. I then created a user called phpbb and assigned all privelages to that user. (see my screen shots)

I then checked the permissions on the config.php in the forum directory and they are set so everyone can write, read and execute and modify.

Launching the install for phpbb still shows MYSQL as unavailable.

I would be happy to try a totally new database but I don't know where to create one in MySQL Administrator.

Thanks again for your help and if you need information I'm not including please ask me because I'm not sure what else you may need.

Screen shots:

That is an advertising web search page. Why go there n_oandasan?

Open config.php in an editor. By default it is blank. If anything is in it, remove it and replace it with this:

<?php

// phpBB 2.x auto-generated config file
// Do not change anything in this file!

$dbms = 'mysql';

$dbhost = 'localhost';
$dbname = 'php';
$dbuser = 'phpbb';
$dbpasswd = '******';  //password for phpbb user.

$table_prefix = 'phpbb_';

define('PHPBB_INSTALLED', true);

?>

Save it, then remove the install and contrib folders and try to access it in a browser:

http://localhost/phpbb/index.php (or the correct path to your forum)

If you get errors, post the exact error message.

I made the change to the config.php file, removed the install directory and I did not have a contrib folder.

The error I get is:

The website cannot display the page        HTTP 500  
Most likely causes:
The website is under maintenance. 
The website has a programming error. 

What you can try: 
Refresh the page. 

Go back to the previous page. 

More information

This PHP file (I copied from a website and put in the same directory with the index.php) pulls the date and seems to work fine.

I put this because it seems PHP is working. The code I used for the date is

<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.0 Strict//EN" 
   "http://www.w3.org/TR/xhtml1/DTD/xhtml1-strict.dtd"> 
<html xmlns="http://www.w3.org/1999/xhtml"> 
<head> 
<title>Today's Date</title> 
<meta http-equiv="content-type"
   content="text/html; charset=iso-8859-1" /> 
</head> 
<body> 
<p>Today's Date at Quester's Guild is <?php

 echo date('l, F dS Y.'); 

?></p> 
<p> </p>
<p> </p>
<p> </p>
<p> <h1>Check for our new forums coming soon.</h1> </p>

</body> 
</html>

Sorry about the double post but I just removed everything in the forum directory and put all the files from the PHPBB3.0 zip download file (except the nice config.php file you just had me make) and I got the same results.

One other thing: in the config.php file where "$dbpasswd = '**'; //password for phpbb user. " is should I substitute the password for **? Sorry if that is a dumb question but I hate assuming then being wrong. (I tried it both ways and neither worked.)

yes, that was the idea.

Did you try the info.php file as suggested in the tutorial? If so, does it recognize and give information about MySQL? If it does, then the problem is a connection issue.

Yes, I did and it works great. I don't see anything about MySQL in the info.php.

By connection issue what do you mean and would a MySQL reinstall help or what's my next step?

I was thinking through some stuff and maybe this has something to do with what is going on here (or I could just be throwing in some unnecessary information 😕 ). I use host headers because I host several websites and as a result, the http://localhost addresses will not work for the PHPBB stuff. Do I need to change something during the MySQL setup to point to the actual address for the forums rather than localhost?

I'd be very certain that would be your trouble spot. Unfortunately I've never set up a system like you appear to have it, so don't know what to suggest. But I would certainly focus the troubleshooting on that.

I'm not making much progress with MySQL. Would you have any advice for using MSSQL Server 2000+ via ODBC since that says available?

Hello.

I followed the tute. But I am unable to pull up the info.php.

I have done everything in the posts. Tried reinstalling PHP and MySQL and still it is not pulling a page, not from localhost, nor from xxx.xxx.xxx.xxx/info.php

Any ideas why this could be?

Also. I have uninstalled PHP and MySQL 20 times. Have uninstalled the IIS service 3 times. Still I can not view the PHP page. I can't even view the localhost default page. I have went into properties and assigned it, its Static IP address, still I can not view it LAN or Public. I was able to get prompt for the un/pw, nothing worked for that either. Now it gives me a error 400 Bad Request.
I am sure I have muckeled something up, but I am unsure as to what. Lol

The PHP version I am installing is 5.25
The mySQl version I am installing is 5.0.51
I am installing it on Server 2003.

Thanks
Lesh