MySQL Forums - MySQL Workbench

Workbench running as background task after start, connect, exit (no replies)

Ron James — Tue, 17 Feb 2026 17:19:31 +0000

I’ve just installed MySQL Workbench Version 8.0.44 build 5549652 CE (64 bits) Community on Windows 11 Pro OS Build 26200.7840, Version 25H2.

I start the program, connect to a remote database and then exit the program. The program will no longer start from its shortcut. Task Manager reveals that it’s running as a background task, not as a service, just as a background task.

Killing the background task enables the program to start from its shortcut.

I did initially have MySql running as a service via xampp but I’ve subsequently uninstalled that service and rebooted. Still have the issue.

What’s going on?

Thanks in advance.

Ron James

MacBook compatbility? (no replies)

PATRICK DIXON — Fri, 13 Feb 2026 01:20:33 +0000

I am currently running WorkBench 8 on a MacBook Pro 2019 with 2.6 ghz 6core Intel i7, 16 GM RAM, 2 TB hard drive. I am considering upgrading to MacBook M4 Max 16core, 48GB RAM, 4 TB hard drive.
Will I have any compatibility issues with your application?
How do I migrate?

My SQL Workbench: Check for updates error solved in macOS (no replies)

Alex Garcia Alegre — Sun, 28 Dec 2025 03:47:55 +0000

# Fix para HTTPS en MySQL Workbench

## Problema
El módulo SSL de Python en MySQL Workbench no puede cargar `libssl.3.dylib` debido a que la aplicación usa "hardened runtime" en macOS.

Error:
```
dlopen(.../_ssl.cpython-312-darwin.so, 0x0002): Library not loaded: libssl.3.dylib
Reason: tried: 'libssl.3.dylib' (relative path not allowed in hardened program)
```

## Solución
Modificar el archivo `wb_utils_grt.py` para usar `curl` en lugar del módulo SSL de Python.

## Archivo a modificar
`/Applications/MySQLWorkbench.app/Contents/Resources/plugins/wb_utils_grt.py`

## Cambios a aplicar

### Cambio 1: Líneas ~590-600 (importación de SSL)

**ANTES:**
```python
self.is_running = True
try:
import urllib.request, urllib.error, urllib.parse
import json
import base64
import ssl
```

**DESPUÉS:**
```python
self.is_running = True
try:
import urllib.request, urllib.error, urllib.parse
import json
import base64

# Check if SSL module is available
ssl_available = False
try:
import ssl
ssl_available = True
except (ImportError, OSError):
# SSL module not available, will use curl as fallback
pass
```

### Cambio 2: Líneas ~717-760 (petición HTTPS)

**ANTES:**
```python
urllib.request.install_opener(opener)

self.json = json.load(urllib.request.urlopen("https://workbench.mysql.com/current-release";))
```

**DESPUÉS:**
```python
urllib.request.install_opener(opener)

# Try to fetch update information
url = "https://workbench.mysql.com/current-release";

# First, try using curl as it has its own SSL/TLS support
try:
import subprocess
result = subprocess.run(['curl', '-s', '-L', url],
capture_output=True,
text=True,
timeout=10)
if result.returncode == 0 and result.stdout:
self.json = json.loads(result.stdout)
else:
raise Exception("curl failed or returned empty response")
except Exception as curl_error:
# Fallback to urllib if curl fails
if not ssl_available:
raise Exception("HTTPS support is not available.\n\n"
"The SSL module cannot be loaded and curl is not available.\n"
"You can check for updates manually at:\n"
"https://www.mysql.com/downloads/workbench/";)

try:
context = ssl._create_unverified_context()
self.json = json.load(urllib.request.urlopen(url, context=context))
except AttributeError:
self.json = json.load(urllib.request.urlopen(url))
except urllib.error.URLError as e:
error_msg = str(e)
if 'unknown url type: https' in error_msg or 'CERTIFICATE_VERIFY_FAILED' in error_msg:
raise Exception("HTTPS support is not available.\n"
"You can check for updates manually at:\n"
"https://www.mysql.com/downloads/workbench/";)
else:
raise
```

## Cómo funciona la solución

1. **Detección de SSL**: Intenta importar el módulo `ssl` pero captura el error sin fallar
2. **Uso de curl**: Usa `curl` (que tiene su propio soporte SSL/TLS) como método principal
3. **Fallback a urllib**: Si curl falla y SSL está disponible, intenta con urllib
4. **Mensajes claros**: Proporciona mensajes de error informativos al usuario

