DataGrip fails to connect

Completed

I am using (payed version) of DataGrip. I use it on Mac HighSierra. 

DataGrip version is 2018.1.1

Build is: DB-181.4668.2

 

I am tryint to connect via SSH to MySQL DB. Every time I get this error:

[S1000] Packet for query is too large (4739923 > 1048576). You can change this value on the server by setting the max_allowed_packet' variable.

I can't change anything on the DB server settings.

When I use MySQL workbench, I connect without problems. I am 100% certain I use same connection for the settings.

 

I dont like to use Workbench, and I like DataGrip very much.

Please help.

 

 

 

2 comments
Comment actions Permalink

Resolved the issue. I was using wrong port for connection.

 

I like your product :)

 

0
Comment actions Permalink

In My Case

 

AT FIRST:

My DB has large values for one of the tables on 2 of the columns so i need bigger packet for each query, i increased to 120,535

did not work .... so kept increasing and each time it showed me another error for another packate limit; so i kept increasing 

each time.

PROBLEM:

[2020-02-26 11:56:30] [S1000] Packet for query is too large (198,367 > 120,535). You can change this value on the server by setting the 'max_allowed_packet' variable.

[2020-02-26 11:59:04] [S1000] Packet for query is too large (6,599 > 1,205). You can change this value on the server by setting the 'max_allowed_packet' variable.

 

SOLUTION:

1

Please sign in to leave a comment.