Posted by David on 07/07/06 08:40

On Fri, 07 Jul 2006 04:36:29 +0100, Joaquim Amado Lopes
<jal-2005@jalopes.net.nospam> wrote:

>Greetings.
>
>On Fri, 07 Jul 2006 03:25:52 +0200, David <dgold1958@yahoo.de> wrote:
>[snip]
>> I am running PHP5 with MySQL 5.0 and am using the mysqli libraries.
>>This cleared up all problems concerning this error. You need to be
>>sure to move libmysqli.dll to your /windows/system32 directory,
>>though, or you will encounter a problem with apache not finding the
>>library.
>>
>Uninstalled everything but the Apache server, installed PHP 5.1.4 and
>MySQL 5.0.22 and copied libmysqli.dll to the /windows/system32
>directory.
>
>Apache and PHP seem to be working fine (can load phpinfo) and MySQL
>monitor tells me MySQL is also running.
>But MySQL Administrator and MySQL Query Browser return the error:
>
>"Could not connect to the specified instance
>MySQL Error Number 2003
>Can't connect to MySQL server on 'localhost' (10061)"
>
>No problem pinging 127.0.0.1.
>
>Tried uninstalling everything but Apache, restart the machine and
>install everything again. No luck.
>Restarted Apache and MySQL. Same.
>
>The installation process for this software seems quite straightforward
>so I can't imagine what I missed.
>
>Any suggestions?

#

Error: 2003 (CR_CONN_HOST_ERROR)

Message: Can't connect to MySQL server on '%s' (%d)

Sounds like your MySQL server is not running using the port
expected by MySQL Administrator and MySQL Query Browser. Are you
running a firewall? If so, make sure that you open the port where the
MySQL server is running.

Can you connect to the MySQL server from the command line, since you
installed the updated software? There should be an extra icon on your
desktop for this called "MySQL Command Line Client." You will
automatically be prompted for the password that you assigned to root
when you installed MySQL 5.x.

By the way, the easiest method to get everything working--though I
have not done this myself, I suffered through my mistakes :-)--is to
install a WAMP package. http://www.wampserver.com/en/index.php, this
url will take you to a site that is recommended by a lot of people.
Also, the URL for the error messages is:
http://dev.mysql.com/doc/refman/5.0/en/error-messages-client.html.

>Thank you,
>Joaquim Amado Lopes

David

[Back to original message]