MySQL Forums - MySQL Workbench

MySQL Workbench 26.7.0 how to export results of query (no replies)

Antonio Errico — Fri, 25 Sep 2026 06:08:08 +0000

I've successfully installed MySQL Workbench 26.7.0 but after running a query I’m unable to export the results of a query as a CSV or Excel file. Is there a way to do this? Why button "Export result Set" is disabled?

thanks

MySQL Workbench 26.7 Connect Options for Local Infile (no replies)

Bryan Simmons — Wed, 16 Sep 2026 20:06:48 +0000

In a previous version of Workbench there was an option of OPT_LOCAL_INFILE=1 that could be added under advanced connection options. This appears to have changed with version 26.7 but I am unable to find details regarding location and syntax to apply this option in the later version.

For 26.7 there is an area under Edit Connection... -> Advanced -> Other Connection Options but the OPT_LOCAL_INFILE option is not recognized.

Is there documentation somewhere that explains this for 26.7 or does anyone known how to add this option (or equivalent)?

MySql WorkBench 26.7 Data Modeling (no replies)

Olman Núñez Peralta — Tue, 15 Sep 2026 15:42:10 +0000

Hi, in the new Workbench version (26.7) I couldn't find the option to create a data model. Is that correct? Will it be available in future releases?

How to do export/import in MySQL Workbench 26.7.0 (no replies)

Andrii Perun — Mon, 14 Sep 2026 22:12:02 +0000

I've successfully installed MySQL Workbench 26.7.0 on Ubuntu 26. But I can't see the Server view and consequently can't find an Export/Import button there.

Workbench update to 26.7.0 (1 reply)

Christian Marquardt — Fri, 11 Sep 2026 05:18:06 +0000

I update from 8.0.47 to 26.7.0
The installation was successful. The existing connections were successfully imported. Unfortunately, none of the connections are establishing a link to the database.
It is also not possible to test the connection.
There is no response; the spinning circle icon just keeps turning indefinitely.
Workbench System: Windows 11
Target database: MariaDB 10.11.14
Reinstalled version 8.0.47; it's running without problems.

Can't update expired password in Mysql Workbench (2 replies)

Don Lewis — Tue, 15 Sep 2026 13:11:09 +0000

Updating expired password in mysql workbench

Can't update password, get error every time

Password expired Please pick a new password
When enter old password and new passwords get error:
You have and error in your SQL syntax near PASSWORD('') at line 1 code 1064

mysqlworkbench version 8.0.47 community
mysql version 8.4.8-8

Assistance with MySql application and Sql server (1 reply)

EJIKE NWANKWO — Fri, 18 Sep 2026 13:32:04 +0000

Good morning all,
Please, can anybody assist me in downloading the farmers market database in SQL.
I downloaded the Mysql application but could not go further wiith the farmers data base

Problem with creating a connection to a remote database on local network (no replies)

Gregary Boyles — Wed, 03 Jun 2026 13:44:29 +0000

I am getting an access denied error if regardless of whether I use root or gregaryb as my username.

How do I fix this?

MySQL Workbench Closes when connecting database (no replies)

Arunkumar P — Fri, 01 May 2026 18:23:10 +0000

I have installed work bench with MySQL server. When I connect to Database, Workbench closes automatically.

Let me know how to create a DB.

QUESTION ABOUT FOREIGN KEY (2 replies)

Herve Anselme — Mon, 04 May 2026 10:20:22 +0000

Hello,

I use MySQL Workbench 8.0 CE for Windows.

I have a table of parameters : table PARAMS :

ParamTyp ParamNum ParamDescription
Type1 1 Description 1-1
Type1 2 Description 1-2
Type2 1 Description 2-1
Type2 2 Description 2-2
Type2 3 Description 2-3

on this table there is an index (just an ordinary index, not a primary key) on (ParamTyp, ParamNum).

I have another table of activity : table ACTIVITY :

create table ACTIVITY
(
Info1 ,
Info2 ,
MyTypeNum
) ;

Now, what I’d like to do, is :

alter table ACTIVITY add constraint FK_ACTIVITY foreign key (MyTypeNum) references PARAMS(ParamNum) where ParamTyp = 'Type1' ;

in order to make sure that ACTIVITY.MyTypeNum has a value referenced in the « Type1 » parameters ; so that ACTIVITY.MyTypeNum could only have value 1 or 2 ; but not value 3 which does not exist for PARAMS.ParamTyp = 'Type1'.

But when I try, the alter table query makes an error :

Error Code: 1064. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'where ParamTyp = 'Type1'' at line 1

Is it because it’s possible, but the syntax I used is wrong (= the alter table query should be written differently) ?
Or is it just impossible to create a foreign key on filtered datas ?

Thanks for your answer and advices.

Regards,
Herve

MySQL Workbench for Ubuntu 26.04 (no replies)

Gil W — Sat, 25 Apr 2026 13:37:15 +0000

Is there a prediction when a version of MySQL Workbench for Ubuntu 26.04 will be released?

MySQL Workbench (1 reply)

Nick Cole — Tue, 28 Apr 2026 17:28:06 +0000

Why does Workbench not allow us to DISCONNECT from a database. Connection deleted, but it still connects even if there is a connection to a different database.
ALL sql commands operate on the UNWANTED database.
There are aspects of this tool which are so useless!
Code entered in the editor, after copying from a text editor produce a sql error. yet copying the exact same code into the command line editor run fine.
Is workbench only able to connect to a single database?
It does not allow us to specify a paarticular one anyway.
This is the latest version too.

Who designed this all but useless tool? (1 reply)

Nick Cole — Tue, 28 Apr 2026 17:32:31 +0000

Why not ask for a directory of where the data is held?
Why not have a list of users to manage?
Migration task list does NOTHING, CANNOT MIGRATE withoUT SPECIFYING WHAT TO MIGRATE FROM AND TO!
How do we specify where the data is stored?
cannot connect to a previous database set up under mySQL.

Someone clearly hasn't thought through these basic functional processes.
cannot bulk load data, and neither have hundreds of other people.

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 (5 replies)

Chouffo Fusi Emmanuel — Mon, 16 Mar 2026 20:08:11 +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