How Can I increase max_allowed_packet in DBngin

[akirawinz]

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]

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

[lukepearce]

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.