Posted by Jerry Stuckle on 11/03/07 13:45

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

• Next in forum: Re: MYSQL access works on Server as LOCALHOST but not from PC?
• 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]