search

TablePlus / DBngin

DB Engine
https://dbngin.com
1.06k stars 19 forks source link

How Can I increase max_allowed_packet in DBngin #33

Open akirawinz opened 5 years ago

akirawinz commented 5 years ago

Please fill out the detail below, it helps me investigate the bug:

  1. Driver (Ex: PostgreSQL 10.0): mysql 5.7

  2. DBngin build number: 246

  3. macOS version: 10.14 Mojave

  4. The steps to reproduce this issue:

I import 8 00 mb in tableplus using Dbngin It said " The current max allowed package is 4194304 bytes but the statement length is 8774850.0 bytes."

I try to set global max_allowed_packet=1000000000; and SHOW VARIABLES LIKE 'max_allowed_packet'

my max_allowed_packet didnt change . Where's my.cnf file in Dbngin locate I want to change it or How can I fix this ?

technosoftgit commented 4 years ago

I need to know the path of my.cnf as well, as I want to change the global timezone

lukepearce commented 3 years ago

I need to know the path of my.cnf as well, as I want to change the global timezone

If you right click on the MySQL service, you can "Edit" and select a custom my.cnf file to use for that server.

image