CODEWITHSUNDEEP
phpmysqldatabase-connection
user3852536
user3852536

Reputation: 1

php mysql connect fails even though shell client succeeds

I have a weird problem.

I'm trying to connect from a linux host to a remote MySQL server on a Windows host.

If I try to connect from shell using the mysql client it works perfectly.

#mysql -h 192.168.x.x -u MyUser -pMyPassword

I've also tried connecting from a simple python script and it works as well.

But if I try to connect from a php script it fails with a "Can't connect to MySQL server on '192.168.x.x' (13)" error.

mysql_connect ('192.168.x.x', 'MyUser', 'MyPassword');

the remote server is running 5.0.41-community-nt on Windows (no info about the OS version) the client machine is running CentOS 6.2 and is itself equipped with a MySQL 5.1.61 server. The PHP MySQL module is using the sampe API version 5.1.61

The problem MUST be inside PHP as the connection is successful from the shell client (and even from a python script) but I don't have a clue.

Any help will be higly appreciated.

Upvotes: 0

Views: 86

Answers (1)

BSeitkazin
BSeitkazin

Reputation: 3059

Use the simple PHP way to connect MySQL: 

<?php
    $link = mysql_connect('192.168.x.x', 'MyUser', 'MyPassword');
    if (!$link) {
        die('Could not connect: ' . mysql_error());
    }
    echo 'Connected successfully';
    mysql_close($link);
?>

Please, show us the full code.

Upvotes: 1

Related Questions