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

0
votes
0answers
7 views

MySQL Workbench periodically errors on auto-save?

What could cause this? It pops up every few minutes while MySQL Workbench is open. I already tried the obvious, blunt-force fix, but it didn't work: Granting all permissions to Everyone in the entire ...
0
votes
2answers
65 views

How can I get MySQL workbench to always show the result grid?

When I execute a SELECT query in the MySQL workbench, the result grid appears. Then, when I execute an UPDATE, the grid disappears. Then when I run a SELECT again to view the changes, it reappears. ...
0
votes
0answers
24 views

importing issue with mysql version to another

I have got an issue with mysql import, I have taken a backup of the mysql version 5.1.32 with the help of command mysqldump -u root -p --routines oneclicksite > oneclick.sql and importing it with ...
0
votes
0answers
14 views

Missing Management options in MySql Workbench

I've installed MySql Workbench 6.1 and for whatever reason, I don't have any Management options (like database restore). The tab exists, but there are no items in it. My colleague has the exact same ...
0
votes
0answers
154 views

How to change the background color in MySQL Workbench on Linux?

In Windows Workbench there is a "Theming" tab in Preferences where one can choose the color scheme. In Linux version this tab is missing and the default background color is black. How one can change ...
-1
votes
2answers
2k views

Installing MySQL workbench on CentOS

Using sudo yum install mysql-workbench-community-6.1.7-1.el6.x86_64.rpm Getting the following: Loaded plugins: fastestmirror, refresh-packagekit, security Loading mirror speeds from cached ...
0
votes
1answer
40 views

How to set the default table export format in MySQL workbench?

While exporting a table using MySQL workbench, the default type is ALWAYS CSV. I don't usually export a table in CSV format. Is there a way to change this default to be SQL insert ? I circled the ...
0
votes
0answers
149 views

How should MySQL Workbench's Compare Schema report be interpreted?

I have a database schema model in MySQL Workbench and a live database. The Workbench model is the most current of the two, and should be used to update the live database. To compare the differences, ...
3
votes
2answers
233 views

How do you hide tool tips in MySQL Workbench?

Is there a way to hide the tool tips that popup when you hover over objects? Especially when you hover over tables, I do not want to see the breakdown of what objects are in that table.
0
votes
1answer
136 views

In Mysql Workbench, where is Synchronize Model with Database

As displayed in Mysql Database Synchronization documentation. I cannot find this particular Synchronize Model with Database window / wizard under Database -> I have Mysql Workbench 6.0.9.11421 ...
0
votes
1answer
272 views

Start server: /bin/sh: 1: /etc/init.d/mysql: not found

I have tried MySQL workbench on linux mint 14, and got this Start server: /bin/sh: 1: /etc/init.d/mysql: not found error when trying to start local server on it. Please help how to resolve this ...
0
votes
1answer
25 views

Editing finished mysql table

I'm new to mysql and I want to edit my table. My primary key should be auto generated. So where can I get the option to edit my table? thanks
1
vote
1answer
566 views

MySQL Workbench 6.0 ce will not start on Windows 8 Pro

Just install windows 8 Pro Install xampp for mysql and php while install mysql workbench 6.0 Install went fine but the application does not start Try to install the version of mysql workbench ...
0
votes
0answers
167 views

mysql store procedure text fili

In MySQL using sqlworkbench, how can I create a procedure for a table to get the input value (only the first 100 rows) from the text file and store it in the database? For example: in the text the ...
0
votes
0answers
269 views

'mysql-workbench' require to unlock 'default' keyring on connect to server in KDE

Everytime when I try to connect to any server ('forward engenee' or 'synchronize model' for example) I get a messagebox: Unlock login keyring Enter password to unlock default keyring I use ...
-2
votes
1answer
203 views

Can I give access to database without access to cpanel

I'm going to give a freelancer access to the database. The idea was to give him the access with SSH (MySQL Workbench). But it came out that to do so, I would need to give him the password to my cpanel ...
0
votes
2answers
519 views

MySQL: How to delete single table that is connected via foreign key?

I am generating a database schema via Java and want to drop only the tables I made changes to, in order to spare me from entering all the data again (or importing it from a manually updated dump). ...
0
votes
1answer
584 views

How do I open a Rails Mysql database in Mysql Workbench?

I having trouble finding my mysql database files in Ruby on Rails project and opening it in MysqlWorkbench This is my folder structure for a app This is my database.yml development: ...
0
votes
3answers
5k views

ERROR 2003 (HY000): Can't connect to MySQL server on '127.0.0.1' (111) [despite commenting out bind-address & skip-networking]

Okay, so disclaimer: I'm an absolute mysql noob. Gimme any other development type area and I'm fine. So, I just started using Ubuntu 12.04 an setup mysql. Never really used localhost since we have a ...
0
votes
1answer
3k views

Install mysql workbench on debian wheezy amd64

