remote mySQL connection not working
m.schonewille at economy-x-talk.com
Tue Feb 22 07:21:46 CST 2011
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.
Economy-x-Talk Consulting and Software Engineering
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
More information about the use-livecode