Following the instructions in Beginning PHP for installing the AMP trio, I managed to get everything installed with a minimum of hairpulling (Abriasoft AMP was previously loaded on this machine, and it leaves php.ini and my.cnf behind when uninstalled; that caused a few initial errors). However, when I logoff and log back on, I can't connect to MySQL.

If I try the "mysql\bin\mysql test" command from page 22 I get the error message:

   ERROR 2003: Can't connect to MySQL server on 'localhost' (10061)

The command "NET START MySQL" gives the error:

   System error 2 has occurred.
   The system cannot find the file specified.

I get the same error message if I try to start the MySQL service via the Administrative Tools|Component Services window in the Control Panel.

The install command "mysql\bin\mysqld -install" says the service is already installed.

What do I have to do to get the service restarted?

This forum is for PHP in general, not Beginning PHP the book.

If you would like help, please provide the neccessary code from the book you are working from, as many of us do not own it.

Thank you.

----------
---Snib---
----------

<><

There is no code associated with this problem. The references to the book are merely the context in which I encountered the problem; the problem itself exists outside of that context. That problem is:

I can't restart MySQL after a logoff/logon cycle. How do I restart the MySQL service on Windows 2000?

Note: this question has been posted in the beginning PHP forum because having MySQL up and running is a common prerequisite for PHP books and tutorials; therefore, I assume others have encountered the problem.

Sorry, I misunderstood your problem.

----------
---Snib---
----------

<><

Hi, I did a google search on the error code you provided, perhaps this can be of help:
http://www.faqts.com/knowledge_base/...html/aid/20068

If not can you give us a detailed explaination of each step you followed to install everything? What OS? Which PHP? Which Apache? Which MySQL? Then step-by-step.

It doesn't matter if Beginning PHP 4 book questions are in the Beginning PHP forum, after all, this is a publisher's website.

: )
Rich

::::::::::::::::::::::::::::::::::::::::::
The Spicy Peanut Project
http://www.spicypeanut.net
::::::::::::::::::::::::::::::::::::::::::

Well, I looked at the approaches on the www.faqts.com link and did some fiddling around, but in the end I uninstalled MySQL (including some manual cleanup not covered by the uninstall process), rebooted the machine, and reinstalled. I made a few updates to the my.cnf file (which I also had made for the previous install), and everything is working now. MySQL starts automatically without errors. Go figure.

Thanks for all the help.

P.S. Is there a way to mark a topic closed out?

Just stop posting to it. It won't appear on most people's "Active Topics" list, but won't be deleted from the forums because your answer might be useful to someone searching for MySQL connectivity problems.


Take care,

Nik
http://www.bigaction.org/