I try install mysql workbench on debian wheezy amd64 but there are many dependencies: ~$ sudo apt-get install mysql-workbench Reading package lists... Done Building dependency tree Reading ...
1
vote
0answers
285 views

MySQL Workbench draw weak entity

Using MySQL Workbench how can I draw weak entity sets? Does it have anything to do with the tool's non-identifying and identifying relationship?
1
vote
0answers
199 views

set mac iptables to allow external traffic for AWS MySQL

I am using mac os x mountain lion. I need to configure MySQL Workbench to access my db on AWS. After installing MySQL Workbench and trying to connect I get the error "Host ..... is not allowed to ...
0
votes
1answer
422 views

Where is MySQL Workbench Database Migration Wizard?

I am using MySql 5.5 with MySql Workbench 5.2 CE. I have read that workbench has data migration feature (http://www.mysql.com/why-mysql/migration/), but I am not able to find this feature in ...
0
votes
1answer
6k views

MySql workbench: access denied for user root@192.168.2.199 but this doesn't match the host i'm trying to access

I'm trying to connect to a MySql 5.1 server on 192.168.2.41 but the error message talks about host 192.168.2.199. This is not the host i'm trying to login to. I can login using a lesser account ...
4
votes
4answers
3k views

can't stop or start mysql on fedora 17

I have recently setup a fedora 17 machine with Gnome and installed Mysql using the add/remove software GUi included. Mysql seems to be working - I can login, select databases, do queries etc but if I ...
0
votes
0answers
1k views

Installing MySQL 5.5 on Windows Server

I had MySQL 5.1 running on Windows Server 2008 R2. I upgraded the system to Server 2012 and I thought it was the time to upgrade the database server too. I removed the old version of MySQL after ...
1
vote
1answer
2k views

mysql workbench on centos 6

I've installed mysql workbench: sudo yum install mysql-workbench-gpl-5.2.44-1el6.x86_64 Then I've double-clicked its icon on the desktop, but after splash screen nothing is displayed. If from ...
1
vote
1answer
3k views

How to install, mysql-workbench in CentOS6?

well. How to install mysql-workbench in CentOS6 i686? first, su -c 'yum install mysql-workbench-gpl-5.2.42-1fc15.i686.rpm' but --> Finished Dependency Resolution Error: Package: ...
0
votes
1answer
1k views

Why is my mysql database table not allowing me to edit data manually?

For some odd reason out of the blue my database in MySql will not allow me to manually edit any records. My guess is it never has. I am logged in with the Workbench under the root account. I have ...
0
votes
2answers
2k views

mysql connection cancelled in workbench

I didn't notice another discussion regarding this problem I have been having so I figured it would be safe to ask. I have just recently installed Mysql database and workbench on a computer. I open ...
3
votes
1answer
10k views

How to increase mysql max_allowed_packet for client?

I want to increase max_allowed_packet variable size for mysql client which is using remote server. I've googled it and the answers I could find only discussed changing the variable for server. My ...
3
votes
3answers
1k views

\G like vertical output in MySQL Workbench for show engine innodb status

show engine innodb status; is unusable in MySQL Workbench, as shown here: =====================================120329 12:39:32 INNODB MONITOR OUTPUT=====================================Per second ...
1
vote
1answer
15k views

Mysql WorkBench : Exporting table data backup?

How do I export tabluar data using Mysql WorkBench 5.2.37 CE Rev 8576? It seems I can export table schemas no problem but the .sql file generated has no data whatsoever? Steps taken: Established ...
2
votes
1answer
407 views

MySQL Workbench Snap To Grid

I'm using MySQL Workbench 5.2.36 in OS X and was wondering where in the options is the Snap To Grid function when editing a model? I can find Show Grid, but that's all... it's sort of pointless ...
1
vote
1answer
314 views

mysql workbench visualization for schema

i have an existing database and have recently downloaded mysql workbench. I was wondering if anyone could walk me through how to navigate the workbench and how to get a visualization of the RDB. I'd ...
2
votes
1answer
3k views

How do I give a single user permissions over a schema in MySql Workbench?

I have a MySql server installed on a server along with MySql Workbench. About a year ago, I managed to do this and I felt like slapping myself as it was something so simple, but, I just can't ...
4
votes
4answers
10k views

MySQL Workbench 5.2 doesn't start on Windows 7 Ultimate 64-Bit

I just installed MySQL Workbench 5.2 and everything went well. But I can't manage to start it. It shows no error message, and no splash screen. I've tried to troubleshoot compatibility, but with no ...
2
votes
3answers
6k views

MySQL Workbench, start with auto commit off

I'm running MySQL Workbench 5.2, and whenever I make a connection to a database auto commit is toggled on. Is there any way to have the default behavior be changes so that auto commit is toggled off, ...
3
votes
2answers
3k views

Can I use MySQL Workbench to create data?

The MySQL Workbench seems to be a nice tool for create database schemata. When I export a model, there is a checkbox for "create insert statements". Thus, it should have an option to fill one's ...