Trouble connecting to MySQL

[Bill]

This was answered earlier here. The password system for the newer version of
Mysql is different so you have to set it to use the old version.


On 5/22/05 10:27 PM, "Terry Judd" <tsj at unimelb.edu.au> wrote:

> The time has come where I've had to start working with a backend
> database on one of my projects. Anyway, I've installed MySQL on my
> desktop for testing purposes and have set up a database with a couple
> of tables (reading a MySQL book as I go). Seems to work fine from the
> command line (although I'm stuck as 'root' user for the moment). So...
> I add some code to my rev stack to add data to my database which looks
> something like...
> 
> put revXMLText(pLogTree,"/") into tData
> -- 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","tDa
> ta"
> 
> ...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
> 
> TIA,
> 
> Terry...
> _______________________________________________
> use-revolution mailing list
> use-revolution at lists.runrev.com
> http://lists.runrev.com/mailman/listinfo/use-revolution
> 
> 

            |    |    |
           )_)  )_)  )_)
          )___))___))___)\
         )____)____)_____)\\
       _____|____|____|____\\\__
-------\                   /--------- http://www.bluewatermaritime.com
 ^^^^^ ^^^^^^^^^^^^^^^^^^^^^
  ^^^^      ^^^^     ^^^    ^^
       ^^^^      ^^^

24 hour cell: (787) 378-6190
fax: (787) 809-8426

Blue Water Maritime
P.O. Box 91
Puerto Real, PR 00740