We’re rewarding the question askers & reputations are being recalculated! Read more.

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
1
vote
0answers
654 views

MySQL Workbench - Migration Wizard - invalid option

I encountered following error during "Bulk Data Transfer" stage in MySQL Workbench Migration Wizard: Starting... Prepare information for data copy... Prepare information for data copy ...
0
votes
1answer
403 views

What is right datatype with numbers along with '-'

I know it might sound silly, I have to look up MySQL manual reference and another MySQL forum. as I could not find what is right datatype for numbers with '-' e.g '405-6444235-1711500' I'm not ...
0
votes
1answer
679 views

MySQL Workbench SSH to Google Compute Fails with “Authentication error opening SSH tunnel” - but Putty works

I am trying to connect to MySQL server hosted on google cloud compute server. I believe the issue is not MySQL authentication related, but rather SSH. MySQL workbench seems to be unable to connect on ...
0
votes
1answer
20 views

Using MySQL workbench, how to prevent new foreing key columns when modeling

I'm reverse-engineering a database and specifying relationships. MySQL workbench wants add foreign-key columns as I do this. While I see the benefit of this, I would like to turn off this default ...
0
votes
1answer
3k views

How do we express a weak entity to be dependent on another weak entity?

Perhaps I am looking at my entities as a hierarchy rather than a set of relationships; for sake of an example I have three tables: Authors Books Content Where Authors writes Books and Books contain ...
1
vote
0answers
629 views

Importing larger CSV files to an empty table in a local MySQL database

I am building a local database made up of a handful of tables. The first few worked fine using the Export/Import option on the window that comes up after right clicking on a table and selection "...
3
votes
1answer
5k views

What is an equivalent of EXCEPT(in PostgreSQL) in MySQL? [closed]

I want to find out unmatched records of two tables in MySQL.
0
votes
1answer
425 views

mysqldump: Got error: 2049: Connection using old (pre-4.1.1) authentication protocol refused (client option 'secure_auth' enabled)

I need to dump a database from a server that uses the old password hash. It's a shared server and I am unable to change the user's password to the new hash. Attempts with MySQLWorkbench fail with the ...
0
votes
1answer
50 views

Two tables, same Attributes unable to count, [closed]

I am working on Two table together for count how many SKU. As I'm able to sum them up in how much amount with no problem. but I need a count on how many QTY in SKU. I am able to get a count in SKU ...
0
votes
1answer
989 views

SHOW CREATE PROCEDURE procedure_name not showing the procedure content

Hello I'm struggling with the Issue where i have to view the stored procedure content for that i have issue the command to get the name of the Procedure mysql> SHOW PROCEDURE STATUS; +-----+-------...
2
votes
1answer
10k views

Error Code: 1215. Cannot add foreign key constraint - while creating db in mysql workbench

I created a model for this db in mysql workbench, but now when running the script to create the tables I'm getting: "Error Code: 1215. Cannot add foreign key constraint". The error pops up when it ...
0
votes
1answer
903 views

Cannot connect to Aurora RDS using workbench over ssh

I set up an environment on AWS that consists of a VPC with a private and public subnet following the instructions for Magento Quick Start: http://docs.aws.amazon.com/quickstart/latest/magento/...
1
vote
1answer
4k views

row n was truncated; it contained more data than there were input columns: only some rows

I am running the following script to load data from a .csv file on MySQL Workbench: SET foreign_key_checks = 0; LOAD DATA LOCAL INFILE "C:\\movieDB\\movie_metadata_edited.csv" INTO TABLE IMDB.TITLE ...
0
votes
0answers
37 views

MySQL- Can Dump Table From WorkBench But Not CLI

I have a table 'RawData' that which has a number of BLObs that hold a significant number of readings. Usually I have used MySQL-WorkBench (5.2.38+dsfg-3) but thought would go over to the Command Line ...
1
vote
0answers
33 views

Weird MySQL Model synchronization error

Why do I get this weird error when trying to synchronise my model with the mysql database (v5.7.19, workbench v6.3.9)? As you can see from the screenshot, table1_createdOn doesn't even have a default ...
0
votes
1answer
47 views

MySQL connection fails with one database and not the other

