Posted by Jim Michaels on 02/23/06 11:04

"Tony Peardon" <rWorldDesigns@yahoo.ca> wrote in message
news:NM%Af.131778$km.52867@edtnps89...
> Hi, I'm new here, and to the whole php/sql server side of things, though I
> do have extensive client side experience. I'm trying to set up my home pc
> as a development server, and I'm only having a little bit of success.
>
> I downloaded and installed NetworkActiv Web Server 3.5, and the latest php
> and sql for my system, Windows 98 SE.
>
> I did this without any instructions, so I'm a little surprised it worked
> at
> all. The server is up, and the php works just fine, but not the SQL. I'm
> sure it's just a config error or something.
>
> From the command line, "mysqladmin -u create mydb" returns...
> C:\MYSQL\BIN\MYSQLA~1.EXE: connect to server at 'localhost' failed
> error: 'Can't connect to MYSQL server on 'localHost' (10061)
> Check that mysqld is running on localhost and that the port is 3306. You
> can
> check this by doing 'telnet localhost 3306'
>
> When I try this, I get, "Could not open a connection to localhost." So I'm
> thinking that I missed something during setup. Specifically, I've done
> nothing to let my server know I have SQL. Did this just happen when I
> installed and ran the instance configuration? does PHP need to know Where
> to
> find mySQL? Where do I set that? Could my firewall or other security
> software be interfering with the connection? Please help.
>
> ps.. anyone got a link or two for some good quick references? both for php
> and mysql.
>
> Thanks to all.
> sTony

Since you are on Win98, you can't install MySQL as a service. it will not
work. in fact, the install might be mangled. If there is no choice but to
install services, ignore that last statement. you are probably fine. you
need to start the MySQL server manually, possibly with command-line
switches. But you should have the config file sufficiently set up first so
that switches are not necessary.
then just run from an msdos prompt,
mysqld-max
from the bin directory and you should be able to connect.

it's better to tell the database to shutdown with mysqladmin (if you can)
than to do a control-c. you will likely end up with a more intact database.

>
>
>
>
>

[Back to original message]