## Ventajas

- ✅ No requiere modificar binarios del sistema
- ✅ No requiere deshabilitar SIP
- ✅ No requiere enlaces simbólicos de bibliotecas
- ✅ Usa herramientas del sistema (curl) que tienen SSL integrado
- ✅ Mantiene compatibilidad si SSL funciona en futuras versiones

## Aplicar después de actualizar

Si MySQL Workbench se actualiza y el problema persiste, simplemente vuelve a aplicar estos cambios al nuevo archivo `wb_utils_grt.py`.

---
Fecha: 28 de diciembre de 2025

Trying to install MySQL WorkBenck Community 8.0.44 on Debian 13 Trixie from sources (no replies)

Leandro Caplan — Wed, 29 Oct 2025 02:28:44 +0000

Hi there!

I'm following the instructions from INSTALL file for building on Linux on Debian 13 Trixie, and I'm getting this:

leandro@Leandro:~/Descargas/mysql-workbench-community-8.0.44-src$ sudo apt-get remove iodbc
Reading package lists... Done
Building dependency tree... Done
Reading state information... Done
Package 'iodbc' is not installed, so it will not be removed
0 upgraded, 0 newly installed, 0 to remove and 0 not upgraded.

leandro@Leandro:~/Descargas/mysql-workbench-community-8.0.44-src$ sudo apt-get install build-essential cmake cmake-data autoconf automake pkg-config libtool libzip-dev libxml2-dev \
                          libsigc++-2.0-dev libglade2-dev libglu1-mesa-dev libgl1-mesa-glx \
                          mesa-common-dev libmysqlclient-dev libmysqlcppconn-dev uuid-dev libpixman-1-dev libpcre3-dev \
                          libpango1.0-dev libcairo2-dev python-dev \
                          libboost-dev mysql-client python-pysqlite2 libsqlite3-dev \
                          swig libvsqlitepp-dev libgdal-dev libgtk-3-dev libgtkmm-3.0-dev libssl-dev \
                          libsecret-1-dev libproj-dev

Reading package lists... Done
Building dependency tree... Done
Reading state information... Done

Package libgl1-mesa-glx is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or is only available
from another source.

Package libmysqlclient-dev is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or is only available
from another source.
However, the following packages replace it:
  libmariadb-dev-compat:i386 libmariadb-dev:i386 libmariadb-dev-compat libmariadb-dev

Package mysql-client is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or is only available
from another source.
However, the following packages replace it:
  mariadb-client-compat

Package libpcre3-dev is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or is only available
from another source.

Package python-dev is not available, but is referred to by another package.
This may mean that the package is missing, has been obsoleted, or is only available
from another source.
However, the following packages replace it:
  python-dev-is-python3

E: Unable to locate package libglade2-dev
E: Package 'libgl1-mesa-glx' has no installation candidate
E: Package 'libmysqlclient-dev' has no installation candidate
E: Package 'libpcre3-dev' has no installation candidate
E: Package 'python-dev' has no installation candidate
E: Package 'mysql-client' has no installation candidate
E: Unable to locate package python-pysqlite2

Any suggestions?

Thank's a lot!
Leandro

Setting up a schema in windows localhost (no replies)

Gregary Boyles — Sun, 14 Sep 2025 06:33:10 +0000

When setting up a new connection in MySQL Workbench what to do enter for
Hostname, port and username?

127.0.0.1, 3306, root fails the connection test.
localhost, 3306, root fails the connection test.
https://localhost, 3306, root fails the connection test.

MySQL Workbench tab layout (no replies)

Andy Macy — Wed, 27 Aug 2025 15:28:46 +0000

The current behavior for the UI when the number of tabs exceeds the width of the window is to continue adding them to the right which forces me to scroll to access them. I would like it if there was an option to instead have the tabs stack vertically, creating a new row of tabs beneath the existing row when the number of tabs exceeds the width of the window. This would eliminate scrolling for me and allow me to see all open tabs at once.

Problème d'accès récurrent à MySQL avec l'utilisateur root (no replies)

molka missaoui — Thu, 07 Aug 2025 12:16:16 +0000

Bonjour,

Je me permets de vous contacter concernant un problème récurrent que je rencontre avec MySQL.

À chaque fois que je tente de me connecter avec l'utilisateur root via MySQL Workbench sur l'adresse 127.0.0.1:3306, j'obtiens l'erreur suivante :

