Skip to main content

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
0 votes
0 answers
30 views

Random MySql client error "got an error writing communication packets"

I have several different Linux servers running MySQL 8.0.x instances (ranging from 8.0.23 to 8.0.33). I occasionally get "error writing communication packets" from clients when connecting to ...
Alberto Pastore's user avatar
-1 votes
1 answer
59 views

Why is DATEADD function not working?

I am trying to set a default datetime value for the column "AuctionEndDate" as the datetime one month from now. I'm using sql version 8.0.36, and I wrote several attempts, including: ALTER ...
rlaivsezlt's user avatar
0 votes
1 answer
57 views

After Insert and Update Trigger on the same table

I have the following table in MySQL: CREATE TABLE `userlogtype` ( `UserLogTypeID` int NOT NULL AUTO_INCREMENT, `UserLogType` varchar(150) DEFAULT NULL, `InsertUser` varchar(100) DEFAULT NULL, `...
Steve Miller's user avatar
0 votes
0 answers
16 views

Reconnect to SSH MYSQL workbench on device that's not always online

I use workbench on a device that is not always online, every time it goes offline the only way to continue using it is by closing and opening a new connection. I use SSH connection to access MySQL on ...
YesItsMe's user avatar
  • 133
0 votes
0 answers
26 views

MySQL: Reconnect to Existing Database that I lost access to

Note I am not a programmer by trade. I have the most annoying problem ever while using MySQL 8.0, and all online resources I've seen provide zero solutions. I have one of those MySQL data directories ...
ZZ Top's user avatar
  • 1
0 votes
0 answers
72 views

Unable to connect to AWS mysql RDS instance

I created an AWS mySQL RDS instance (free tier), but i am unable to connect to it from workbench or cli. I have enabled public access to the DB while creation and allowed "All traffic" while ...
Ankit Rustagi's user avatar
0 votes
1 answer
159 views

Is There a Workaround to Reduce MySQL Table size?

Long story short. I have a MySQL database that has only one table and is around 50GB, while my drive storage is almost full and cannot get reduced. So the only way is to reduce the size of the 50GB ...
Chris921's user avatar
0 votes
0 answers
26 views

MySQL-Proxy works with HeidiSQL but not with DBeaver nor Workbench

For data analytical applications, our current development environment relies on a MySQL-Proxy (version 0.8) to connect to the MySQL data source. And the MySQL's version is 5.7.43-47-log. We noticed ...
Mike's user avatar
  • 13
0 votes
0 answers
100 views

Unable to resolve pyodbc dependency error while migrating SQL Server database to MYSQL

I am using MySQL workbench 8.0.35 to Migrate Database from SQL Server to MySQL. I have installed python 3.12.0 and pyodbc 5.0.1. When i select Start Migration in the MySQL workbench i am getting ...
pradeep3009's user avatar
0 votes
1 answer
61 views

Merging old backup in current database mysql

I have a backup database that contains data up to the specific date 27-11-2023. Currently, I have the latest version of the database with updated records. However, the issue arises when I consider ...
Muhammad Faizan Khan's user avatar
0 votes
0 answers
56 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
83 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
129 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
105 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
762 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
62 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
265 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
518 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
72 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
1 answer
1k 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
1 vote
2 answers
2k 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
  • 11
1 vote
0 answers
131 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
237 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
137 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
99 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
1 answer
571 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
1k 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
48 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
1 answer
84 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
54 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
245 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
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
92 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
466 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
2k 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
  • 147
0 votes
0 answers
883 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
  • 101
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
144 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
444 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
505 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
551 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
9k 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
368 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
473 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
458 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
2 3 4 5
11