MySQL Workbench is a visual database design tool that is developed by MySQL. It is the successor application of the DBDesigner4 project.

learn more… | top users | synonyms

2
votes
1answer
621 views

Primary key type change not reflected in foreign keys with MySQL Workbench

I have a problem with MySQL Workbench and primary/foreign keys. I have some tables with PKs involved in relationship with other tables. If I modify the type of the PK, the type of the FK doesn't ...
1
vote
1answer
18 views

MySQL schema recovery

Is there a chance to recover overwritten schema or table in a schema? I have accidentally overwritten schema with the back-up from other source.
1
vote
1answer
33 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 ...
1
vote
1answer
36 views

Differences between Authentication Types in MySQL Users and Privileges

I noticed that when I create a new account, that there are three different Authentication Typesavailable to choose from in MySQL Users and Privilegeswindow. What I am wondering is: What is the ...
1
vote
1answer
772 views

Cannot create foreign key on 2 VARCHAR(45) columns in MySQL Workbench 6.1

I'm trying to create a foreign key. The columns in both tables are VARCHAR(45) and neither is a PK, however I keep getting this error message: It is saying the PK of reference table is INT, which ...
1
vote
1answer
1k views

MySQL Workbench Cannot start SSH tunnel manager

I don't know why this error is happening when I try to connect by MySQL Workbench. Cannot start SSH tunnel manager. I'm using slackware 14.1 and installed all dependencies. I already installed the ...
0
votes
1answer
24 views

Use event schedule and stored procedure to automatically average every hour MySQL

I have a database in Mysql Workbench about weather that updates every second. It contains temperature and wind speed. This is my database: CREATE TABLE `test`.`new_table` ( `id` INT(10) NOT NULL, ...
0
votes
1answer
26 views

MySQL Workbench: “Operation has completed with warnings”

As I synchronize my database, MySQL Workbench reports: "Operation has completed with warning. Please see logs for details." But the Message Log just says: Fetching schema list. OK WARNING: ...
0
votes
1answer
82 views

How we resolve Mysql Enterprise online backup error with “CORRUPT LOG RECORD FOUND” log error

I have configured my production MySQL database with MySQL Enterprise "online Backup" option. The configuration was went through successfully. When the assigned scheduler is try to take backup then i ...
0
votes
1answer
478 views

MySQL workbench: Cannot Connect to Database Server (ssh)

General pointers would be appreciated -- it's likely I'm misunderstanding the mechanisms involved in a remote connection through ssh. I can use ssh to connect remotely, and then, through the CLI, ...
0
votes
1answer
55 views

MySQL Workbench can either Dump or Restore - How Do I Configure To Do Both?

I have previously posted this question on Stack Overflow, but have not solved the problem. Hopefully it is not incorrect to post it here in the hope that it will be seen by a some different ...
0
votes
1answer
38 views

Relationship issue

I'm working on a ERD with mysql workbench, and i have a little question. I have a Database with this tables: company_address country state city I want to store the address of the company with all ...
0
votes
1answer
206 views

MySQL output file location - accessing server files

I am running the MySQL Workbench 6.2 CE on Windows7. I have an output table of 200,000 rows and I need to save it. I will have to repeat this task, so I would like to iterate the following code: ...
2
votes
0answers
658 views

The nature of the relationship between two tables in MySQL

Good day. I'm designing a database for a research project where we're predicting whether or not young female athletes will rupture their ACL(s) based on the nature of a test jump recorded with a ...
2
votes
0answers
309 views

Ignore foreign keys in mysql workbench model synchronization

I've made an ERD in MySQL Workbench, where I added foreign keys to visualize the relationships. In the actual database I want to work without the foreign keys (I'll organize that in my application). ...
1
vote
0answers
16 views

MySQL workbench won't import my sql file

I have an SQL file im trying to import via mysqlworkbench but I keep getting the error: Access denied for user 'wordpressuser79'@'localhost' (using password: NO) Operation failed with exitcode 1 ...
1
vote
0answers
44 views

Get unique rows based on max of a column in mysql

