| Open MySQL Workbench |
 |
 |
|
| Open Preferences |
Under Edit click Preferences:
|
 |
|
| Untick Safe Updates |
When the window opens, click on "SQL Editor" in the tree on the left. Scroll down to find the "Safe Updates" checkbox, untick this box and click OK: 
|
 |
|
| Open Local Instance |
Double click on the shown local instance: Enter the root password created during installation and click OK: 
|
 |
|
| Open Options File |
Under "INSTANCE" click "Options File":
|
 |
|
| Update character-set-server |
In the General tab, under the International section, tick and update "character-set-server" with the following: utf8mb4 
|
 |
|
| Update collation-server |
In the General tab, under the International section, tick and update "collation-server" with the following: utf8mb4_unicode_ci 
|
 |
|
| Untick general_log_file |
Open the Logging tab Under the General section, untick "general_log_file": 
|
 |
|
| Set binlog-format to MIXED |
In the Logging tab, under the BinlogOptions section, tick and set the "binlog-format" value to "MIXED":
|
 |
|
| Increase innodb_log_file_size value |
Open the InnoDB tab: Under the Logfiles section, set the "innodb_log_file_size" value to "256M": Please note: This is a recommended value, it may need to be increased if blob files being inserted into the database exceed this value.  |
 |
|
| Increase max_allowed_packet value |
Open the Networking tab:
|
 |
|
| Set net_buffer_length value |
In the Networking tab, under the Data / Memory size section, tick "net_buffer_length" and set the value to "1048576":
|
 |
|
| Increase max_connections value |
In the Networking tab, under the Advanced section, set the value of "max_connections" to "2048":
|
 |
|
| Apply changes |
When finished, click Apply in the bottom left and the following window will appear: Click Yes to the following popup to complete making changes: 
|
 |
|
| Open Startup / Shutdown |
Under the Instance section, click "Startup / Shutdown":  The following pane will appear:  |
 |
|
| Click Stop Server |
Click Stop server and wait for the server check to complete:
|
 |
|
| Click Start Server |
Click Start Server, and wait until the green "running" has appeared:
|
MySQL Options for 3.3
Updated on December 9th, 2022
