TUTORIAL: How to install PHP and MySQL on IIS

April 15th, 2006, 2:28 am

Hi,

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 (remove the semi colon for this statement)

April 15th, 2006, 5:06 am

Ok part of that worked only I got an error athte bottom of the page about couldnt load php_mysql.dll so I put the ; back in there and the error wnt 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

April 15th, 2006, 5:21 am

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: http://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.

April 15th, 2006, 5:30 am

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

April 15th, 2006, 5:32 am

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.

April 15th, 2006, 5:38 am

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

April 15th, 2006, 5:53 am

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 (no semi colon)

April 15th, 2006, 6:10 am

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

April 15th, 2006, 6:44 am

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.

Here's a link that you might find useful for the install:
http://www.davidcatalano.com/articles/tech/mt-php-mysql/php_installation.php
It has the install procedures for PHP, MySQL, and phpMyAdmin. This is truly a step-by-step process. The process is similar as the one at the beginning of this post.

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

April 18th, 2006, 11:10 am

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]

[ATNO/TW]

April 18th, 2006, 11:24 am

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.

April 18th, 2006, 3:18 pm

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

[ATNO/TW]

April 18th, 2006, 6:21 pm

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.

April 19th, 2006, 12:26 pm

i have created a web forum, when i send comments to my email i recieved a error, i have attached the error picture.... if i am not worng i need to configure my smtp. but i did. still same prob. i am useing the smtp service provided by windows xp pro.. but if u know any good one plese let me know. http://www.3dbuzz.com/vbforum/attachmen ... ntid=48701

May 10th, 2006, 1:17 am

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