Connectivity with MySQL windows 2k

[ScottCybak]

Here's the scoop.

I mangaged to get PHP working in windows 2000. I managed to get MySQL installed on the box, and now, i'm trying to use php to connect to a MySQL database locally.

i can't get the:

$link = mysql_connect ("C:/mysql/bin/mysqld-nt.exe", "myusername", "mypassword"

to work.

i tried, just c:/mysql, and c:/mysql/bin, to no avail..

what am i doing wrong?

TIA Scott Cybak
scott@athree.com

 

[vcherubini]

Ok, the reason that is not working is you are not putting the name of the host as the first argument in the mysql_connect() function. The first argument is the server, not the location of the mysql exe.

So change
[tt]
$link = mysql_connect ("C:/mysql/bin/mysqld-nt.exe", "myusername", "mypassword"
[/tt]

to this
[tt]
$link = mysql_connect ("localhost", "myusername", "mypassword"
[/tt]

Hope this helps.

-Vic vic cherubini
krs-one@cnunited.com

http://www.cnunited.com

====
Knows: Perl, HTML, JavScript, C/C++, PHP, Flash
====

 

[inlandpac]

also, remember to have mysql running as a service since you are on win2000 (c:\mysql\bin\winmysqladmin.exe)

Just run this app and go through the initial setup process (about 30 seconds to generate the my.ini file).

Chad. ICQ: 54380631

 

[ScottCybak]

Thanks for the 'localhost' tip, worked like a charm.. i now have the ability to use mysql to generate more errors on top of PHP's



Thanks fellas Scott Cybak
scott@athree.com