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