Re: Bad Handshake in connecting MySQL 4.1.7
I believe that 4.1.0 and 4.1.1 were doing things a bit differently than 4.1.2+ , so your problem is likely caused by that. 4.1.0 wasn't a production release, I'd suggest upgrading the client. Of course, there might be something I'm missing... Chris Somashekara DM wrote: Hi all, I'm using MySQL 4.1.7 Production binary version and try to connect it from mysql 4.1.0 client. I get "ERROR 1043: Bad handshake" error on the console. I don't have problem in connecting using same version of mysql client (MySQL 4.1.7) Is there a way to fix it, please help me on it. Thanks for your time. Soma -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bad handshake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 05 February 2004 16:52, [EMAIL PROTECTED] wrote: > What version is the MySQL client? Is the user logging on remotely? 4.1.0-0 on the client. The user is logging on on the machine running MySQL. I'll check out remote login after I have it running on the server. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQFAIswBjeziQOokQnARAjjMAKCaSWlG79ehmyhQQqrdfzcRYZy8vgCfe8jk aFaRsN1ds1dE/cLlNXoaYt8= =JgSW -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bad handshake
What version is the MySQL client? Is the user logging on remotely? >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/5/04, 4:22:37 PM, Michael Satterwhite <[EMAIL PROTECTED]> wrote regarding Re: Bad handshake: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > On Thursday 05 February 2004 14:31, [EMAIL PROTECTED] wrote: > > What about if the user enters > > mysql -u -p > MySQL fails to start with the error message "Bad Handshake" > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) > iD8DBQFAIsI0jeziQOokQnARAis2AKCUe71KXczEiq78hS9bmQOHVvhk5QCfQPVX > U0ciSj8EKOLF4mbft8FyC+Y= > =7P00 > -END PGP SIGNATURE- > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bad handshake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 05 February 2004 14:31, [EMAIL PROTECTED] wrote: > What about if the user enters > mysql -u -p MySQL fails to start with the error message "Bad Handshake" -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQFAIsI0jeziQOokQnARAis2AKCUe71KXczEiq78hS9bmQOHVvhk5QCfQPVX U0ciSj8EKOLF4mbft8FyC+Y= =7P00 -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bad handshake
What about if the user enters mysql -u -p >>>>>>>>>>>>>>>>>> Original Message <<<<<<<<<<<<<<<<<< On 2/5/04, 2:22:29 PM, Michael Satterwhite <[EMAIL PROTECTED]> wrote regarding Re: Bad handshake: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > On Thursday 05 February 2004 14:14, [EMAIL PROTECTED] wrote: > > Was the user created under MySQL 4.1 or a previous version? How are you > > connecting? MySQL monitor, ODBC, JDBC, etc. ? > The user was created under 4.1. > The user is at the machine running MySQL and enters the command > mysql -p > MySQL queries the password, then issues the "Bad handshake" error. > If there is no password associated with the user, the connection is fine. > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) > iD8DBQFAIqYMjeziQOokQnARAhRZAJ9ML355fi7RWY+KHWrzyB7R34GdEACdESeT > KU0DXjc8mpP0XwKimbH4/M0= > =p0WR > -END PGP SIGNATURE- > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bad handshake
-BEGIN PGP SIGNED MESSAGE- Hash: SHA1 On Thursday 05 February 2004 14:14, [EMAIL PROTECTED] wrote: > Was the user created under MySQL 4.1 or a previous version? How are you > connecting? MySQL monitor, ODBC, JDBC, etc. ? The user was created under 4.1. The user is at the machine running MySQL and enters the command mysql -p MySQL queries the password, then issues the "Bad handshake" error. If there is no password associated with the user, the connection is fine. -BEGIN PGP SIGNATURE- Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) iD8DBQFAIqYMjeziQOokQnARAhRZAJ9ML355fi7RWY+KHWrzyB7R34GdEACdESeT KU0DXjc8mpP0XwKimbH4/M0= =p0WR -END PGP SIGNATURE- -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
Re: Bad handshake
Was the user created under MySQL 4.1 or a previous version? How are you connecting? MySQL monitor, ODBC, JDBC, etc. ? >> Original Message << On 2/5/04, 1:40:20 PM, Michael Satterwhite <[EMAIL PROTECTED]> wrote regarding Bad handshake: > -BEGIN PGP SIGNED MESSAGE- > Hash: SHA1 > OK, I've got my server running again on 4.1. I'm having a grant problem, > though (I have run the script to fix the privilege tables). > If I enable a user without a password, he can connect to the databases fine. > If I add a password to the user, he receives the message "Bad handshake" when > he enters the password. > Can anyone tell me what this means and how to fix it? > -BEGIN PGP SIGNATURE- > Version: GnuPG v1.2.2-rc1-SuSE (GNU/Linux) > iD8DBQFAIpwkjeziQOokQnARAr77AJ4ymdzq/nAigVnzGzRCmrrzCxw7+ACffrJg > P8CJLgWYX4sLwioX+2AyDRk= > =aFBO > -END PGP SIGNATURE- > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]