MYSQL: ERROR 2027 (HY000): Malformed Packet

Asked

Viewed 721 times

0

I am unable to connect a Mysql server remotely. The connection seems to be ok because with telnet [ip] [port] I get answer:

4.1.3b-beta-nt-max▒@\0v'[uZ,B{efSLa$,Q4N

When run by command line or Mysql Workbench 6.3

mysql -u[user] -p -h [host]

I get the same mistake ERROR 2027 (HY000): Malformed Packet

mysql tcp
  • 1

    Leads to believe that it is a Bug in this specific version, this -Beta makes me suspect that you are using a beta version of mysqlworkbench, maybe you can try to install an older version, I had some problems with Workbench and Windows, specifically in Windows7

  • Thank you very much @Guilhermenascimento! I will check it out. Write a reply, this your comment is worth points!!!!

  • Edvaldosilva as soon as you get it, let me know ;)

1 answer

-2

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

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

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

Browser other questions tagged mysql tcp

You are not signed in. Login or sign up in order to post.