From: Sarah Reichelt <[EMAIL PROTECTED]>
Date: 23 May 2005 1:07:29 PM
To: How to use Revolution <use-revolution@lists.runrev.com>
Subject: Re: Trouble connecting to MySQL
Reply-To: How to use Revolution <use-revolution@lists.runrev.com>
-- write sessional data to ATS database
put revOpenDatabase("MySQL","localhost","ATS",<username
here>,<password here>) into pMysql
put "INSERT INTO inter
VALUES(pSession,pInit,pUser,pAddress,pLocation,tData)" into
tStatement
revExecuteSQL
pMysql,tStatement,"pSession","pInit","pUser","pAddress","pLocation","t
Data"
..problem is that it falls at the first hurdle (ie revOpenDatabase)
which returns the following error message:
'Client does not support authentication protocol requested by server;
consider upgrading MySQL client'
Meaning what? That the rev db library is out of date? I'm running
MySQL server version 4.1.11-standard on OSX.3
Hi Terry,
A few weeks ago, Dave Cragg suggested a way around this problem:
I got round this by resetting the user passwords on the newer server
using the OLD_PASSWORD function.
SET PASSWORD FOR 'some_user'@'some_host' =
OLD_PASSWORD('mypass');
HTH,
Does it what! Interestingly, the same 'problem' seem to be stopping me
connecting to the server using a MySQL client GUI (CocoaMySQL) whereas
another client (Navicat) worked no problem.
Much appreciated Sarah and Dave,
Terry...
Dr Terry Judd
Lecturer in Educational Technology (Design)
Biomedical Multimedia Unit
Faculty of Medicine, Dentistry & Health Sciences
The University of Melbourne
Parkville VIC 3052
AUSTRALIA
_______________________________________________
use-revolution mailing list
use-revolution@lists.runrev.com
http://lists.runrev.com/mailman/listinfo/use-revolution