This is a result of Tiger using MySQL 4.1, and there are several
workarounds on the MySQL site at http://dev.mysql.com/doc/mysql/en/
old-client.html. Here's the beginning of the article at that location:
" MySQL 4.1 and up uses an authentication protocol based on a
password hashing algorithm that is incompatible with that used by
older clients. If you upgrade the server to 4.1, attempts to connect
to it with an older client may fail with the following message:
shell> mysql
Client does not support authentication protocol requested
by server; consider upgrading MySQL client"
I used the second workaround (ref: UPDATE and FLUSH PRIVILEGES) with
success.
George
On Jul 30, 2005, at 10:11 PM, Alan Golub wrote:
I've been toying around with the Database Query Builder lately, thinking
about writing a tutorial for new users. I've used it in the past with
PostgreSQL 8, connecting to localhost without any problems. But for
the sake
of a tutorial, I thought I'd go with MySQL, which seems to be far more
popular, and for Mac OS X at least, much easier to install now that
MySQL AB
provides native OS X installers.
But I can't seem to connect to MySQL from DQB. I've checked and double
checked the host, user name, password, database name, and port
number, all
without success. 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."
The client fields are definitely correct (I'm using them to connect
to the
server from other GUI MySQL tools). I'm using Revolution Studio 2.6 and
MySQL 4.1.13 on Tiger 10.4.2.
Any thoughts or workarounds?
Thanks-
Alan Golub
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your
subscription preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
_______________________________________________
use-revolution mailing list
[email protected]
Please visit this url to subscribe, unsubscribe and manage your subscription
preferences:
http://lists.runrev.com/mailman/listinfo/use-revolution
