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
-3 votes
1 answer
22 views

How to create table with default insert from another table?

I have created a table units as create table if not exists unit (SNO integer primary key auto_increment, Category varchar(20), Unit Varchar(20)) now I want to create another table supplier as create ...
0 votes
0 answers
24 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 ...
  • 1
0 votes
0 answers
24 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
9 views

Issues to connect the sql workbench

Galera, não consigo conectar ao servidor local usando o mysql, sempre que abro o programa e ponho pra conectar aparece essa mensagem.. como ja faz um tempo que usei esqueci a senha. o que piora tudo ...
0 votes
0 answers
23 views

Duration different between mysql workbench and command line

When profiling a simple insert statement, I'm seeing a massive difference in duration reported between mysql workbench and the mysql command line. Test Setup CREATE TABLE test ( id int ) ...
0 votes
0 answers
12 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 ...
  • 111
1 vote
0 answers
50 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
37 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
135 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, ...
0 votes
1 answer
552 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 ...
  • 101
0 votes
1 answer
39 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 ? ...
  • 1
1 vote
0 answers
1k 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
37 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 ...
  • 113
0 votes
0 answers
370 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
60 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
500 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
252 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 ...
  • 133
0 votes
1 answer
64 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
136 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 ...
0 votes
0 answers
15 views

GROUP BY and Clausule are making the query slow

