Posted by The Natural Philosopher on 11/03/07 14:46

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.

[Back to original message]