[prev in list] [next in list] [prev in thread] [next in thread] 

List:       mysql-odbc
Subject:    Re: need help with ODBC!
From:       Matt Fagan <m_fagan () yahoo ! com>
Date:       2004-03-23 4:44:20
Message-ID: 20040323044420.68860.qmail () web61008 ! mail ! yahoo ! com
[Download RAW message or body]

> mysql> use mysql;
> mysql> update user SET password = PASSWORD('zoom') where 
user='root';
> mysql> flush privileges;


The thing is that MyODBC 3.51 driver uses old password
authentication scheme, but mysql 4.1.1 uses new password
authentication scheme.  To access the old scheme under
4.1.1 (to keep MyODBC 3.51 happy), use OLD_PASSWORD()
instead of PASSWORD()

i.e.
mysql> update user SET password = OLD_PASSWORD('zoom')
where user='root';



Find local movie times and trailers on Yahoo! Movies.
http://au.movies.yahoo.com

-- 
MySQL ODBC Mailing List
For list archives: http://lists.mysql.com/myodbc
To unsubscribe:    http://lists.mysql.com/myodbc?unsub=mysql-odbc@progressive-comp.com

[prev in list] [next in list] [prev in thread] [next in thread]