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
votes
0answers
10 views

About MySQL audit select instruction triggers

Good afternoon. I have a need for a business rule in the company, where I need to audit BI users who seek customer reports, company numbers and the like. I ask. Using MySQL + RDS Is it possible to ...
1
vote
1answer
25 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
1answer
320 views

how to Import MySql Dump file in MySQLWorkBench

I have a MySQL Dump file for few objects of a database and I have to import only one table from that file in MYSQL Work Bench. My question is How can I import a dump file in MySQL Work Bench for ...
0
votes
1answer
5k views

Error Calling Python module function DbMySQLFE.connect

Migrating a database from SqlServer to Mysql using "MySQL WorkBench 6.3 CE" using ODBC data source as default methode to use to connect to the RDBMS. -> Source Selection Test connection is Successful ...
0
votes
1answer
1k 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/...
0
votes
0answers
19 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
1answer
4k views

MYSQL Workbench Column Default/Expression

MYSQL Workbench Column Default/Expression What can be put in here, I see I can put in a default value for the field Can I also put mysql statements? Or is this just for default values? For a ...
0
votes
0answers
14 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 ...
0
votes
1answer
116 views

Detect with Left Join duplicates entries and return the first value, also return sum of duplicates entries

¡Hi!, i have a case with two tables than can have a lot of matches entries and the time of fetching increases a lot. This tables can be Table A: Employees ------------------------- | Name | ID | ...
0
votes
1answer
349 views

mysql database migration of schemas with updated data and structures

