MYSQL: ERROR 2027 (HY000): Malformed packet

0

I can not connect to a MySQL server remotely. The connection seems to be ok because with telnet [ip] [port] I get response:

4.1.3b-beta-nt-max▒@
mysql -u[user] -p -h [host]
v'[uZ,B{efSLa$,Q4N

When run by command line or MySQL 6.3 Workbench

4.1.3b-beta-nt-max▒@
mysql -u[user] -p -h [host]
v'[uZ,B{efSLa$,Q4N

I get the same error ERROR 2027 (HY000): Malformed packet

    
asked by anonymous 12.08.2017 / 21:15

1 answer

-1

You need to update the password of this encrypted user with the "old_password" method (directly on the server):

SET PASSWORD FOR 'meuusuario'@'localhost' = PASSWORD('meupassword');

In this way you will be able to log in to an older version of the MysqL server, using the Workbench in the latest versions.

    
15.09.2017 / 01:24