"Access denied for user 'root'@'localhost' (using password: YES)"

J’ai vérifié les points suivants :

Le service MySQL est bien en cours d’exécution.

Le port 3306 est ouvert et accessible.

Je saisis le bon mot de passe.

Les droits d’accès semblent en ordre au moment de l’installation.

Cependant, ce problème revient régulièrement, et la seule solution temporaire que j’ai trouvée est de désinstaller complètement MySQL et de le réinstaller, ce qui est très contraignant.

Je vous contacte pour :

Obtenir une explication technique sur les causes possibles de ce problème.

Avoir une solution durable, évitant les réinstallations répétées.

Merci par avance pour votre aide.
mon mail : molka.missaoui@esprit.tn

MySQL workbench quitting automatically (no replies)

Omkar Potphode — Mon, 28 Jul 2025 15:05:30 +0000

I'm on macos 12.5.7 and whenever I click the execute single query button on "SELECT * FROM table_name;" the sql wrokbench gets automatically quitted, anyone please help

Is the MYSQL Workbench Community edition free for commercial usage? (no replies)

ARUMUGAM Natarajan — Thu, 17 Jul 2025 18:43:22 +0000

Is the MySQL Workbench Community edition free for commercial usage?

How to enable editing in results grid of MYSQL bench (no replies)

Neha SHarma — Tue, 08 Jul 2025 17:02:43 +0000

I am trying to edit the values in RESULT GRID in MYSQL Workbench of a query result - but can't see an option to edit - where to enable it in MYSQl Workbench?

Compare Schemas bug (no replies)

Matthew Baker — Wed, 02 Jul 2025 21:51:36 +0000

It appears there is a bug with the compare schemas wizard when setting the destination to model instead of keeping source as the model.

When doing the above, it prompts for two connections instead of one.

If you open a model and start the comparison with the model as the source, it only prompts for one connection.

Compare two models (no replies)

Matthew Baker — Wed, 02 Jul 2025 21:44:05 +0000

I would like to compare two models in Workbench. According to the docs this is possible, but I cant see the option to select more than one model.

https://dev.mysql.com/doc/workbench/en/wb-design-schema.html

If I open a model and choose "Database -> Compare Schemas" or "Database -> Synchronize With Any Source", the model option is only enabled on one database not both source and destination.

MySQL Workbench: Connecting to Oracle DB (no replies)

Kevin Murphy — Tue, 10 Jun 2025 15:20:26 +0000

In MySQL Workbench can I connect to a remote Oracle DB? I need to load data from an Oracle DB into a MySQL DB. When I researched this topic online there were several conflicting suggestions.

Thanks!

installation of mysql workbench (4 replies)

Chouffo Fusi Emmanuel — Wed, 18 Feb 2026 21:49:33 +0000

Does MySQL 8.0.21 still work? I have been struggling to install it, but to no avail.

How can I install MySQL Workbench?

MySQL Server v8.4 LTS - not fully supported by latest Workbench (2 replies)

YSJ Developers — Fri, 25 Jul 2025 10:48:34 +0000

Following on from my post about old Python still featuring in the latest Workbench versions - when will we see full support for Server v8.4 in Workbench?

8.4 LTS has been out for a year, surely 'it will connect but not do everything' is a poor position, for the official MySQL management tool?

Out of date Python - how to update / why is it not being updated by Oracle (1 reply)

YSJ Developers — Mon, 30 Jun 2025 15:57:32 +0000

We are getting warnings that, even on the latest version (8.0.42 CE) that it is using out of date Python 3.12 - with multiple CVEs attached to it.

If I rename the python.exe and python312.dll files, and replace with a v3.13 python.exe (and the associated python313.dll file) - workbench won't load.

Presumably, it doesn't like the lack of the 312 DLL file.
If I fudge it (leave my v3.13 python exe, but rename 313 dll to 312.dll) - that doesn't work either.

While having 3.13 exe with the 3.12 dll is letting Workbench load, it's not a proper security fix.