I am a newbie with MySQL database dumps and am currently trying to work with data migration between a source schema and a target schema. Assuming the source schema is defined by (...
0
votes
1answer
255 views

problem to import load data infile

I am trying to load data into mysql database form text file. LOAD DATA LOCAL INFILE 'P:\file.txt' INTO TABLE table_january FIELDS TERMINATED BY '\t' ENCLOSED BY '"' LINES TERMINATED BY '\n' IGNORE 1 ...
-1
votes
1answer
13 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....
0
votes
1answer
316 views

Connection failed: No such file or directory Mysql - WSL

Sorry if i posted incorrect section. I have Windows with this WSL: PRETTY_NAME="Debian GNU/Linux 10 (buster)" NAME="Debian GNU/Linux" VERSION_ID="10" VERSION="10 (buster)" VERSION_CODENAME=buster ID=...
1
vote
1answer
25 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
2answers
2k views

Is it possible to run multiple versions of MySQL Workbench?

I'm doing an application migration from MySQL 5.5 to workbench v8... 5.5 supports MySQL Workbench up to version 6.3... However, MySQL server 5.5 only supports up to version 6.3 of the workbench. I ...
1
vote
2answers
526 views

mySQL Workbench new Connection : There is no disk in drive. Please insert disk in \Device\Harddisk2\DR2

I'm trying to migrate the data at my company from Excel to mySQL so I'm very new at this. I just installed the latest mySQL package via the standard installer and when I try a new connection (I'm ...
1
vote
1answer
1k views

MySQL Workbench Unable to Connect to Azure Databases for MySQL

When trying to connect to a MySQL database in Azure I get the following error: ERROR 2026: SSL connection error: socket layer receive error At first I thought it was a firewall/security issue but ...
4
votes
3answers
21k views

Mysql Workbench crashing when connecting

I have created an user i intend to give access to one db only. But when i try connecting with him, the program crashes. When i connect with the root user, it works. create user 'test'@'localhost'; ...
0
votes
1answer
289 views

mysql 8 datetime default throwing and error when forward engineering

I am trying to create a schema by forward engineering a model eer diagram. But its giving an error on the datetime fields when using the default current_timestamp which is allowed in mysql 8 for ...
0
votes
1answer
259 views

MySQL Workbench Model sync sql_mode

Using MySQL Work Bench, When I look at the system variables of a server I am connected to, it shows the SQL_MODE as "no engine substitution" When I open a Workbench Model, and use the "sync with any ...
2
votes
2answers
719 views

mysql workbench connection type tcp/ip over ssh with libpam-google-authenticator enabled

I'm attempting to connect to my MySQL Database using the Connection Method "Standard TCP/IP over SSH". I filled out all the SSH and MySQL connection details correctly, however I get the message: "...
0
votes
1answer
400 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
1answer
124 views

Why does this MySQL 5.6 stored procedure not compile with MySQL Workbench?

Why doesn't this MySQL 5.6 stored procedure compile with MySQL Workbench? CREATE PROCEDURE spDataLocationSetActive ( IN driveLetter varchar(1), IN active ...
0
votes
1answer
97 views

mysql workbench can't write to sql history file

I'm running mysql workbench on my local machine, connected to a remote sql server. I am able to apply changes to the database, however, I see this error every time I apply a change I can't seem to ...
1
vote
1answer
2k 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; +-----+-------...
0
votes
1answer
135 views

MySQL workbench can't deal with MariaDB's new Invisible columns

Recently upgraded to MariaDB 10.3 which has a new feature whereby we can create an invisible column like so: ALTER TABLE MyTable ADD COLUMN `TestA` INT INVISIBLE; But once I create this column, ...
0
votes
1answer
26 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 ...
4
votes
1answer
9k views

How to scatter/arrange all the tables in database model (workbench)?

I have around 71 tables and if i open them for creating a model in workbench all overlap as below If i use the auto layout under arrange section then max i can get is as below How to auto arrange ...
0
votes
1answer
2k 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
2
votes
1answer
801 views

DBForge can't connect with MySQL server, server is running

I recently installed the latest version of MySQL Server. I initialized it with --initialize-insecure so I have a "root" user with no password set. The server is running, with the command mysqld --...
0
votes
1answer
524 views

MySQL - Split results of count function into columns derived from a separate column

The title seems a bit confusing, but I am struggling to put down what I need this query to do so best to explain it. I have 3 tables in my database (Using MySQL Workbench), but for this query I'm just ...
8
votes
2answers
62k views

How to migrate Oracle database to MySQL server? [closed]

Currently, our application is running using Oracle 11g database. We are developing a newer version of the application which runs on the MySQL cluster. We need to migrate the data from the Oracle ...
0
votes
2answers
3k views

Data truncation: Incorrect datetime value: '7/21/15' for column 'announced_on' at row 1

I am importing a flat file into a table in DBeaver v7.0.2. When I attempt to import, it's throwing an error for date field formatted as mm/dd/yy. The date column in the table is defined with ...
2
votes
1answer
766 views

Suggestion for a contact management database design

I am currently designing a contact management database for a chamber of commerce. The goal of the database is to store all the person (except our own staff), all recorded companies (regular companies ...
0
votes
1answer
138 views

MySQL Workbench Synchronization False Positives

I have synchronized a table between a model and a live server database in Workbench, but every time I rerun the "Synchronize With Any Source..." wizard, Workbench detects (falsely) that there is a ...
1
vote
1answer
970 views

MySQL Workbench Administrator - GUI "Access denied for user root " gotcha

Here is a small newbie problem I found and resolved. The behavior of the GUI is a little confusing so I figure I will share. Running some Java examples, I have MySQL set up on Windows. After making ...
0
votes
1answer
795 views

Problems during migration from SQL Server to MySQL via MySQL Workbench

We've found most of the options we needed to include the necessary CHARSET. Here is what we've included in the MySQL my.cnf: [client] default-character-set = utf8mb4 [mysql] default-character-set ...
0
votes
1answer
766 views

Mysql import csv not complete by Mysql bench

I upload the csv file which has more than 5 thousand rows table data for option import wizard by Mysql Workbench. As the result the output table only 335 rows, have no idea how to overcome the ...
1
vote
1answer
237 views

How can I import latitude and longitude data into a database using Mysql Workbench?

I am currently trying to get some latitude and longitude data to import into a database using the data import wizard in mysql workbench. the problem is that the floating point values that get ...
0
votes
1answer
405 views

sql syntax error 1064 in workbench-generated script

I'm not very familiar with sql, so I'm using workbench to create a db. I keep getting this error: Executing SQL script in server ERROR: Error 1064: You have an error in your SQL syntax; check the ...
2
votes
2answers
2k views

Data normalization (from 0NF to 1NF)

I am designing a relational database in mySQL - a library management system. I want to show examples of the data in 1NF, 2NF, 3NF, BCNF, etc. My example of 1NF looks something like this "A relation ...
0
votes
0answers
20 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
2answers
86 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 ...
2
votes
1answer
6k views

DBeaver: Access denied for user 'root'@'localhost' (using password: YES)

Context: I am creating a new Schema and looking to import .sql file generated from mysql dump. I have server running: MySQL 8.0.19. I am using DBeaver client Version 7.0.2 and have setup a new MySQL ...
1
vote
2answers
287 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) ...
1
vote
1answer
22 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....
0
votes
0answers
12 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
0answers
714 views

Attempted to import .csv into mySQL using workbench, but only imports 7 rows?

To start, I'm still a relative SQL noob so this question could have an obvious answer that I'm just missing. I'm trying to start a big practice project in my spare time using a dataset which has ~...
11
votes
4answers
28k views

MySQL Editor Hangs on attempt to Launch

I have just downloaded the latest Community Installer (5.5.27) along with the MySQL WorkBench (5.2.41). I clicked OK on all default settings on setup. When I try to "Open a connection to start ...
4
votes
6answers
64k views

Problem with new MySQL Workbench connection

I'm working on Debian 8 and wanted to create database using MySQL Workbench. I did everything in this tutorial, but when I created a new MySQL Connection, the program returned: Failed to Connect ...

1
2 3 4 5
10