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

learn more… | top users | synonyms

3
votes
1answer
155 views

Querying MySQL and SQL Server from same IDE

I am currently working with MySQL and SQL Server. For querying MySQL I use MySQL Workbench, for SQL Server I use SQL Server Management Studio. I am mixing up shortcuts all the time. For instance, ...
2
votes
1answer
296 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
1answer
28 views

Mysql Adding date/time stamp to file produced, or other method of automated file naming to keep resulting files unique

SELECT '"Part #"', '"Manu"', '"Qty"', '"partdesc"', '"Rohs status"' UNION all ( SELECT partno, manuf, qtyleft, partdesc, stfifo.ROHScompliance FROM stmaster, stfifo WHERE stmaster.internal = ...
2
votes
0answers
373 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 ...
3
votes
2answers
4k views

MySQL unknown column 'password_last_changed'

When creating a user using this command create user 'foo'@localhost'; this error is shown ERROR 1054 (42S22): Unknown column 'password_last_changed' in 'mysql.user' Using MySQL server version: 5....
0
votes
1answer
287 views

middle table in one-to-many relationships

I just started using mysql workbench but it is slightly from the er diagram that i design in paper. I want to have a 1 to many relationship with three tables. For example a have entity A and entity B ...
1
vote
1answer
440 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 ...
1
vote
2answers
104 views

MySQL Workbench: How to detach reverse-engineered EER diagram from existing database?

MySQL Workbench provides the option to 'Create EER Model From Existing Database'. Trying to remove a table from the resulting diagram leads to a dialog asking: Should corresponding database ...
2
votes
1answer
113 views

Why MySQL Workbench automatically sets NOT NULL for ID column that is PRIMARY KEY?

My question is why MySQL Workbench automatically sets NOT NULL for ID column that is PRIMARY KEY? I thought that PRIMARY KEY's can't be NOT NULL by definition? Is it really necessary to set it to NOT ...
1
vote
2answers
3k views

MySQL Workbench not showing stored procedures that I have created

I have a simple stored procedure that I have just created. I have applied this script to my database This script shows up in the my list of stored procedure However, when I restart MySQL ...
1
vote
0answers
54 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 ...
0
votes
1answer
1k 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
893 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 ...
2
votes
1answer
3k views

What is InnoDB Buffer Usage and how to clear it?

In Mysql Workbench when I go in Server > Server Status there is a field called "InnoDB Buffer Usage" It is "95%" even if there is no query running. Why? It affects my performance in my new queries? ...
1
vote
2answers
71 views

MYSQL to other DB migration using MYSQL workbench

is it possible to migrate MYSQL to other database platform like MS SQL 2012 using the MYSQL workbench migration wizard?. Everywhere the only destination DB is MYSQL, the reverse process is not ...
0
votes
1answer
54 views

MySQL Workbench secretly running SHOW INDEX after every query

A few days ago, I revised some innodb_stats_* parameters and ran mysqlcheck --analyze --all-databases on some Percona 5.5.38 servers. Now, whenever I execute any simple query in MySQL Workbench, it ...
2
votes
0answers
90 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
1answer
2k 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, ...
1
vote
3answers
2k views

Automate CSV files to MySQL Database?

I'm a little mind struck at the second as I am looking to automate the following sequence: Extract Data from Microsoft Access Save files as CSV Connect toMySQL server Run one SQL file that exports ...
0
votes
1answer
216 views

MySQL Workbench — How to efficiently review large database tables?

I have a database table with 900,000+ rows, 20 columns, mostly string data. Using MySQL Workbench, I want to page through the entire contents of the table to see what exactly has been inserted into ...
0
votes
3answers
530 views

MySQL - Alter Table Fails As Workbench Tries To Create Existing Table

I have been trying to add another column to a table in my database using MySQL Workbench. This generates an 'ALTER TABLE' command which then fails as it fails attempting a 'CREATE TABLE, which it ...
0
votes
2answers
209 views

how to display parent items with thier child items in mysql data base

i am using my sql data base i have table with following data and table name is account id name parent-id 1 aaa null 2 bbb 1 3 ccc 2 4 ...
1
vote
1answer
162 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
3k views

Soccer league ER diagram (implementing a many to many relationship)

I am planning on creating a database to track teams and players in a soccer league. The stats I wish to track are as follows... goals scored/conceded(gk), assists, minutes played, cards received and ...
0
votes
1answer
260 views

Dropped connections, corrupted schema … is MySQL sick?

Lot's of problems and I wonder if it's all tracable to some root cause. I'm trying to load a simple schema related to product marketing. The symptoms are: Not being able to forward engineer said ...
1
vote
1answer
2k views

adding autoincrement to id already part of foreign key

I would like to add the autoincrement property for all my table's columns named id in a schema. However, most of them are part of a foreign key constraint. Is there any other way to do it without ...
0
votes
0answers
173 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
134 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
1answer
486 views

MySQL Workbench: Edit hidden relationships in EER diagram

How can I open the Edit relationship options panel of a relationship that is previously been hidden? Workbench v6.2
0
votes
1answer
520 views

MySQL Workbench - “deploying” schema into a real database

a noob here, finding my way around. So, how can I "transfer, deploy or whatever the right term is" the database tables, fields, etc. that I have created with Workbench into a real database? The dB I ...
0
votes
1answer
638 views

Remove duplicate terms from column

This the tags column where all terms should be listed only once. Would like to remove all additional words from this column. For example the below contant: Lakshmi Bar & Restaurant, Dining &...
2
votes
3answers
289 views

getting MySQL error 1064 but very (absurdly) simple query in MySQLWorkbench

I'm getting a MySQL 1064 error for the simplest query when run with \G at the end. This works: select * from locations; and this doesn't: select * from locations\G hmmm... is there any way to ...
1
vote
1answer
98 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 ...
0
votes
1answer
51 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 ...
1
vote
1answer
895 views

Duplicate entry error for unique key that doesn't exist

I have a model that had the following fields: +----------+----------+ | username | password | +----------+----------+ | AAA | *** | | BBB | *** | | CCC | *** | +-------...
0
votes
0answers
2k 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
1answer
278 views

How to call a windows program in mysql prompt in windows

I want to call an OS level commands from mysql prompt within Windows command line tool. In Unix* there is a system command available to execute OS commands within MySQL prompt. Any way of dong the ...
0
votes
1answer
640 views

Select Count on Big table take 15 minutes

I try to run select Count on table with like 16M rows, with MySql 5.5 and workbench 6.2. The query running almost 1000sec . Is it normal? The query : SELECT COUNT(1) FROM My_Table when I run ...
0
votes
1answer
756 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: ...
-1
votes
1answer
115 views

what is the short cut key in mysql workbench to alter stored procedure or schema panel

what is the short cut key to alter stored procedure or navigate into schema panel in MySQL work bench windows 7
0
votes
1answer
134 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
0answers
60 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
1answer
166 views

What is the optimal number of worker tasks to specify in MySQL Workbench for a speedy migration?

What is the optimal number of worker tasks to specify in MySQL Workbench for a speedy migration? The default is 2. The MySQL server is running on the same Windows machine, installed with defaults. ...
0
votes
1answer
278 views

Clarification on MySQL Workbench Options File Configuring

When in the MySQL Workbench tool, configuring the "Options File," I see a drop-down in the lower right corner with the options: client mysql mysqld By default, 'mysqld' is selected and I see my ...
1
vote
1answer
1k views

WARNING Error checking mysqldump version Error retrieving version from mysqldump.exe: mysqldump: unknown option '--no-beep' (exit 2)

When i go to do a manual export from mysql database to workbench, this error occurs, i dont know solve
2
votes
2answers
6k views

High MySQL “InnoDB Writes Per Second” - Can't see the queries?

On our live MySQL 5.5 database server, we use MySQL Workbench for running manual queries, checking running queries to see what's going on, etc. I noticed today that on the "Server Status" tab there's ...
2
votes
1answer
701 views

How to force MySQL/MariaDB to show numbers in scientific notation?

I have a local MariaDB server 5.5.37 where I have some numeric data in it stored as DOUBLE. I need to perform some queries on this data (things like AVG(...) or STD(...)), and I also have a MySQL ...
0
votes
1answer
548 views

MySQL JDBC does not behaves as the MySQL Workbench

I'm running the following from the MySQL Workbench, and from my local tomcat using jdbc. START TRANSACTION; CREATE SCHEMA IF NOT EXISTS `ROOT`; CREATE TABLE IF NOT EXISTS `ROOT`.`all_tables` ( `...
0
votes
0answers
638 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
1answer
3k views

MySQL Workbench run SQL script file Character Set encoding issue

Upon running a .sql file for creating a schema in MySQL Workbench 6.1, it prompts a window saying it cannot decide the right character set What's the proper thing to do?