Installation Help Please

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

Re: Installation Help Please

"Tony Peardon" 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
>

If you're starting out, you might want to stick to a more traditional server
setup, most obviously apache. :)

dave

Re: Installation Help Please

"Tony Peardon" 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.

>
>
>
>
>