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
8 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 ? ...
user avatar
  • 1
0 votes
0 answers
52 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'...
user avatar
0 votes
1 answer
22 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 ...
user avatar
  • 113
0 votes
0 answers
26 views

MySql Workbench not responding?

I tried to start the server , MySql Workbench shows me this error In the Services ,MYSQL80 is already running
user avatar
-1 votes
0 answers
10 views

windows could not start the sql service on local computer / error 1067

I tried to start to start the mysql service but it keeps showing me this error . I tried to remove both ib_logfile0 and ib_logfile but i did not find them.
user avatar
0 votes
1 answer
34 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,...
user avatar
0 votes
1 answer
27 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 ...
user avatar
0 votes
1 answer
29 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 ...
user avatar
  • 123
0 votes
1 answer
24 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 ...
user avatar
0 votes
1 answer
37 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 ...
user avatar
0 votes
0 answers
11 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 ...
user avatar
0 votes
0 answers
9 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: ...
user avatar
  • 1
1 vote
1 answer
40 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 ...
user avatar
0 votes
0 answers
29 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, ...
user avatar
0 votes
0 answers
41 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 ...
user avatar
  • 101
0 votes
1 answer
36 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 ...
user avatar
-2 votes
1 answer
39 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 ...
user avatar
  • 1
0 votes
0 answers
23 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 ...
user avatar
0 votes
0 answers
16 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
32 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 ...
user avatar
0 votes
1 answer
94 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 ...
user avatar
0 votes
1 answer
124 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 ...
user avatar
  • 7,100
0 votes
0 answers
94 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 ...
user avatar
  • 7,100
0 votes
1 answer
24 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 ...
user avatar
  • 7,100
1 vote
1 answer
509 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 ...
user avatar
  • 279
0 votes
0 answers
11 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 ...
user avatar
0 votes
1 answer
612 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 ...
user avatar
1 vote
1 answer
62 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 ...
user avatar
0 votes
0 answers
24 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 ...
user avatar
0 votes
0 answers
83 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 ...
user avatar
-1 votes
1 answer
159 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....
user avatar
  • 243
1 vote
1 answer
32 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 ...
user avatar
  • 13
0 votes
1 answer
47 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 ...
user avatar
0 votes
0 answers
43 views

MySQL Table structure and data export - Script sequence is not correct

When I export the data and structure of my MySQL database to a file, I notice that the table sequences in the output file are not correct. For example the script of a child table is put before the ...
user avatar
  • 101
1 vote
2 answers
188 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 ...
user avatar
  • 13
1 vote
1 answer
28 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....
user avatar
  • 149
2 votes
2 answers
662 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) ...
user avatar
  • 121
0 votes
0 answers
17 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. ...
user avatar
  • 1
0 votes
0 answers
95 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 ...
user avatar
  • 1
-6 votes
1 answer
52 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 ...
user avatar
  • 1
1 vote
0 answers
30 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 ...
user avatar
  • 151
0 votes
1 answer
99 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 ...
user avatar
  • 113
1 vote
1 answer
2k views

Mysql Workbench 8 doesn't detect the my.ini file for my MySql 5.7 server. How can I point it to the correct file? [duplicate]

I upgraded MySql workbench to version 8. I'm running MySql Server 5.7. When I open the options file in workbench it says it cannot locate a file for MySql 8 and that it will create one in the path C:\...
user avatar
  • 181
0 votes
2 answers
466 views

MySQL server will not start/stop

I am currently in the process of setting up a database in MySQL for an application where I will be running PowerBI to do analyses on the data in the database and in a further stage to design an ...
user avatar
0 votes
1 answer
994 views

Why do I have to set MySQL user password with mysql_native_password to connect with Workbench?

I've noticed if I set the mysql user's password like below, I cannot connect with MySQL Workbench. ALTER USER 'root'@'localhost' IDENTIFIED BY 'myPassword' If I use this below I can connect to it: ...
user avatar
0 votes
1 answer
32 views

Handling the foreign keys in data entry

I have two tables (Order and equipment) and they should be linked together by the order No. the SQL script is as the following: -- ----------------------------------------------------- -- Table `rr`.`...
user avatar
2 votes
1 answer
425 views

MySQL Workbench shows running query but query not in process list [closed]

I am having an issue where the same query sometimes completes in 600 seconds or less, but sometimes lags for multiple hours. MySQL Workbench shows the query as 'Running...', and initially I can see ...
user avatar
1 vote
2 answers
960 views

Creating a table with CHECK constraints in MySql workbench

I created a table ORDER using Mysql Workbench as follows: CREATE TABLE IF NOT EXISTS `rr`.`ORDER` ( `Order No.` INT UNSIGNED NOT NULL COMMENT 'The order of the inspected equipment', `Order_Type` ...
user avatar
1 vote
2 answers
110 views

Can I use older MySQL workbench with newest MySQL server?

MySQL newbie here. I'm using Ubuntu 16.04 (64-bit). I've successfully installed MySQL Community Server 5.7 and MySQL Community Workbench 6.3. Unable to find these answers in the MySQL forums. I've ...
user avatar
  • 11
0 votes
2 answers
991 views

Debugging mode in MySQL Workbench

When running queries in MySQL workbench, some of them are captured to the log file at either: MySQL/Workbench/logs MySQL/Workbench/sql_history However, I'd like to see ALL the possible queries that ...
user avatar
  • 131

1
2 3 4 5
10