revOpenDatabase - can't connect

[Mark Schonewille]

Hi Dan,

Although it looks like you can access your database directly, you might want to check with the hosting company that this is meant to be possible.  

Try creating a new database user in CPanel (if that's what you use) and make sure it has the right permissions.

Which version of Revolution/LiveCode do you use?

For a customer, I created a PHP library that lets you connect to the database from LiveCode directly. I could do the same for you if other options aren't going to work. Here http://qery.us/2gv is some more info.

--
Best regards,

Mark Schonewille

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

Economy-x-Talk is looking for an amateur painter/cartoonist/poet etc. Contact me http://qery.us/du

The Economy-x-Talk office is closed from 30 August until 4 September 2012.

On 14 aug 2012, at 00:04, Dan Friedman wrote:

> Greetings!
> 
> I am trying to connect to a mySQL database on a couple of remote websites.  I can connect to them via a php script run from the server so tDatabaseAddress is "localhost".  However, every attempt to connect via LiveCode (in the IDE) fails.  I have checked with the host that the address I am using is correct.
> 
> put revOpenDatabase("MySQL", tDatabaseAddress, tDatabaseName, tDatabaseUser, tDatabasePassword) into tResult
> 
> All params have been confirmed correct.  But, it still fails with this error:
> 
> Unable to connect to the database
> Access denied for user 'xxxx'@'xx.xx.xxx.xxx' (using password: YES)
> 
> or
> 
> Unable to connect to the database
> Can't connect to MySQL server on 'webXX.thehost.com' (60)
> 
> 
> Any advice?
> 
> -Dan