Posted by Jerry Stuckle on 11/03/07 18:12

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.
jstucklex@attglobal.net
==================

[Back to original message]