MySQL on Vista

[Bill Thompson]

Has anyone tried putting MySQL on a Vista computer?

[Diabolos]

Has anyone tried putting MySQL on a Vista computer?
Yes, as part of http://www.wampserver.com/ (http://www.wampserver.com) and it works fine.

[Bill Thompson]

Cool suggestiono for Apache
Can MySQL work with IIS? (It must be able to)

I got installed thanks to revo Uninstaller.

[Cleon]

Yep, MySQL works on Vista just fine.

IIS is a web server, so you can tell it to connect to whatever DB you want; MySQL, PostgreSQL, SQL Server (of course), Oracle, Progress, whatever. If you're feeling really sadomasochistic, IIS (well, ASP) has some extensions that allow you to use SQL commands on CSV files.

[Ducky]

If you're feeling really sadomasochistic, IIS (well, ASP) has some extensions that allow you to use SQL commands on CSV files.

Why do you do this? That's just cruel. Do not foist this kind of evil upon the newbie.

[Cleon]

Why do you do this? That's just cruel. Do not foist this kind of evil upon the newbie.

He's already asking about Vista and IIS. At a certain point, evil is just a matter of degree.

[Arkan_Wolfshade]

If you're going to use MySQL, you might as well just throw Access at it.

[Bill Thompson]

I have MySQL running such that I can open a client command line and log on and make databases, tables, etc.

I wanted to do some AJAX. Doing AJAX with ASP, SQL Server, etc is not advisable since both places where I am hosting my websites do not use the Microsoft products. So I am forced to do my development with PHP and MySQL.

I just about have everything set up. I have set up IIS so that I can go to my localhost and I can test out web pages. I have PHP installed so that I can pull up the PHP setting pages.

The problem occurs when I try to bring up the MySQL database in PHP. I use this very simple PHP command:

<?php
$con = mysql_connect('localhost', 'testuser', 'testpassword');
?>

When I try to connect to the mysql database through PHP, I get this error:
http://gelsana.com/IIS%207_0%20Detailed%20Error%20-%20500_0%20-%20Internal%20Server%20Error.htm

I figure the problem must be in the settings that are in the php.ini. But it seems that my php.ini is set up for MySQL although it is not mentioned in the output when I query the phpinfo page with this code

<?php phpinfo(); ?>

Here is the result from this:
http://gelsana.com/phpinfo.htm

[Bill Thompson]

So, MySQL is no longer enabled by default, so the php_mysql.dll DLL must be enabled inside of php.ini. How is this done? I searched php.ini and I did not find php_mysql.dll.