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
Re: MyODBC and MySQL 4.1
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]
MyODBC and MySQL 4.1
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/
Re: MyODBC and MySQL 4.1
Hi! On Nov 27, Director General: NEFACOMP 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? yes. --old-passwords switch. Regards, Sergei -- __ ___ ___ __ / |/ /_ __/ __/ __ \/ / Sergei Golubchik [EMAIL PROTECTED] / /|_/ / // /\ \/ /_/ / /__ MySQL AB, Senior Software Developer /_/ /_/\_, /___/\___\_\___/ Osnabrueck, Germany ___/ www.mysql.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]