I have 2 databases on mysql. ge and ge_sc001. I can access both of these through my asp.net mvc application locally. Web.config <connectionStrings> <add name="GEContext_sc001" ...
1
vote
1answer
7k views

How to enable remote access to wamp mysql

I have wamp server which is installed in windows server. Since database is becoming large want to move code to other machine from there I want logon to wamp mysql. I have disabled bind-to-address ...
1
vote
2answers
2k views

How to set max user connection per database in mysql?

Hi i am new to MySQL and currently using version 5.5, currently i have one instance for MySQL, with 50 databases hosted on that instance. We have identified that per database there were fix amount of ...
5
votes
1answer
4k views

InnoDB: What does Data free mean?

I have a pretty large Mysql table, over 25GB. When extracting an overview with Table Inspector in MySQL Workbench, I noticed the field Data Free Because the textfields are not selectable, I'm posting ...
0
votes
1answer
442 views

MySQL Workbench - specify Server/User/Pass on command line?

I am currently testing Privileged Access Management solutions. I have a need to open the MySQL Workbench with a command line that specifies the server name, and user/password of the privileged account ...
2
votes
2answers
254 views

Port SQL Server data to MySQL without Workbench

When using MySQL Workbench to migrate data from SQL Server to MySQL I ran into a bug that it won't escape apostrophes. In the interim I would like to still port that data over. Is there any simple way ...
1
vote
1answer
1k views

How to disable duplicate entry checks in MySQL workbench?

I am trying to import a large database dump (~30 GB) with millions of rows. There are some duplicate rows in there for sure, and I'd like MySQL to just skip those rows and move on without giving me ...
0
votes
1answer
461 views

Beautify/reformat the SQL script button partially working [closed]

I am making my way through Murach's MySQL, 2nd Edition and I've encountered a bit of a speed bump. When writing scripts to create tables, etc., I've always been able to write scripts and with the ...
1
vote
1answer
2k views

'SSL is required but the server doesn't support it (2026)' error while making an SSL MySQL connection

I'm trying to make an SSL supported connection using MySQL Workbench 6.3.9. My OS is Windows 10 x64 and I have installed MySQL Server 5.7 x64 with OpenSSL-1.0.2L (Win64 version). I made a non-SSL ...
2
votes
1answer
1k views

Database design how to track a change on a patient row and set in a log table

I need to track any update on my patients table. The table contains the following fields: Patient ID; Name; address; phone relative name; relative phone smoker; alcoholic. Now I need to track if a ...
3
votes
1answer
165 views

How does MySQL Workbench decide what number to put in parentheses after a datatype?

I create columns in MySQL Workbench and it often puts different numbers in parentheses after datatype, e.g. I input this: Column Name Datatype: id INT account_parameters ...
6
votes
1answer
5k views

Why isn't INFORMATION_SCHEMA not displayed in the MySQL Workbench UI by default?

I am running MySQL Workbench 6.3 CE. The following is the default look of the UI: I can query the INFORMATION_SCHEMA database, but it is not shown by default under the SCHEMAS section in the ...
4
votes
1answer
1k views

mysql database connections will be migrated

I am not DBA, just use MySQL on local machine for testing my apllications. I have MySQL server with Workbench and Notifier on Windows machine. MySQL Notifier periodically shows message "mysql ...
1
vote
1answer
9k views

What is the difference between threads connected and threads running

I am trying to understand the dashboard in mysql workbench and I saw this chart on bottom left. threads connected: 149 threads running: 13 This was under a load and threads running increased as I ...
0
votes
1answer
468 views

Any program / command to see a preview of .sql dump file?

If I have [multiple] .sql dump files, is there a command or tool that would allow me to see a preview of the file ? e.g: db-preview backup.sql tables (40) ---------- - users (1200) -...
0
votes
1answer
450 views

mysqldump stops at 4GB

I'm trying to dump a MySQL (5.7) database of a about 150 GB, out of which most data (about 90 GB) is in a single table. I tried using MySQL Workbench (6.3) to do this through the GUI. The process ...
3
votes
1answer
2k views

Alternative to Dynamic SQL inside trigger?

My database has the following tables: TAG ---------------------- | tag_id | tag_name | ---------------------- TAG_VALUE: Stores values associated to each tag ----------------...
2
votes
2answers
975 views

