Questions tagged [mysql-workbench]

A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.

Filter by
Sorted by
Tagged with
-1 votes
0 answers
33 views

MySQL backup SQL contains wrong creation order

I have created a full backup SQL file from a production database (v8.0.32) using the official mysqlbackup tool with default parameters. I tried to restore it on a localhost MySQL server using MySQL ...
Nestor's user avatar
  • 101
0 votes
0 answers
12 views

Error when trying to import csv file as a table into MySQL Workbench

I get the following error when trying to import a CSV file as a table (even if I change the encoding to latin1 or latin2):
matecito_caliente's user avatar
0 votes
1 answer
25 views

MySQL Workbench - How to write a script to delete a connection?

I currently have MySQL Workbench 8.0.33 (and tried .34) and in both cases, I have a database connection that is corrupted. When I attempt to click "delete" on it, MySQL Workbench closes ...
klewis's user avatar
  • 101
-1 votes
1 answer
46 views

Problem on MYSQL WORKBENCH Connection

Your connection attempt failed for user 'dudu' to the MySQL server at 127.0.0.1:3306: Acess denied for user 'dudu@'localhost in linux debian booworm, installed mariadb and mysql
Eduardo dos Santos's user avatar
0 votes
0 answers
41 views

Importing data into schema: Row import failed with error: ('Cannot add or update a child row: a foreign key constraint fails

Every time I get to the importing phase after I have created my schema, the fact table will fail to import anything. It has something to do with the foreign key constraint, obviously, but I cannot ...
LincolnM's user avatar
0 votes
1 answer
333 views

Importing CSV File into MySQL gives UnicodeDecodeError

I'm trying to import a CSV file into the insert tab of a MySQL database model. Importing the file gives the following error: Error during data import: UnicodeDecodeError("'ascii' codec can't ...
SlowlySwift's user avatar
1 vote
1 answer
46 views

What is the best way to document old complex SQL tables?

we have a developer retiring this year and we are trying to make sure we have the knowledge to continue business as usual. There are tons of complex tables that tie into code/other tables, with a lot ...
Eric Warburton's user avatar
0 votes
1 answer
183 views

How does MySQL handles GROUP BY?

I'm on Windows 10, MySQL Workbench. I'm on MySQL 8.0. Here's the dataset. northwind.sql. https://pastebin.com/bMgjXvfT Objective: Write a query to get the order ID, customer's name, grand total of ...
achhainsan's user avatar
0 votes
1 answer
316 views

I can't connect MySQL (on Ubuntu 22.04 Host) connect to remote server (Ubuntu 22.04 on VMWare Guest)

I want to create new MySQL connection to remote Django server that is inside virtual machine on VMWare (located at address 127.0.0.1 on port 33061). The problem is that MySQL shows the message "...
Abstract _42's user avatar
0 votes
0 answers
28 views

MySQL Workbench Execution Problem

I install MySQL Server, and MySQL Workbench. I try to run the Workbench, and an error window appears with the title:
Erick Fabio's user avatar
0 votes
0 answers
36 views

Workbench crashes on schema comparison for a particular database

I want to compare schema for two environments by using the Workbench database compare functionality, For a particular database, on the final step, it just closes WorkBench with no messagebox or ...
Debaditya Mondal's user avatar
0 votes
1 answer
716 views

"0 records imported" when importing JSON file to MySQL Workbench

When I follow the Table Data Import Wizard I can see that it has successfully parsed the JSON file in the preview it provides. However, at the end, I see "0 records imported". This happens ...
zach's user avatar
  • 1
0 votes
1 answer
1k views

MySQLWorkbench - error message - Unhandled exception: 'ascii' codec can't decode byte Oxe4 in position 9: ordinal not in range (128)

I was trying to use table data import wizard to import a csv file that uses utf-8 character set, and then the following error message shows up. MySQLWorkbench - error message - Unhandled exception: '...
L_flo's user avatar
  • 1
1 vote
0 answers
85 views

MySQL Workbench Migration Wizard refuses to reverse engineer table and gives no reason why

I'm trying to migrate a database from my development machine to the staging environment using the Migration Wizard in MySQL Workbench on my development machine. The Migration Wizard is refusing to ...
Jay Bienvenu's user avatar
0 votes
0 answers
146 views

Windows 7: How to install MySQL Workbench 8.0.25 on a USB flash drive?

I need to install MySQL Workbench 8.0.25 on a Windows 7 Home Premium 64-bit. I've followed this tutorial: https://i12bretro.github.io/tutorials/0540.html with no result. I guess the Power Shell in ...
user374324's user avatar
1 vote
0 answers
95 views

Ways to reduce latency in importing data from csv files into MySQL Workbench when connected to an RDS MySQL db Instance

This question is a follow-up to this question I asked on Stack Overflow yesterday after answering my own question by creating a Aurora MySQL db Instance and establishing a connection between it and ...
Marlen's user avatar
  • 227
1 vote
0 answers
71 views

Persistent problems connecting MySQL Workbench to an AWS RDS DB

I started off my attempt to figure out how to connect my local MySQL Workbench (8.0.32) client/application to an RDS Database on my analytics team's AWS Account by asking Bing AI and this is what it ...
Marlen's user avatar
  • 227
0 votes
0 answers
48 views

MySQL Server fails to start after removal of MariaDB in MySQL Workbench

A couple of years ago I was following a tutorial that had me install MariaDB. Now, I am trying to use MySQL Workbench to manage a MySQL database. I initially tried to add a user and got an error ...
user1777296's user avatar
0 votes
1 answer
191 views

MySQL Workbench: Cloning a schema (no data) but changing the name

Trying to use the data export wizard and Data import/restore wizard to clone a DDL structure of 2 schemas, SchemaX and SchemaY. It is fine, but unless I am missing something, I can't rename the ...
cj_kai's user avatar
  • 3
0 votes
1 answer
634 views

Azure MySql - Adding AD User To MySQL DB

I am trying to add an Azure AD user to my Azure MySQL DB, so that he can authenticate using a token (instead of needing username / password). I am set as the Azure AD administrator of this DB. I am ...
Uri Shapira's user avatar
0 votes
0 answers
43 views

problem with writing a sql trigger

I'm writing a SQL trigger to whenever update the (engage_step_user_response) table (response_json) column after updated. I need to increase no of retakes that I included same table as a column. This ...
david_23's user avatar
0 votes
0 answers
77 views

mySQL workbench synchronize models removes existing foreign key constraint links

I have an existing database where the design is frequently updated (new tables, addition of columns, removal of tables/columns, etc). I initially created the database writing ddl code and saving it as ...
Jason's user avatar
  • 1
0 votes
1 answer
69 views

making query more efficient when there is a millions of row

My table consists of the following columns: job_id, event_type, timestamp, client_type, role_type, Every job_id has record of which event_type (example login, edit, delete) , what timestamp, which ...
orrie881's user avatar
1 vote
0 answers
1k views

MySQL Workbench Crash on Execute (Mac)

I'm currently using MySQL version 8.0.28 and MySQL Workbench 8.0.29 on Macbook Pro 2017. When on the most recent version of MySQL Workbench (8.0.31), Workbench started crashing whenever I went to ...
Jude Richardson's user avatar
0 votes
0 answers
36 views

create procedure function as alternative to DB timeout

So I am fairly new to sql and there is a particular query I make where the DB always timeout. I tried everything, including restarting the server. There is this table where it listed all the events ...
orrie881's user avatar
0 votes
0 answers
88 views

Can't connect to local database even with the MySql service running

Before yesterday, I had created a MySQL server and a database. I could connect via MySQL Workbench without any problem. Today, MySQL Workbench is telling me that the server is stopped and when I try ...
GoncaloCC's user avatar
0 votes
0 answers
167 views

Cannot create a new column in MySQL using workbench, why?

I am currently running linux mint. The MySQL tutorial that I am using calls for workbench GUI along with XAMPP. As usual, support for linux is crap. I had to make do with the workbench ubuntu file. ...
SM Umair's user avatar
0 votes
0 answers
8 views

How to start mysql.server in benchamark?

I just installed, in a mac M1, MySQL 8.0 (from hombrew) brew install mysql and also MySQL Workbench 8.0 Community edition. The thing is that I cannot start the server since the workbench app. There is ...
mabvmex's user avatar
0 votes
1 answer
18 views

How do you get a count for similar columns on different tables?

Newby to Mysql. I have 2 tables with similar columns that I need a count for. I can do it separately but not in the same statement. Table 1 = "Chi_crime_incidents" , Table 2 = "...
Blacksmith's user avatar
0 votes
0 answers
613 views

Getting 'Query Interrupted' error in MySQL Workbench

Using MySQL Workbench, I have created a schema called 'ijdb' within which is the table 'joke'. This table has just 3 fields - id joketext and jokedate When I type the following, I get 'query ...
SM Umair's user avatar
0 votes
0 answers
86 views

I want to simplify my sum query using loop function

I have a query to summerize my data based on month between year 2021 - next years (depend on the real date) i used simple query like this to summerize the amount monthly SUM(IF(pt.description like '%O-...
Yuyu Gaming's user avatar
1 vote
3 answers
354 views

What is best practice on creating an index?

what is the best practice on creating an index? example 1: createdd_at_indx (created_at) updated_at_indx (updated_at) OR example 2: date_indx (created_at, updated_at)
Nullified's user avatar
0 votes
1 answer
1k views

Fixing MySQL `can't reopen table` error when using WITH cte

I have this query I'm in the process of porting over from SQL Server 2019 to MySQL 8.0.29. This error can't reopen table has been driving me insane. This is a very well-known issue with a ton of ...
sqlcaveman's user avatar
0 votes
1 answer
1k views

Is the encryption of the password vault of MySql workbench secure enough?

MySql workbench stores passwords in a file called user_data.dat which is encrypted by default. But how strong is this encryption and what algorithm is used exactly? There are tools available on the ...
Maurice's user avatar
  • 137
0 votes
0 answers
550 views

MySQL Error Code 1175 even though I am using a primary key

First time posting here although I am fairly sure this specific situation hasn't already been addressed. The closest one I have found has been where someone was using their primary keys in a JOIN ...
Gavin's user avatar
  • 1
0 votes
0 answers
28 views

Is there any need of log table

I am developing an application that has database of mysql having orders and orderdetails table. order table having column orderStatus. My question is whether it is necessary to create another order ...
Sudip977's user avatar
0 votes
0 answers
112 views

phpmyadmin cannot upload and read the longblob bin file

I need to upload 20-30 MB longblob bin file to my table. I have changed the PHPMyAdmin config file: memory_limit = 128M upload_max_filesize = 100M post_max_size = 128M The first issue is after I ...
ITnewbie's user avatar
  • 111
1 vote
0 answers
395 views

What transaction isolation level prevents MariaDB from locking tables during a join?

I am using MariaDB 10.5.12. My query will join the tbl_cus table to a previous view, creating a new view. I am using MySQL Workbench with auto-commit enabled. During testing, the app connected to the ...
Joachim Rives's user avatar
0 votes
1 answer
384 views

Large MySQL data (90GB) migration

I need to migrate large mysql database to old centOS server to new centOS server. mysql file size has been more than 90GB.I have tried mysql migration tool to transfer all data but it takes long time. ...
CodeGen's user avatar
0 votes
0 answers
490 views

MySQL Workbench Migration and PostgreSQL ODBC, cannot connect

I am trying to migrate a PostgreSQL database to MySQL using the MySQL Workbench's Migration Wizard tool. I am on Debian 11 bullseye and installed MySQL Workbench 8.0.25 using Snap. It works fine, ...
Francois J's user avatar
2 votes
1 answer
6k views

Unable to connect to remote server, error message references "localhost"

I have a MySQL server instance installed on an Ubuntu machine. I have ensured that it is listening on port 3306. I have set the bind address to 0.0.0.0. I have checked that there is no firewall. I am ...
C. Denney's user avatar
  • 121
0 votes
1 answer
271 views

Organize IDB tables in subfolders in MySQL data folder

I can't seem to find the answer elsewhere, and i apologize if the question has been done before, but is it a way to force a MySQL server (community edition) to organize the idb files into subfolders ? ...
Aevr's user avatar
  • 1
5 votes
1 answer
4k views

MySQL Workbench mysqldump: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces

When using workbench on Mysql 8, I get the following error: mysqldump: Error: 'Access denied; you need (at least one of) the PROCESS privilege(s) for this operation' when trying to dump tablespaces I'...
teamcrisis's user avatar
0 votes
1 answer
404 views

How do MySQL-Workbench and mysqldump return dumps with vastly different file-sizes?

I observed that the dump of my DB done "by hand" in the CLI is a lot bigger (>800MB) than the one produced by the Workbench (v8.0) (<500MB) and I am trying to figure out why that's the ...
Wolfone's user avatar
  • 113
0 votes
0 answers
1k views

MySql Workbench not responding?

I tried to start the server , MySql Workbench shows me this error In the Services ,MYSQL80 is already running
Ahmed Ben Bettaieb's user avatar
0 votes
1 answer
347 views

SQL - Find passenger who has boarded with exactly one specific company

Cheers, I have the following entities inside my database: 1. Passenger(id,name,surname, dof) 2. Company (id, name, code) 3. Trains (id, model) 4. Company has Trains (company_id, trains_id) 5. Trip (id,...
average_discrete_math_enjoyer's user avatar
0 votes
1 answer
2k views

0 rows from the .csv (semi colon) are imported into MySQL Workbench

I am trying to import the .csv below (columns and 3 first records in txt in differenet blockquotes) into MySQL Workbench using the Table Data Import Wizard. I have tried many ways and realized that ...
transmod_kdtk's user avatar
1 vote
1 answer
2k views

why mysql only works for root user?

I'm running Linux Mint as my dev platform. Installed mysql Ver 8.0.28-0ubuntu0.20.04.3 for Linux on x86_64 ((Ubuntu)). My problem is that mysql is ONLY connectable for (system) root user, i.e. I ...
xrfang's user avatar
  • 145
-1 votes
1 answer
322 views

Mysql takes longer when using php or python compared to worbench queries

Versions: MySQL Community Server: 8.0.16 in Windows server (Configuration file: unknow) Workbench: 8.0 Problem: When I make a query through workbench, it takes 1 second but when I make a query through ...
Ignakal's user avatar
0 votes
1 answer
432 views

mysqldump stuck at connecting to localhost

System Info: mySQL version: Ver 8.0.27 for Win64 on x86_64 (MySQL Community Server - GPL) windows 10 version: 20H2 19042.1586 I am trying to create a backup of a database. When I try to run the ...
MissingMarvin's user avatar

1
2 3 4 5
11