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.
Please sign in to leave a comment.
Resolved the issue. I was using wrong port for connection.
I like your product :)
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: