php mysql

[Steff]

:
Bonjour

On me demande de compiler php avec le module mysql. Je travaille sous windows 2000 server. Quelqu'un peux t-il m'expliquer comment on fait?

Merci
Cordialement
Steff

[ruturajv]

French was it?
Sorry ....
Not all of us understand that!

[Steff]

Hello

Sorry, I have forget it.
I works under windows 2000 Server. We ask me to compile php with mysql module. Can you tell me how I can do this?

Thanks for your help
Cordially
Steff

[ruturajv]

Are you planning to integrate PHP with IIS 5.0 if that is the case simply download the "php installer" and thats it

Mysql : Just install with its installer
Mysql connectivity with php is ON by default

[Steff]

Thanks

I need one more time your help
How can I verify mysql module is well compiled with php?


Cordially
Steff

[ruturajv]

Try this code

Code: Select all

<?php
if ($conn = mysql_connect('your_host', 'username', 'password')) {
    echo("Connection successful, MySQL module working");
} else {
   echo ("Check hostname, username, password");
}
?>


Ideally you should know that what is the hostname, most likely 'localhost', or '127.0.0.1'
The username could be 'root' and whatever password you've assigned

If during the installation it has asked you for some password, etc
try using those![/code]

[sigix]

i think mysql,odbc modules are shipped built in php :idea:

[Steff]

Hello

Thanks for your answers.

I try a thing like this :

<?php
if ($conn = mysql_connect('localhost', 'MySqlUser', 'MySqlPwdCcom')) {
echo("Connection successful, MySQL module working");
} else {
echo ("Check hostname, username, password");
}
?>

It answers me :

Warning: mysql_connect(): Access denied for user: 'MySqlUser@127.0.0.1' (Using password: YES)
and
Check hostname, username, password

I don't understand
I take the password and the user I found in mysql.ini.
So why I have this answer?

Can you help me ?
Thanks
Cordially
Stéphane Vauclaire

[sigix]

better create a user that will connect to mysql
check mysql user creating sql commands... :arrow:

[sigix]

ok make a new user and test with that user
you can easily make new users with phpmyadmin...
and also
use this if you are on your own machine
if ($con=mysql_connect("localhost","root",""))
echo "connection made for you..."; :arrow:

[Steff]

Hello

Thanks. It works very well.

Cordially
Steff