I would really like to know why, when a new version of Python comes out, they are not patching Workbench (I get a new version needs to tested, but when there are CVEs involved then there should be say a 2 week turnaround on releasing an updated Workbench once it's been certified tested).

Python 3.13 came out late last year from memory (according to our test web server, I updated it there early December) - so why is a version of workbench, that is weeks old, still using 3.12??

I have updated our security team, that this is beyond my control - as it's the tool which our 3rd party support use to manage data in the system.

Issue with Auto-Generated SQL for Tables Containing BIT Columns (no replies)

Harry Zhang — Fri, 25 Apr 2025 01:16:20 +0000

HI,

I would like to report an issue related to how SQL statements are auto-generated when working with tables that contain multiple BIT(1) columns.

Steps to Reproduce:

Create a table that includes more than one BIT(1) column, followed by columns of other data types.

1. Execute a query:
SELECT * FROM the_table_with_bit;

2. Edit the result by inserting new rows or updating existing ones.

3. Click on the Apply button to generate the corresponding SQL statements.

Observed Behavior:

The auto-generated SQL may omit the leading b for BIT values.

In some cases, the generated SQL applies the leading b prefix to all values, including those not of BIT type.

This behavior leads to incorrect queries or unexpected results.

Please let me know if any additional details are needed.

Regards,
Wang

Can't login to MySQL with MySQL Workbench, Authentication plugin "" couldn't be found in restricted_auth plugin list (no replies)

Antoine Beaubien — Sat, 12 Apr 2025 17:50:25 +0000

I get this message when trying to loggin in with MySQL Workbench to a MySQL server : « Authentication plugin "" couldn't be found in restricted_auth plugin list »

But in the command line mysql, I can login without problems. Here my full log:

12:25:22 [INF][ WBContext UI]: Initializing workbench context UI with these values:
base dir: /usr/share/mysql-workbench
plugin path: /usr/lib/mysql-workbench/plugins
struct path: /usr/share/mysql-workbench/grt
module path: /usr/lib/mysql-workbench/modules
library path: /usr/share/mysql-workbench/libraries
user data dir: /home/antoine/.mysql/workbench
open at start:
open type:
run at startup:
run type:
Force SW rendering: No
Force OpenGL: No
quit when done: No
12:25:22 [INF][ WBContext]: WbContext::init
12:25:22 [ERR][ python]: Error importing Python module /usr/lib/mysql-workbench/modules/wb_admin_grt.py
Unhandled exception in Python code:
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 33, in
import wb_admin_main
File "/usr/lib/mysql-workbench/modules/wb_admin_main.py", line 38, in
from wb_admin_configuration_startup import WbAdminConfigurationStartup
File "/usr/lib/mysql-workbench/modules/wb_admin_configuration_startup.py", line 30, in
from wb_log_reader import ErrorLogFileReader
File "/usr/lib/mysql-workbench/modules/wb_log_reader.py", line 103, in
from wb_server_management import SudoTailInputFile, LocalInputFile, SFTPInputFile
File "/usr/lib/mysql-workbench/modules/wb_server_management.py", line 31, in
import pipes
ModuleNotFoundError: No module named 'pipes'

Traceback:
No stack information.
NameError: Error importing Python module /usr/lib/mysql-workbench/modules/wb_admin_grt.py
Unhandled exception in Python code:
Traceback (most recent call last):
File "/usr/lib/mysql-workbench/modules/wb_admin_grt.py", line 33, in
import wb_admin_main
File "/usr/lib/mysql-workbench/modules/wb_admin_main.py", line 38, in
from wb_admin_configuration_startup import WbAdminConfigurationStartup
File "/usr/lib/mysql-workbench/modules/wb_admin_configuration_startup.py", line 30, in
from wb_log_reader import ErrorLogFileReader
File "/usr/lib/mysql-workbench/modules/wb_log_reader.py", line 103, in
from wb_server_management import SudoTailInputFile, LocalInputFile, SFTPInputFile
File "/usr/lib/mysql-workbench/modules/wb_server_management.py", line 31, in
import pipes
ModuleNotFoundError: No module named 'pipes'

12:25:22 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
12:25:22 [WRN][ grt]: /home/antoine/.mysql/workbench/connections.xml:23: link '8b5dc88a-17ba-11f0-a6a5-00163ee87780' key=owner could not be resolved
12:25:22 [WRN][ grt]: Duplicate plugin name wb.tools.cmdlineClient There is more than one plugin with the name wb.tools.cmdlineClient (in PyWbUtils and PyWbUtils).
12:25:22 [INF][ WBContext]: System info:
MySQL Workbench Community (GPL) for Linux/Unix version 8.0.41 CE build 4802116 (64 bit)
Configuration Directory: /home/antoine/.mysql/workbench
Data Directory: /usr/share/mysql-workbench
Cairo Version: 1.18.4
OS: x86_64
CPU: 8x 12th Gen Intel(R) Core(TM) i3-1215U (2496.000MHz) - 6,32GiB RAM
No video adapter info available
Distribution: Debian GNU/Linux trixie/sid

Fips mode enabled: no

12:25:22 [WRN][ mforms]: Resource file not found: sidebar_wb@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: sidebar_modeling@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: sidebar_migration@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: home_screen_close_light@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: wb_doc_model@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: wb_tile_schema_light@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: wb_tile_time_light@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: wb_tile_folder_mini_light@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: home_screen_close_light@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: wb_doc_model@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: wb_tile_schema_light@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: wb_tile_time_light@2x.png
12:25:22 [WRN][ mforms]: Resource file not found: wb_tile_folder_mini_light@2x.png
12:25:22 [WRN][ WBModule]: OS not found on supported OS list. OS string: ' x86_64'
12:25:25 [ERR][SQL Editor Form]: SqlEditorForm: exception in do_connect method: Exception: Authentication plugin '' couldn't be found in restricted_auth plugin list.
12:25:25 [ERR][ GRTDispatcher]: exception in grt execute_task, continuing: Exception: Authentication plugin '' couldn't be found in restricted_auth plugin list.
12:25:25 [ERR][ GRTDispatcher]: worker: task 'execute sql queries' has failed with error:.Authentication plugin '' couldn't be found in restricted_auth plugin list.
12:25:25 [ERR][ WQE backend]: Got an exception during connection: Authentication plugin '' couldn't be found in restricted_auth plugin list.
12:25:25 [ERR][SQL Editor Form]: SQL editor could not be connected: Authentication plugin '' couldn't be found in restricted_auth plugin list.
12:25:25 [ERR][SQL Editor Form]: Your connection attempt failed for user 'antoine' to the MySQL server at X.X.X.X:3306:
Authentication plugin '' couldn't be found in restricted_auth plugin list.

Please:
1 Check that MySQL is running on address X.X.X.X
2 Check that MySQL is reachable on port 3306 (note: 3306 is the default, but this can be changed)
3 Check the user antoine has rights to connect to X.X.X.X from your address (MySQL rights define what clients can connect to the server and from which machines)
4 Make sure you are both providing a password if needed and using the correct password for X.X.X.X connecting from the host address you're connecting from

error password management error (no replies)

sonbir kumar — Thu, 10 Apr 2025 17:02:39 +0000

While using MySQL Workbench for virtual machine multisession, I am getting a password management error for the created connection. It keeps asking to enter credentials and does not save my credentials in the connection.xml file. I also checked the deleted.dat.xml file, but after signing out of the session, the issue reappears when trying to connect to the server.

Connection Warning (Local instance MySQL92) (1 reply)

Javier Ortega — Fri, 18 Apr 2025 13:34:28 +0000

I made the typical local host and downloaded MySQL Workbench. When i tried to enter MySQL Connections for the first time it appeared the typical Password popup. I entered the password and it appeared a message saying Incompatible/nonstandard server version blablabla. The thing is that u just have to click on continue anyway but i clicked Don't show this message again and closed the popup. And it did couse i have already tried to unistall all, reset my pc enter the appdata/roaming config archives and nothing works. Someone knows any way of fixing this? I cant enter any server or nothing couse of this.

Lost Access to Server (no replies)

Michael Loney — Mon, 31 Mar 2025 16:16:48 +0000

I was experimenting, creating a new schema for my genealogy research, via the Workbech, and may have deleted a setting I shouldn't have and can no longer access the server.

My front end could see the Tables in my schema, but it included the 'information schema' as well, which I didn't want (it doesn't show in my other schema.)

