MYSQL access works on Server as LOCALHOST but not from PC?

[martin99]

Hi,

I can run a test scrip that connects to the and it CONNECTS
successfully whilst running from the my website on the server.

$sqlhost = 'localhost';
$sqluser = 'userid';
$sqlpass = 'password';
$sqldb = 'some_dbd';

<?php
$conn=@mysql_connect($sqlhost,$sqluser,$sqlpass) OR die("Could not
cONNECT : " . mysql_errno().": ".mysql_error()."<BR>");
$rs=@mysql_select_db($sqldb, $conn) or die("Could not select the
database");
?>

<<<PROBLEM>>>

I cant seem to get access to my SQL data (on the server) via running a
PHP script locally on my PC

But when I try and change the SQLHOST from "localhost" to a real URL
(ie something like www.website.com (etc)) its does nt like and gets

Could not CONNECT : 1045: Access denied for user
'userid'@'5ac4ba15.bb.sky.com' (using password: YES)

[Jerry Stuckle]

martin99 wrote:

Hi,

I can run a test scrip that connects to the and it CONNECTS
successfully whilst running from the my website on the server.

$sqlhost = 'localhost';
$sqluser = 'userid';
$sqlpass = 'password';
$sqldb = 'some_dbd';

<?php
$conn=@mysql_connect($sqlhost,$sqluser,$sqlpass) OR die("Could not
cONNECT : " . mysql_errno().": ".mysql_error()."<BR>");
$rs=@mysql_select_db($sqldb, $conn) or die("Could not select the
database");
?>

<<<PROBLEM>>>

I cant seem to get access to my SQL data (on the server) via running a
PHP script locally on my PC

But when I try and change the SQLHOST from "localhost" to a real URL
(ie something like www.website.com (etc)) its does nt like and gets

Could not CONNECT : 1045: Access denied for user
'userid'@'5ac4ba15.bb.sky.com' (using password: YES)

Very simple. You don't have access to MySQL.

To figure out why, try asking in comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[The Natural Philosopher]

Jerry Stuckle wrote:

martin99 wrote:

>Hi,

I can run a test scrip that connects to the and it CONNECTS
successfully whilst running from the my website on the server.

$sqlhost = 'localhost';
$sqluser = 'userid';
$sqlpass = 'password';
$sqldb = 'some_dbd';

<?php
$conn=@mysql_connect($sqlhost,$sqluser,$sqlpass) OR die("Could not
cONNECT : " . mysql_errno().": ".mysql_error()."<BR>");
$rs=@mysql_select_db($sqldb, $conn) or die("Could not select the
database");
?>

<<<PROBLEM>>>

I cant seem to get access to my SQL data (on the server) via running a
PHP script locally on my PC

But when I try and change the SQLHOST from "localhost" to a real URL
(ie something like www.website.com (etc)) its does nt like and gets

Could not CONNECT : 1045: Access denied for user
'userid'@'5ac4ba15.bb.sky.com' (using password: YES)

Very simple. You don't have access to MySQL.

To figure out why, try asking in comp.databases.mysql.

Hint. Default MySql does NOT allow remote database access. Needs setting
up. At the whole database level, and possibly at user and table level.
Take your time.

[Jerry Stuckle]

The Natural Philosopher wrote:

Jerry Stuckle wrote:

>martin99 wrote:

>>Hi,

I can run a test scrip that connects to the and it CONNECTS
successfully whilst running from the my website on the server.

$sqlhost = 'localhost';
$sqluser = 'userid';
$sqlpass = 'password';
$sqldb = 'some_dbd';

<?php
$conn=@mysql_connect($sqlhost,$sqluser,$sqlpass) OR die("Could not
cONNECT : " . mysql_errno().": ".mysql_error()."<BR>");
$rs=@mysql_select_db($sqldb, $conn) or die("Could not select the
database");
?>

<<<PROBLEM>>>

I cant seem to get access to my SQL data (on the server) via running a
PHP script locally on my PC

But when I try and change the SQLHOST from "localhost" to a real URL
(ie something like www.website.com (etc)) its does nt like and gets

Could not CONNECT : 1045: Access denied for user
'userid'@'5ac4ba15.bb.sky.com' (using password: YES)

Very simple. You don't have access to MySQL.

To figure out why, try asking in comp.databases.mysql.

Hint. Default MySql does NOT allow remote database access. Needs setting
up. At the whole database level, and possibly at user and table level.
Take your time.

Hint - that's not his problem. But the folks in comp.databases.mysql
will give him the correct answer.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================

[The Natural Philosopher]

Jerry Stuckle wrote:

The Natural Philosopher wrote:

>Jerry Stuckle wrote:

>>martin99 wrote:
Hi,

I can run a test scrip that connects to the and it CONNECTS
successfully whilst running from the my website on the server.

$sqlhost = 'localhost';
$sqluser = 'userid';
$sqlpass = 'password';
$sqldb = 'some_dbd';

<?php
$conn=@mysql_connect($sqlhost,$sqluser,$sqlpass) OR die("Could not
cONNECT : " . mysql_errno().": ".mysql_error()."<BR>");
$rs=@mysql_select_db($sqldb, $conn) or die("Could not select the
database");
?>

<<<PROBLEM>>>

I cant seem to get access to my SQL data (on the server) via running a
PHP script locally on my PC

But when I try and change the SQLHOST from "localhost" to a real URL
(ie something like www.website.com (etc)) its does nt like and gets

Could not CONNECT : 1045: Access denied for user
'userid'@'5ac4ba15.bb.sky.com' (using password: YES)

Very simple. You don't have access to MySQL.

To figure out why, try asking in comp.databases.mysql.

Hint. Default MySql does NOT allow remote database access. Needs
setting up. At the whole database level, and possibly at user and
table level. Take your time.

Hint - that's not his problem.

It is.
But the folks in comp.databases.mysql

will give him the correct answer.

[Jerry Stuckle]

The Natural Philosopher wrote:

Jerry Stuckle wrote:

>The Natural Philosopher wrote:

>>Jerry Stuckle wrote:
martin99 wrote:
Hi,
>
I can run a test scrip that connects to the and it CONNECTS
successfully whilst running from the my website on the server.
>
$sqlhost = 'localhost';
$sqluser = 'userid';
$sqlpass = 'password';
$sqldb = 'some_dbd';
>
<?php
$conn=@mysql_connect($sqlhost,$sqluser,$sqlpass) OR die("Could not
cONNECT : " . mysql_errno().": ".mysql_error()."<BR>");
$rs=@mysql_select_db($sqldb, $conn) or die("Could not select the
database");
?>
>
<<<PROBLEM>>>
>
I cant seem to get access to my SQL data (on the server) via running a
PHP script locally on my PC
>
But when I try and change the SQLHOST from "localhost" to a real URL
(ie something like www.website.com (etc)) its does nt like and gets
>
Could not CONNECT : 1045: Access denied for user
'userid'@'5ac4ba15.bb.sky.com' (using password: YES)
>
>

Very simple. You don't have access to MySQL.

To figure out why, try asking in comp.databases.mysql.

Hint. Default MySql does NOT allow remote database access. Needs
setting up. At the whole database level, and possibly at user and
table level. Take your time.

Hint - that's not his problem.

It is.
But the folks in comp.databases.mysql

>will give him the correct answer.

Wrong. Find out in comp.databases.mysql.

--
==================
Remove the "x" from my email address
Jerry Stuckle
JDS Computer Training Corp.
js*******@attglobal.net
==================