MySQL Connection problem

Tewl

I recently upgraded my server software on my pc from PHP4 to PHP5 and MySQL 4.1 to MySQL 5.0 and I am having some problems connecting to MySQL via PHP.

Warning: mysql_connect() [function.mysql-connect]: Can't connect to MySQL server on 'localhost' (10061) in C:\wwwroot\connection.php on line 2
Could not connect to MySQL at localhost.

Here is the code:

<?php
    $link = mysql_connect("localhost", "root", "pass1234") or
        die ("Could not connect to MySQL at localhost.");
    mysql_select_db("mydb", $link) or
        die ("Could not select database.");
    echo "Connect success!";
?>

Server specs:

Windows XP SP2
Apache/2.2.3 (Win32) PHP/5.2.3
MySQL 5.0

The MySQL setup was a basic MSI install with default settings.

MySQL is running and I can connect via the command prompt with the same EXACT username and password I use in the script.

I've spent a few hours searching forums and google trying to find what the problem might be but I haven't been able to find anything useful.

Crowly

Use mysql_error() to get the error message, that usually helps to narrow down whats wrong.

<?php 
    $link = mysql_connect("localhost", "root", "pass1234") or 
        die ("Could not connect to MySQL at localhost.<br />".mysql_error()); 
    mysql_select_db("mydb", $link) or 
        die ("Could not select database.<br />".mysql_error()); 
    echo "Connect success!"; 
?>

Tewl

The first line at the top is the mysql_error

mysql_errno = 2003
mysql_error = Can't connect to MySQL server on 'localhost' (10061)

Basically, I am asking what would prevent me from connecting to a non-remote database other than invalid address,username, or password.

I have tried localhost, 127.0.0.1, and my network ip address all with and without the mysql port and the error stays the same. Yet, I have no problem logging in through the console and managing the database.

Tewl

If this is of any importance I find that altho I could connect on the DOS prompt I cannot connected using "telnet localhost 3306"

genericsetup

Crowly wrote:

Use mysql_error() to get the error message, that usually helps to narrow down whats wrong.

<?php 
    $link = mysql_connect("localhost", "root", "pass1234") or 
        die ("Could not connect to MySQL at localhost.<br />".mysql_error()); 
    mysql_select_db("mydb", $link) or 
        die ("Could not select database.<br />".mysql_error()); 
    echo "Connect success!"; 
?>

I'm running Windows Server 2003 w/SP2
PHP Version 5.2.0
MySQL Version 5.0.27-community
IIS 6

I've used the FAQ here
Install FAQ (IIS6, mysql_*() functions, etc.)
http://phpbuilder.com/board/showthread.php?t=10340995

PHP appears to run okay in that some basic pages run and
the PHPINFO() runs and all seems good.

Have used the code posted by Crowly
and I get a blank web page when I load it.

I have a PHP script that tries to connect as well and it just sits there
and does not do anything either.

Have given IIS_WPG and IIS_Machinename too many rights in all locations
and still no success.

Have not fired up any registry or file monitoring tools yet but may have to
soon to see if I can find out what is going on here if no one else can assist

genericsetup

So no one else has run into this type of issue with IIS6/PHP/MySQL ?

bradgrafelman

It appears as though MySQL wasn't installed properly, or else it's not accepting TCP connections.

In your my.ini file, find the [mysqld] section. Do you see this:

# The TCP/IP Port the MySQL Server will listen on
port=3306

If not, what does your port= line say?

genericsetup

Thanks for the reply Brad.

Yes that line for port was setup correctly. It turns out that some ACL permissions on the PHP page were not set correctly.

bradgrafelman

So, did that resolve your issue? If so, don't forget to mark this thread resolved.