MySQL cannot connect to database server / No se puede conectar a servidor de base de datos


This error is happening for MySQL new version Workbench 6.3 / Sucede en MySQL versión 6.3

MySQL
Error opening database on MySQL Workbench 6.3

Problem here is the authentication method. / El problema es el método de autenticación.

By Default new workbench says: Do not send passwords to the server in old (pre-4.1) format. This prevents connections except for servers that use the newer password format. As of MySQL 5.6.7, this option is enabled by default; use –skip-secure-auth to disable it. / Por defecto el workbench dice: No enviar password al servidor en el viejo formato (pre-4.1). Esto evita conexiones para servidores que no tengan el nuevo formato de password. Desde MySQL 5.6.7 esta opción está habilitada por defecto. Use –skip-secure-auth para deshabilitarla.

So to allow you to connect to “old pre-4.1 format” you must click in the following option in the connect database dialog form: (Click on “Use the old authentication protocol”) / Entonces, para permitirle conectarse a un formato viejo “pre-4.1” debe dar clic en la siguiente opción del formulario de conectarse a base de datos: (Clic en “Use el protocolo de autenticación viejo”)

Activating old authentication method, workbench 6.3
Activating old authentication method, workbench 6.3

And this is it, now you can connect.

Y eso es todo, ahora ya se puede conectar.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s