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
15 views

Service MySQL was not found on computer 'localhost' [duplicate]

I recently upgraded MySQL on my system and since then, whenever I startup my computer, I get a dialog box saying - Service MySQL was not found on computer 'localhost' When I click OK, I get ...
0
votes
0answers
5 views

Closed queries re-open when connecting to DB using MySQL Workbench

Using MySQL Workbench latest version (6.3) I've set up an Amazon EC2 connection sucessfully. Everytime I open the connection, I've noticed all queries I did before are being opened, even if I closed ...
0
votes
0answers
42 views

mysql workbench 6.3 hangs on queries on percona mysql 5.6

So I have three computers: Windows 10 with MySQL Workbench 6.0 Windows 7 with MySQL Workbench 6.3 Windows 10 with MySQL Workbench 6.3 I also have three MySQL servers. version=5.5.35-33.0, ...
1
vote
0answers
44 views

MySQL Workbench Bug, crashes when I store password or connect

I'm having issues with MySQL Workbench. I go into Manage Connections... and when I either click on Password: Store in Vault or I try to connect without a password I get this error: Unhandled NET ...
0
votes
0answers
15 views

How do I open in Excel data exported from MySQL workbench?

When clicking to Export Data, the default format is CSV, but when the data element is text that contains a double quote and/or newline, such characters are treated by common readers (e.g. Excel) as an ...
0
votes
0answers
1k views

issue with mysql workbench upgrading to fedora 23

I have just upgraded to fedora 23 but mysql workbench is not installed anymore. I tried to install the rpm like this (fc23 doesn't exist): sudo rpm -i ...
0
votes
0answers
10 views

Hide “doubled” Table Editor in MySQL Worckbench?

I am trying to hide the section below the first column editor. But i can't find any option. I tried to google, but no results for me :( MySQL Worckbench Table Editor I hope it's possible :)
0
votes
0answers
57 views

MySQLWorkbench for OS X crashing when creating stored procedure

I am attempting to create a stored procedure using MySQLWorkbench for OS X but it seems to crash... I do not know how to fix this. Workbench works fine when creating schema (etc). Here is the crash ...
1
vote
0answers
175 views

How to install SQL Server ODBC driver on OSX?

I'm using MySQL Workbench on a Macbook to migrate a SQL Server database to MySQL. When I try to connect to SQL Server I get the error: The ODBC driver that was selected for the source connection ...
0
votes
1answer
648 views

MySQL Workbench unable to restore workspace

Whenever I restart MySQL Workbench I get the following error: That error doesn't make any sense to me. I'm able to open E:\Users\user_name\AppData\Roaming\MySQL in Explorer, so if I'm able to open ...
1
vote
1answer
1k views

MySQL Workbench has stopped working the first time i want to run it

When i was installing MySQL Workbench i got this error : updating start menu link failed but i complete the installation till the end And after installing the program, i try to launch the ...
0
votes
0answers
231 views

MySQL Workbench doesn't start

I have installed MySQL 5.1 and MySQL Workbench 6.3 on Windows 7 64-bit and also .NET Framework 4.0 and .NET Framework 4 Client Profile and also installed Visual C++ 2010 32-bit redistributable, but ...
1
vote
1answer
62 views

Clear screen for MYSQL command line client 3

I tried many of the commands clear the screen in mysql command line on windows but not working... commands are clear screen; cl scr; cls; system clear; system clear screen; ctrl + l; tell me the ...
0
votes
0answers
75 views

MySQL Workbench - Add Connection from command-line

I'm writing a shell script to auto-provision a development environment for new employees. The OS is Linux Mint 17 (Qiana) and the idea is to run the script and at the end have a fully configured ...
3
votes
1answer
857 views

Import MySQL data failed with error 1839

I have master slave setup of MySQL with GTID configured. I took back data backup of master and importing it to individual Test server. It is failing to import as ERROR 1839 (HY000) at line 24: ...
1
vote
2answers
1k views

MySQL connection works on CLI, but not on Workbench

Fedora release 20 (Heisenbug) 3.19.3-100.fc20.x86_64 Packages: mysql-workbench-community.x86_64 6.1.7-1.fc20 mariadb.x86_64 1:5.5.41-1.fc20 ...
-1
votes
1answer
119 views

Incorrect syntax near 'AUTO_INCREMENT' [closed]

I get an error on AUTO_INCREMENT while creating the following table. Please help. CREATE TABLE Invoice( Invoice_No INT NOT NULL AUTO_INCREMENT, Order_ID INT NOT NULL, TotalPrice VARCHAR(30) NOT ...
2
votes
1answer
431 views

MySQL for EXCEL (2010) - Custom select query

I have the MySQL for Excel (MS E:2010) addin enabled (most current version). I've tested my connection to my server (non-local), and all is great, however I can't see anywhere to write / insert a ...
0
votes
1answer
31 views

Modify data values in a MySQL database by means of MySQL Workbench

I'm using MySQL Workbench 6.0 on Xubuntu 14.04. I have tried to create a database, but I don't manage to insert values in the fields by means of MySQL Workbench. In fact in my template I have inserted ...
1
vote
1answer
455 views

My SQL Workbench crash when I want to save

Sorry for bad grammar, first at all, English is not my native language. :) First, I'd installed MySQL Workbench in my computer Windows 8.1, but when I want to save like a model for example, Windows ...
2
votes
5answers
2k views

Compiling mysql workbench on Fedora 21

I was trying to compile mysql-workbench from source (since mysql's fedora 21 repo still doesn't have it). Installed all the dependencies as recommended in many online sources. Currently i'm stuck at ...
0
votes
1answer
2k views

Excel 2013 MySQL Database Connection - SQL Server does not exist or access denied

I recently set up the most basic possible version of MySQL 5.6 and created a test schema in which a test table was placed. The connection is just named "Local instance MySQL" with host "localhost", ...
0
votes
1answer
227 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 ...
1
vote
1answer
2k 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
113 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 ...
-1
votes
4answers
10k 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
108 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 ...
3
votes
2answers
438 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.
1
vote
1answer
530 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
418 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
30 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
3k 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
381 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 ...
-2
votes
1answer
461 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
1k 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
1k 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
11k 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
2answers
5k 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
496 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
221 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
557 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
12k 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
5k 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
2k 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
3k 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
3k 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
19k 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 ...
5
votes
3answers
2k 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 ...