Trouble connecting to MySQL

[Sarah Reichelt]

> -- 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","tD 
> ata"
>
> ..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,
Sarah