I came across many solutions like the one in this question. However, they all are restricted to data from one table. I'm very very new to SQL. I'd like to get the same results as in the linked ...
1
vote
0answers
25 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: ...
1
vote
0answers
109 views

How to limit the no of rows to copy in MySQL Workbench Data Migration

I am trying to migrate a huge MS SQL database to a MySQL database using MySQL Workbench. The source database is too big and i am only interested in 1000 records per table for migration. ...
1
vote
0answers
109 views

MySQL Workbench Forward Engineer from only the current diagram

I want to create a test database from a huge schema in MySQL, but when I try to do Forward Engineer from a Diagram with about 6 tables, it try to create all the tables, views and routines groups that ...
1
vote
0answers
114 views

How to get data comparations from two mysql tables

What I have: The next structure: Table ChrM LID (PRIMARY with auto increment) LOCUS (varchar (9)) Example value: (At1g30500) (Fixed Number of LOCUS values =173 rows) StartPoint (INT) (Exclusive ...
1
vote
0answers
869 views

Migrating from Oracle to MySQL using WorkBench Migration Tool

I am currently migrating from Oracle to MySQL and I am going to use the migration tool in workbench to help me with the procedure. I have entered my source connection details as follows: Database ...
1
vote
0answers
225 views

MySQL Workbench and Optional Many's

I have used workbench before to make databases code wise and I just started looking into its EERD functions. I created a small database for a test project and found some odd things about how MySQL ...
0
votes
0answers
3 views

MySQL Workbench error: Attribute error 'nonetype' object has no attribute 'parameterValues'

I am trying to export a database but i don't have access to "server administrator" at all... everytime i try to do something from Server administration i get the message mentioned in the title. What ...
0
votes
0answers
17 views

table design approach for a rental application with several one to many relationships

I'm trying to go about designing a database/tables for the following situation I'm being presented. I'm developing a rental web application with MySQL as db engine. It is for a nonprofit organizations ...
0
votes
0answers
23 views

Foreign keys in MySQL Workbench

I am defining an EER model in MySQL Workbench. I have a library with multiple copies of each book and each book has its location in the library listed in the system. When I'm creating one-to-many ...
0
votes
0answers
7 views

Is it possible to ADD 2 EER model from 2 differents database in the same editor screen in MySQL Workbench?

I am using MySQL workbench to visualize a EER model form one database, lets says db1. It is a 166 tables database. Then I have another database, that interacts with db1, that has 10 tables. So I have ...
0
votes
0answers
134 views

ClearDB Granting Created User Access

I added the ClearDB addon to Heroku, but upon using the created username to create a new database, the error appeared: Executing: CREATE SCHEMA `androidchatterdatabase` DEFAULT CHARACTER SET utf8 ; ...
0
votes
0answers
84 views

workbench failed to connect — ssh

What are the connection parameters? How do I confirm each value? Workbench error: Lost connection to MySQL server at 'reading initial communication packet', system error: 0 I can easily ...
0
votes
0answers
33 views

password based ssh authentication with MySQL Workbench

I know that it's possible to configure SSH to use keys only, and to disable password based authentication. That being said, can I do the following from MySQL Workbench? I've tried more than a few ...
0
votes
0answers
11 views

MySqlworkbench asking for convertion

hi everyone i have a question about sql in the programm of mysqlworkbench .I want to convert a er diagramm which i created in word into a database in sql.So Can anybody know to tell me how to connect ...
0
votes
0answers
48 views

Update table with selected data from join of other two table

Hey i'm new bee for mysql , I require a help that where i'm going wrong and what better can be done Table A ID_No | Mobile_No -------------------- 1 | 9999999999 2 | 9888888888 ...
0
votes
0answers
52 views

How I do a complete backup restore of MySQL Schema with views and functions?

I am trying to backup a single schema on a Windows server and restore it to an Ubuntu 12.04 Linux server running MySQL 5.5.4. The schema includes views and functions. When I used the MySQL Workbench ...
0
votes
0answers
30 views

I can't import from self-contained file in Workbench

Hello I try to import a model database that believes in workbench but says that whenever I import see that says the process was successful but when I try to view the imported tables in schemas no ...
0
votes
0answers
71 views

How to use a subquery that returns multiple rows?

I am getting Error 1242 : Subquery returns more than 1 row. Basically, I have to do this : select data from my database based on a time criterion (between 2 dates) and then apply a filter on the ...
0
votes
0answers
65 views

Mysql Workbench Server Status CPU Metric

MySql Workbench 6.1 on Windows connecting to MySql 5.6 on Linux (Amazon RDS). The Management - Server Status page shows information about the connected Mysql server (Queries per Second, etc). It ...
0
votes
0answers
61 views

In Forward Engineering I have an error called 'table does not exist'

This is my forward engineering code. -- MySQL Workbench Forward Engineering SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, ...
0
votes
0answers
352 views

Mysql Workbench Foreign Key problem

I'm working on a simple company database design but i can't figure out why i can't create foreign keys for some tables. Let me give a screenshot of the design; I'm trying to create foreign key for ...
0
votes
0answers
14 views

Is it proper to make a grand-parent key, a primary key, in its grand-child, in a multi-level identifying relationship?

I'm modeling a DB for a conference ticketing system. In this system attendees are members of an attendee group, which belong to a conference. These relationships are identifying, and therefore FKs ...
0
votes
0answers
36 views

What are correct database structure, variable names, types?

Here is my database ERR diagram I'm new to this and I'm creating a database for the following: Question and answer website The user will interact with only one question at a time. The user can ...
0
votes
0answers
14 views

Is online schema change possible with MySQL Cluster?

I believe that this is the first question on this community. I'm surveying MySQL Cluster for next project in my workplace. I read a lot official/unofficial pages on the web. But I'm not a native ...
0
votes
0answers
63 views

connecting Pervasive PSQL and MYSQL

I have Peachtree/Sage 50 on the server and trying to sync/integrate with MySQL, I already created a ODBC datasource but how can import all tables in sage to MySQL. What im trying to accomplish is to ...
0
votes
0answers
352 views

SQL Server to MySQL migration using MySQL workbench

I tried to migrate database from SQL Server 2012 to MySQL v5.5. I used MySQL workbench v6.1 community edition. What I was migrating is just schema only, not for the data. I got this error Reverse ...
0
votes
0answers
22 views

Continue a command on the remote MySQL server when I exit local MySQL workbench?

I'm issuing a DROP TABLE command that is taking a very long time. If I close down my local MySQL Workbench, will the command still be running and finish on the remote server? If it doesn't, is there ...
0
votes
0answers
121 views

Which local port does MySQL Workbench forward to in 'Standard TCP/IP over SSH' connections?

So if I was to set up an ssh tunnel for MySQL in terminal I would forward remote 3306 to local 3307: ssh -L 3307:127.0.0.1:3306 user@domain.com mysql -h 127.0.0.1 -P 3307 -u user -p db When ...
0
votes
0answers
32 views

MySQL Workbench Grid Color

Is there a way to customize the grid in MySQL Workbench? I'm having a hard time seeing the pale colors on my monitor. Also, is there a way to change the grid size? I see the page size configuration ...
0
votes
0answers
28 views

Analize Query in MySQL Server 5.1

I try use MySQL Workbench 6 to analyze the cost, but they don't show the cost of query. How i get this costs?
0
votes
0answers
40 views

Issues with Inserting due to FK constraints

I have two tables: Employee, and Department. They are setup like so, : CREATE TABLE IF NOT EXISTS `mydb`.`Department` ( `Dname` VARCHAR(25) NULL, `Dno` INT NULL, `Total_sal` INT NULL, ...
0
votes
0answers
2k views

Multi user messaging database design

I'm designing a database for a new project and I'm looking for some feedback on the design before I start to implement. It basically consists of secure messaging system with those abilities : One ...
0
votes
0answers
169 views

mysql table not updating no errors

i am using mysql 5.2.44 CE revision 9933 i have a table in which i am trying to update a few columns of the rows i am not using queries, just doing it using the edit table UI provided in the ...