Questions tagged [mysql-workbench]
A visual database design tool developed by MySQL. It is the successor application of the DBDesigner4 project.
519
questions
-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 ...
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):
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 ...
-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
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 ...
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 ...
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 ...
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 ...
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 "...
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:
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 ...
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 ...
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: '...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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 ...
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 = "...
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 ...
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-...
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)
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 ...
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 ...
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 ...
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 ...
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 ...
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 ...
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. ...
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, ...
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 ...
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 ?
...
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'...
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 ...
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
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,...
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 ...
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 ...
-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 ...
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 ...