Skip to content
New issue

Have a question about this project? Sign up for a free GitHub account to open an issue and contact its maintainers and the community.

By clicking “Sign up for GitHub”, you agree to our terms of service and privacy statement. We’ll occasionally send you account related emails.

Already on GitHub? Sign in to your account

MySQL Target: Connection Lost After Login (ERROR 2013 HY000) #1095

Open
vjmax opened this issue Oct 24, 2024 · 0 comments
Open

MySQL Target: Connection Lost After Login (ERROR 2013 HY000) #1095

vjmax opened this issue Oct 24, 2024 · 0 comments

Comments

@vjmax
Copy link

vjmax commented Oct 24, 2024

I have added MySQL as a target in Warpgate and was able to successfully connect using the following command:
mysql -u "admin#tagetname" --host "warpgate" --port 33306 -p

However, once I log in and attempt to run any query, I encounter the following error:

ERROR 2013 (HY000): Lost connection to MySQL server during query No connection. Trying to reconnect... Connection id: 1 Current database: *** NONE ***

Additional error details from the Warpgate logs:
02:51:05 INFO MySQL: User handshake capabilities=LONG_FLAG | PROTOCOL_41 | INTERACTIVE | SSL | TRANSACTIONS | SECURE_CONNECTION | PLUGIN_AUTH | PLUGIN_AUTH_LENENC_DATA | SESSION_TRACK | DEPRECATE_EOF username=admin#mysql session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 INFO MySQL: Authenticated username=admin credentials=password session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 INFO MySQL: Target handshake capabilities=LONG_FLAG | PROTOCOL_41 | INTERACTIVE | TRANSACTIONS | SECURE_CONNECTION | PLUGIN_AUTH | PLUGIN_AUTH_LENENC_DATA | SESSION_TRACK | DEPRECATE_EOF session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 ERROR MySQL: Target connection failed error=protocol error: handshake failed: ErrPacket { error_code: 1251, sql_state: Some("08004"), error_message: "Client does not support authentication protocol requested by server; consider upgrading MySQL client" } session=cf2e070b-b4c4-49a6-9e02-66d69529c066 client_ip=54.209.43.211 02:51:05 ERROR Session failed error=protocol error: handshake failed: ErrPacket { error_code: 1251, sql_state: Some("08004"), error_message: "Client does not support authentication protocol requested by server; consider upgrading MySQL client" }

Environment:

Warpgate version: 0.11.0
MySQL version: 8.0.39
MySQL User configuration: Root user with all privileges on all databases and tables.

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
Labels
None yet
Projects
None yet
Development

No branches or pull requests

1 participant