remote mySQL connection not working

[Mark Schonewille]

Hi Ton,

Before you do anything else, call your ISP and ask if a direct connection is allowed. Very many ISP's only allow connections from applications running on the same server (such as Apache and Perl).

If your ISP does allow direct remote connections, make sure that you have set up a username and password correctly for your database. It is weird that the error says "using password: NO". Usually, you need to configure a server to explicitly assign a user to a database.

--
Best regards,

Mark Schonewille

Economy-x-Talk Consulting and Software Engineering
Homepage: http://economy-x-talk.com
Twitter: http://twitter.com/xtalkprogrammer
KvK: 50277553

New: Download the Installer Maker Plugin 1.6 for LiveCode here http://qery.us/ce

On 22 feb 2011, at 14:02, tkuypers at telenet.be wrote:

> A very strange thing is happening when connecting to a mySQL database.
> going to my localhost on my Mac, no problems logging in, but when I try to connect to my remote mySQL server, I keep on getting the error "Access denied for user 'intelli-pubs'@'94-224-36-65.access.telenet.be' (using password: NO)"
> 
> My first reaction was running the "old_password" command on the server (SET PASSWORD FOR 'intelli-pubs'@'%' = OLD_PASSWORD('xxxxxxx');) but that didn't solve the problem.
> 
> Who can shine a light on this, any reaction is welcome, because I'm completely stuck :-(
> 
> 
> Warm regards,
> 
> Ton Kuypers