Posted by The Natural Philosopher on 11/03/07 17:26

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.
>

• Next in forum: Email Form Scripting Error Help
• Prev in forum: Re: Help with session count code
• Thread view: Re: MYSQL access works on Server as LOCALHOST but not from PC?

[Reply to this message]