It was during my attempt to remove this schema from my front end that I may have deleted something I shouldn't have (a little knowledge is a dangerous thing!!!

Now, each time I login, I get the following message:
'Your connection attempt failed for user 'root' to the MySQL server at 127.0..0.1:3306:
SELECT command denied to user 'mysql.infoschema'@'localhost' for column 'default_collaton_id' in table 'character_sets'

It would seem I deleted user 'mysql.infoschema' in error, and I'm not sure how to get it back, now I've lost access to the Workbench.

I'm hoping one of the experts on this forum knows how to get it back.

Scale Interface to usable size (no replies)

Darius Florczyk — Sat, 29 Mar 2025 16:06:41 +0000

I did a bunch of searches in this forum and google in general to no avail. How does one scale the interface to be actually usable on a high resolution monitor? The menus and the left database navigation interface font size is ridiculously tiny and does not scale with windows scaling options at all. All I can change is the editor font settings. I must to be overlooking something as can't believe that in 2025 a program is not designed to use on modern high resolution monitors.

Any ideas?

Dark Theme (3 replies)

Stephen Dawson — Fri, 04 Apr 2025 17:29:35 +0000

Hi,

I enabled dark mode (theme) on my MySQL Workbench. I see the Data Modeling feature connections do not go to white. Hence, I would like to change MySQL Workbench back to light mode (theme) on my end.