I have a basic query, however for some reason the Group By and "ee.endereco_estado_id=1" are slowing it down, if I take either one it runs fast The cardinality is cliente - endereco NxN(Many ...
0 votes
0 answers
44 views

MySQL Workbench: I need to take sql dump and update records in a table based on values from csv

Problem statement: I've 200K records for which I need to take SQL dump and update the records in the table. The list of 200K records which needs a dump and an update is present in a csv file. Eg: ...
  • 1
1 vote
1 answer
160 views

Is there a way to create a new instance on localhost on a different port?

I would like to create a new instance on MySql and use a different port on localhost. Is that possible or MySql only runs locally on 3306? Why? I could not find any articles related to that. I am ...
0 votes
0 answers
104 views

SQLAlchemy Relationships: Row in Child Table is Dependent on Two Parent Tables

I have a Table whose row is dependent on the two parent tables. Child Table: class ClassUpdate(Base): id = Column(INTEGER(unsigned=False), name="ID", primary_key=True, nullable=False, ...
0 votes
0 answers
152 views

Cardinality for schema in MySQL workbench

I need to explain the cardinality for a schema constructed in MySQL workbench. The example is a one-to-many relationship, a country can have many cities, but a city can only belong to one country, as ...
  • 101
0 votes
1 answer
77 views

Remote db connection limits and MySQL Workbench

I have an app using a remote MySQL service and has max_user_connections set on the plans. For my pricing level, it's 30 connections. My app functions fine; all operations work. However, while MySQL ...
-2 votes
1 answer
45 views

Sql query to find column matches across tables

I have 3 tables. Within those 3 tables are the same column names: part name, supplier, part id The issue is that multiple suppliers may have the same part ID and trying to query and show if a part ID ...
  • 1
0 votes
0 answers
65 views

INSERT IGNORE INTO producing error 1109 unknown table in WHERE clause

I'm trying to create an INSERT IGNORE INTO statement, to pull user details from a new reglist table into an existing membership table, omitting rows where the email address is already in the ...
0 votes
0 answers
26 views

Unable to start MySQL server during installation

While installing MySQL installation is getting failed while starting the server and giving error "The configuration for MySQL server 8.0.27 has failed" Here I am attaching the log tab image:-...
user avatar
0 votes
1 answer
76 views

MySQL trigger communication between two tables

The problem is: I'm trying to find a value from one table where their vaccine choice is 'Janssen', I want the trigger to then copy their patient_id, the result of this will update the patient table ...
0 votes
1 answer
178 views

How can I make a bidirectional relationship between tables?

I am designing the scheme of several tables (user and Courses / Seminars / talks) in which a user can have multiple courses. These courses are in a Courses list; this part is already related; but now ...
0 votes
1 answer
318 views

MySQL WorkBench devs can't change password

I'm trying to create users for MySQL with the option for them to change the password: But when Devs connect on Workbench, they receive a message: Your password has expired. To log in you must change ...
  • 7,156
0 votes
0 answers
228 views

MySQL Workbench not showing Navigator - Users panel

I'm trying to check some permissions for users, but it semes I can't open the panel on this workbench: I can only see schemas. I Know I can Show grants to check permissions and ETC but I'm curious ...
  • 7,156
0 votes
1 answer
65 views

Create "create table and schema script" for MYSQL via workbench

I've only seen questions where to create just the database from workbench for MYSQL. on SQL SERVER we can create the table script and with all the inserts with all the data. is there a way I can't do ...
  • 7,156
3 votes
1 answer
975 views

Why am I unable to edit users privileges in MySQL Workbench

I just created this brand new database (MySQL 5.6 on Windows) and created a new admin user but now I can't modify any of the users privileges. I can click the Add Account button (notice there's one ...
  • 319
0 votes
0 answers
47 views

MySQL character set CLI and Workbench show different results

Q: Character sets shown by the MySQL CLI command lines and my MySQL workbench show different results. Why is that? I've run into MySQL 'chcp' error and cannot view my server status after updating my ...
0 votes
1 answer
2k views

1822, "Failed to add the foreign key constraint. Missing index for constraint in referenced table script [closed]

create table TruckMake( TruckMakeID char(3) NOT NULL, TruckMakeName varchar(20) NOT NULL, primary key (TruckMakeID)); create table TruckModel( TruckMakeID char(3) NOT NULL, TruckModelID char(3) NOT ...
1 vote
1 answer
212 views

MySQL is not allowing me to insert rows when I do not include a value for the auto incrementing field in the sql statement

I have set the CustomerID to auto-increment but when I try to insert with a statement like: INSERT INTO customerinfo VALUES ("Bromm@gmail.com", "De Carlo", 19) I get a response ...
0 votes
0 answers
33 views

How to run both "before" and "after" update in trigger

I need to calculate prior values in a table before the column values are updated. Basically, I have to calculate the difference between the before the update and after update values. If there is any ...
0 votes
0 answers
177 views

Mysql query browser not showing schemata (databases)

Hello, people, I'd appreciate it if you could assist me with this problem. I'm using workbench and mysql, and I have a few schemata (databases) in my sql. However, when I log in using Mysql Query ...
-1 votes
1 answer
446 views

Mysql WorkBench Community Edition won't start via terminal

When I try to run Work Bench from command Line: sudo mysql-workbench-community This happens: mkdir: cannot create directory '/run/user/0': Permission denied Warning: Schema “org.gnome.system....
  • 243
1 vote
1 answer
60 views

custom character for strings on mysql workbench

i have a string that contains both characters ' and ", i need to use this strings inside an insert. The problem is that due to those characters the strings results "splitted" therefore ...
  • 13
0 votes
1 answer
62 views

MySQL tables statistics over time

I used MySQL WorkBench to get the most used tables in the MySQL database. I went to Performance > Performance Reports > Database Schema Statistics > Schema Tables Statistics and saw all ...
1 vote
2 answers
245 views

Error Code: 1215. Cannot add foreign key constraint

I'm creating a DBSM on Mysql Workbench, but when Itry creating the last table i get an error because it can't add the foreign key, but i can't understand why since the child key has the same data type ...
  • 13
1 vote
1 answer
31 views

Stored procedure support in MySQL Workbench?

I've created a lot of stored procedures when I was using HeidiSQL on Windows. I am now on an iMAC (x64) and it doesn't look like installing HeidiSQL is an option. I've got MySQL Workbench version 8.0....
  • 149
2 votes
2 answers
946 views

Why does MySQL Workbench let me add unique indexes to primary keys?

I'm using MySQL Workbench 8.0.12 Reproduce: Create a table Create the first column id, select it as a primary key (PK) Under indexes, PRIMARY appears Back under columns, also select id as unique (UQ) ...
  • 121
0 votes
0 answers
57 views

Problem with connect mysql databases of remote

I'm getting error with connect remote mysql database. Firstly; 1-) I use windows 10 machine and my remote server also windows 10 machine. 2-) My database at locale at remote windows machine with root. ...
  • 1
0 votes
0 answers
107 views

Write the SQL code that will list only once the Physician-Person appointments

Write the SQL code that will list only once the Physician-Person appointments. In other words it will not list twice an appointment between the same physician and person Can someone help me solve this ...
  • 1
-6 votes
1 answer
63 views

Write the SQL code to find the average charge by the family medicine physicians

We need to write the script to find the average charge of physicians who specialize in "family medicine. But i'm confused on how to write this because when we look at the appointment table, where ...
  • 1
1 vote
0 answers
61 views

is there a way to dump schema tables that don't exist and ignore the ones that exist?

I am using this command to dump schema directly to a different server because the existing server don't have space left to dump the tables/schemas and then transfer to the other server: mysqldump -h ...
  • 151
0 votes
1 answer
135 views

ola.hallengren - Alternative MySQL scripts!

Having worked with MS SQL for many years and found ola.hallengren scripts incredibly useful - I find my self in a MySQL environment. Is there a MySQL alternative to ola.hallengren? - Perhaps someone ...
  • 113

1
2 3 4 5
11