Re: need help with ODBC!

> 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=gcdmo-myodbc@xxxxxxxxxxx