View Single Post

   
  #2 (permalink)  
Old 02-28-2008, 11:29 AM
J.O. Aho
 
Posts: n/a
Default Re: MYSQL access is OK on Server but not from PC??

martin99 wrote:

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


To be able to connect to a local mysql server (localhost), you need to have
mysql server installed on the computer and have started teh service and of
course have the same database/tables as on the web-server.


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


This means that you aren't allowed to connect with your username/login
remotely to the sql server and I doubt your web-host will allow you, as it's
always a security risk to let people to login from a remote site, specially is
you have a dynamic ip-address.


I do suggest you visit www.distrowatch.com and download a proper OS that
allows you to select to install Apache, MySQL, PHP and a lot more during the
installation of the OS, this way you have all working by default and will keep
on working after updates.


--

//Aho
Reply With Quote