Nested Cursors in Mysql problem with FETCH

I have the problem with my nested cursors in MySQL. My second cursor only advances 1 single record of the first courses and then shows me message indicating. Below is a sample of the response from my ...
2
votes
1answer
100 views

MySQL error message

I have a small issue here. When I go to Startup/ShutDown screen in MySQL workbench, following error message is displayed.(Please refer the image) I cannot stop the server when I press the Stop Server ...
0
votes
1answer
223 views

Restore database in workbench from a Linux file

We have a database on a Linux server. Instead of restoring using command line, can I restore it from Workbench? My backup file is in a Linux data directory.
1
vote
0answers
1k views

transaction isolation in MySQL workbench

MySQL Workbench has a bug where every new created session receives default session parameter values regardless of the server's definition for that parameter. For example, when the server's "...
1
vote
2answers
385 views

Accessing the Oracle cloud with MySQL workbench [closed]

I want to connect the Oracle instances with MySQL workbench. I do not know if it's possible or not.
0
votes
1answer
2k views

Unable to create connection on MySQL Workbench Edition in Mac?

I have installed MySQL Workbench on my Mac. I am trying to connect the MySQL. I am not able to connect. I have attached the screenshot. I am getting Access denied for user 'root'
0
votes
2answers
9k views

Updating a table from a temporary table where clause error in MySql Community

I am trying to update an existing table named "residential_summary" from a temporary table called "a". I can query the temporary table a but when I try to use it in an update statement I get Error ...
0
votes
0answers
29 views

Mysql Workbench: Renaming PK does not reflect the name change on child - How to fix?

First, I connect 2 tables with 1 to many relationship. Workbench correctly creates FK column in the child table. 1-When I change the name of the PK in the parent, the old FK name remains unchanged ...
0
votes
0answers
88 views

Accessing MySQLWorkbench Queries

Our database only has a couple of Users.Despite warnings of not opening to many tabs on MySQL Workbench (as performance tails off) one has succeeded in creating nearly 100 query tabs with the result ...
0
votes
1answer
33 views

Automatically convert views to underlying query

I've been moved onto a new project which uses numerous VIEWS in MySQL (5.7) queries. From what I understand, Views in MySQL are not the most performant and shouldn't be used for the sake of saving a ...
0
votes
1answer
81 views

Not able to login to MySQL server through MySQL workbench

I have installed MySQL 5.7 server on Linux machine and am able to login to the database within the server, but not able to connect to it from Workbench. I have disabled Iptables. Port 3306 is ...
0
votes
1answer
1k views

How to view the table structure in workbench in mysql database without quotes

I need to view the structure(i.e table scripts without quotes) of tabes from mysql work bench Thanks
1
vote
2answers
757 views

Searching all database schemas - how to use wildcards? [closed]

Using sqlworkBench I'm looking for column names. I'd like to use wild cards in my search using the below query. when I search for column "activated_at" it works but searching with wild card fails, can ...
1
vote
2answers
5k views

MySQL Workbench - how to search all columns in every table

In MySQL Workbench how do I search for a column which can be located in any schema. Basically I'm looking for a column called "notification" and I want to search all schemas for that column. Look at ...
1
vote
1answer
812 views

Key column 'FK_UserQuestion' doesn't exist in table error [closed]

I used the following syntax and keep getting the following error at the end. " Key column 'FK_UserQuestion' doesn't exist in table": CREATE DATABASE QA; CREATE TABLE QA.Users ( UserID int ...
1
vote
2answers
4k views

Install mysql-workbench failed: Requires: proj, tinyxml, python-paramiko >= 1.15.1

I am installing mysql-workbench to migrate Postgres database to Mysql. OS System Version: Red Hat Enterprise Linux Server release 7.2 (Maipo) I am installing mysql-workbench and follow these ...
0
votes
1answer
1k views

Workbench Error Code 1267 - utf8_unicode and utf8_general

I've recently just swapped all of a databases tables and columns to utf8_unicode_ci from the weird collection of about 3-5 different collations they were previously (don't ask... not my database) So, ...
-1
votes
1answer
543 views

Logical model in workbench

I have a physical data model of db in MySQL Workbench, how i can create an a logical model of this db(like in Allfusion data modeler(ERwin))? May be Sorry for my english!