LiveCode Forums.

Forgive me if this is an obvious question, but I'm new to mySQL (using Revolution or anything else, for that matter).

I've created and populated an mySQL database on my hosting site (one service they offer) using the host's online administrator software. I've been able to identify the host name, database name, etc., but, when I enter this into Revolution's Database Query Builder and try to connect, I get an error (65). Any ideas?

Hi jrioux,

First, use your favorite off-line MySQL client to connect to your on-line database, to make sure that you actually can access the database directly. There are hosts who simply don't allow this and force you to use PHP or other method to access the database.

If you can access your on-line database with an off-line client, you should be able to do the same with Revolution and you might want to post the syntax you are using to connect (without password of course).

Best,

Mark

Maybe it expects the password to be in MySQL 4.1/5.x format. You have two options here:
1. Adapt your password, as explained in this tip: http://www.sonsothunder.com/devres/revo ... ata004.htm
2. Modify the password settings using MySQL Administrator:
- go to tab 'Options'
- use the combobox at the top to go to the 'Security' panel
- tick the checkbox 'Use old passwords'

Hope this helped,

Jan Schenkel.