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 Administrator, I get the following error:
Could not connect to host 'hostname'.
MySQL Error Nr. 1043
Bad handshake
I have UPDATED the database password as suggested using the OLD_PASSWORD()
function. Still not able to establish a connection.
Any suggestions?
Thanks for your time,
cb
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_PASSWORD('newpwd') WHERE Host =
'some_host'
AND User = 'some_user';
mysql> FLUSH PRIVILEGES;
Now I seem to be able to connect.
--ja
On Wed, 17 Nov 2004, Gleb Paharenko wrote:
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.
jabbott@/stripped/ wrote:
>
> I have done some looking in the archive for this but can't seem to find anything
recent that seems to apply.
>
> I have a brand new install of 4.1.7 on a Redhat 9 box. I compiled it with:
> CFLAGS="-O3 -mcpu=pentiumpro" CXX=gcc CXXFLAGS="-O3 -mpentiumpro
-felide-constructors -fno-exceptions -fno-rtti" ./configure --prefix /usr/local/mysql
--enable-assembler --with-mysqld-ldflags=-all-static --datadir /web/data
>
> It starts just fine. This is a new install and I haven't put any data in it so
I don't think that I need to do any sort of permission fixing (Isn't that just for
migrated data?) I can connect to it via local host just fine but if I try to connect from
another machine running 4.1.? I get:
> bash-2.05$ mysql landfill -u root -p -h 192.168.1.100
> Enter password:
> ERROR 1043: Bad handshake
> bash-2.05$
>
> Any idea what I am doing wrong?
>
> --ja
--
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