Where is the setting to change back to light mode (theme) located?

Thanks,
Stephen

When will the MySQL Workbench 8.4.4 version be released (1 reply)

andy andy — Fri, 25 Jul 2025 10:51:37 +0000

Hi DB developer Team,

As we know, MySQL Server 8.4. x has been released for a long time.
In order to better manage the new version database.
can we know when will the MySQL Workbench 8.4.4 version can be released?
thanks a lot.

Diagram for db (no replies)

Gabriel Neves — Sat, 22 Mar 2025 11:27:47 +0000

I am helping some of my colleagues with a project of them and they have some difficulties with creating their databases.

So i am looking for a way to help them create their databases from a EER diagram and import it to MySQL.

Is there anyway that i could do it, preferably by SQL reverse engineering tool?

Still see green arrows after synchronization (no replies)

Jonathan Ross — Tue, 18 Mar 2025 17:33:37 +0000

I use Database > Synchronize Model and it completes successfully: I can see the changes in the Model successfully reflected in the database/scripts as expected. But when I go back to Database > Synchronize Model to synchronize new changes to the database and/or model, I still see the original "green arrows" from my previous synchronization. The SQL code also shows that Synchronize Model wants to apply the previous updates that already completed successfully in the previous synchronization. Many thanks for letting me know what I'm doing wrong or how to fix this.

SSH Tunnel fails (no replies)

Steven Hill — Tue, 11 Mar 2025 15:59:56 +0000

I have recently installed workbench on a new Mac mini M4 running osx 15 and I am truing to connect to an ubuntu 22.04 server running mysql 8.x.

I get the following error and google had no info...

Lost connection to MySQL server at 'reading initial communication packet', system error: 0

Any help appreciated,

Regards,

Steven

Could not connect the SSH tunnel (no replies)

mike vitale — Thu, 06 Mar 2025 18:31:02 +0000

I have two MacBooks both with SQL workbench loaded. The server connections are set up identically on both but I'm getting this error message on the new MacBook.

I've got to cpanel and verified that my ip address is set up in remote database access. I have verified the IP, username and password and still getting this error message.

Any suggestions as to what I'm missing?

default collation_connection (no replies)

Alejandro Contreras Sanchez — Thu, 27 Feb 2025 20:20:29 +0000

Hi everyone.

Recently changed the DB server collation from utf8mb4_general_ci to utf8mb4_unicode_ci, however, when accessing the DB via a workbench connection I get this:
collation_connection = utf8mb4_general_ci
collation_database = utf8mb4_unicode_ci
collation_server = utf8mb4_unicode_ci

It correctly receives everything from the server, however, it keeps the utf8mb4_general_ci.

This is corrected by running this: SET NAMES utf8mb4 COLLATE utf8mb4_unicode_ci;
What I need is to avoid this execution every time I open a new connection, as it is possible that I forget to execute this query and when interacting with the DB it is very possible to generate errors.
I have the version 8.0.41 build 4802116 CE
I have already tried to modify the option Manage Server Connections>“My connection”>Advanced>Others = sessionVariables=collation_connection=utf8mb4_unicode_ci

But this has had no effect.
Do you know how I can solve this and leave by default this collation utf8mb4_unicode_ci?

Password vault forgets password when network goes down (1 reply)

Jenny Volc — Fri, 14 Feb 2025 15:52:44 +0000

I have a slightly flaky internet connection, and when using MYSQL workbench, I occasionally lose connection to the database. Every time that happens, my saved connections which were open "forget" the password. Next time I try to connect, I need to save my password again to the vault. The passwords are normally saved to the vault, because if I have a few days where no network issues occur, everything works. This can happen 2-3 times a day. It is incredibly frustrating. Any ideas as to how to prevent this happening? I am on Windows 11, Workbench version 8.0.38