Re: Error 1043 Bad handshake [In MySQL Administrator]

2004-11-17 Thread Chris Bailey
I have just installed MySQL Administrator on FreeBSD 5.2.1. I am trying to use the "Connect to MySQL Server Instance" dialog to establish a connection to a version: 4.0.22 MySQL server. I can establish a remote connection using: mysql -h hostname -p -u username databasename However, using MySQL A

Re: Error 1043 Bad handshake

2004-11-17 Thread Gleb Paharenko
Hello. A very comprehensive answer posted by Shawn Green you may read at: http://lists.mysql.com/mysql/173657 Aslo see: http://dev.mysql.com/doc/mysql/en/Programs_Known_to_Work_With_MyODBC.html May be you should really carefully read topics of documentation related to MyODBC. See: ht

Re: Error 1043 Bad handshake

2004-11-17 Thread jabbott
An answer to my own question. I have solved this problem which seems to be due to the way mysql 4.1.7 stores it's passwords. I used the mysql function OLD_PASSWORD to make mysql store it's passwords in the pre 4.1.x method. Basically the syntax is: mysql> UPDATE mysql.user SET Password = OLD

Re: Error 1043 Bad handshake

2004-11-17 Thread Gleb Paharenko
Hello. Did you use mysql client program from 4.1.7 installation? When you use it from 4.1.0 or older (on another machine) there some differences in authentication handshake. [EMAIL PROTECTED] wrote: > > I have done some looking in the archive for this but can't seem to find > anyth