I have found the issue.
It is talked about at the URL
http://www.mysql.com/doc/en/Password_hashing.html
The question now is When Will MyODBC support that new hashing?
Thanks
Emery
----- Original Message -----
From: "Director General: NEFACOMP" <[EMAIL PROTECTED]>
To: "abaid al-mutairy" <[EMAIL PROTECTED]>
Cc: <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]>
Sent: Saturday, November 29, 2003 13:43
Subject: Re: MyODBC and MySQL 4.1
I know how to grant privileges but the problem is with the password type of
mysql 4.1.0
After granting privileges using GRANT (in 4.1.0), I can only login using the
mysql client. But I can't use the same username and password for logging in.
Nor MyODBC will succeed.
But c:\mysql\bin\mysql.exe will login without any problem.
I think it's a compatibility issue.
Thanks
Emery
----- Original Message -----
From: abaid al-mutairy
To: Director General: NEFACOMP
Sent: Saturday, November 29, 2003 08:30
Subject: Re: MyODBC and MySQL 4.1
To create a new user use the "Grant" command from the "mysql" command
prompt:
Mysql> GRANT ALL PRIVILEGES ON *.* TO user1@'%'
-> IDENTIFIED BY 'some_pass' WITH GRANT OPTIONGRANT ALL PRIVILEGES
this will allow the "user1" with the "some_pass" to access the database
"Director General: NEFACOMP" <[EMAIL PROTECTED]> wrote:
Hi groups,
does anyone know of a way to use myODBC and connect to MySQL 4.1 using
its new passwords?
When I create a password using PASSWORD( ), I can only login using the
MySQL client (the one that comes with MySQL).
But if I create the password using OLD_PASSWORD( ), I can login from
both my applications and the MySQL client!!! Curious!!
The server says:
ERROR 1249: Client does not support authentication protocol requested by
server. Consider upgrading MySQL client.
I received this error when I used
- MySQL Front 2.5
- MySQL Control Center 0.9.2
- My Application developped in VB using MyODBC 3.51 to connect
I have not yet tried PHP.
I searched the archives but found only one people who faced the same
problem but I didn't see any message saying that he got a solution.
Or simply, is it possible to tell MySQL daemon to use OLD_PASSWORD when
encrypting passwords?
Any advice?
Thanks,
__________________________________
NZEYIMANA Emery Fabrice
NEFA Computing Services, Inc.
P.O. Box 5078 Kigali
Office Phone: +250-51 11 06
Office Fax: +250-50 15 19
Mobile: +250-08517768
Email: [EMAIL PROTECTED]
http://www.nefacomp.net/
----------------------------------------------------------------------------
--
Do you Yahoo!?
Free Pop-Up Blocker - Get it now
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
