Trouble connecting to MySQL from REALbasic and other third-party development tools

[Alan Golub]

I'm using MySQL 4.1.13 MAX on OS X 10.4.2.

I'm having trouble connecting to MySQL on localhost from a couple of third-party graphical client interfaces running on the same machine. I have no trouble connecting from the command line using mysql. I also have no trouble connecting using Navicat 2005. But trying to connect to the same db server from REALbasic just doesn't work. I also use a development tool called Revolution Studio 2.6, which provides a graphical client for connection to databases, and it also doesn't work. Both of these tools connect to PostgreSQL and OpenBase just fine -- it's only MySQL that doesn't seem to work.

I've confirmed the host, user name, password, database name, and port number, all without success. In Revolution, I keep getting the following error message:

"There was an error in connecting to the database. Please check that the connection fields are correct. Revdb error: Client does not support authentication protocol requested by server, consider upgrading MySQL client."

Any thoughts or workarounds?

Thanks-
Alan Golub