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
