Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

Questions tagged [mysql-workbench]

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

0
votes
0answers
10 views

View with select of an attribute and next columns

I need to make a view on a db using mysql workbench and I need some advice on how to do it Assuming to have i rows and j columns of a table for each j attribute, if the attributes found on column j+...
-1
votes
0answers
5 views

GenerationTarget encountered exception accepting command : Error executing DDL [closed]

enter image description here GenerationTarget encountered exception accepting command : Error executing DDL
0
votes
1answer
38 views

Failed to Connect to MySQL at localhost: 3306 with user root. Host '::1' is not allowed to connect to this MySQL server

I install a workbench 8.0 in OS X, and I have two different version of MySQL installed already 5.6 which is the default installation and a 5.7.25 version, I switch in the System Preference to 5.7.25 ...
0
votes
1answer
11 views

Why mysql 5.6 is not installing

I have tried installing mysql server several times but am frustrated because none of the versions has worked. Am getting an error message that "there is an error in XML document (0,0). This installer ...
0
votes
0answers
19 views

MySql Workbench - The menu doesn't display properly

enter image description here As the picture, I have no idea why the menu display like that. OS: windows 7 64bit SP1 Language: Traditional Chinese(Taiwan) Workbench version: 8.0.13 Edit --> ...
0
votes
0answers
20 views

MySQL Workbench Scintilla White Background

I have the dark themed sorta look from over here, and it still leaves me with some white patches. I'm not sure if this is my GTK Theme or my Scintilla Theme, but I'm going to assume for now its ...
0
votes
0answers
31 views

MySQL Workbench highlighted text is unreadable in Kali Linux

I installed MySQL Workbench on Kali Linux and it works perfectly, but when I select some text, the text stays black and is unreadable. How can I change this? Here is a screenshot of what I am seeing.
0
votes
0answers
50 views

How to rollback mysql_secure_installation?

Following the AWS/EC2 Amazon Linux AMI LAMP stack installation guide, I ran mysql_secure_installation, not really understanding what I was doing. Later I discovered that I cannot connect to the MySQL ...
0
votes
0answers
399 views

MySQL Workbench editor highlighted text color

I have been unable to figure out how to change the text color in MySQL Workbench when the text is highlighted. I'm happy with all my other text and background colors in the code_editor.xml file (which ...
0
votes
1answer
373 views

Mysql workbench reverse engineer relationship

I've been trying to create a EER diagram from a MySql script. I've used the appropriate option in MySQL workbench (Import > Reverse Engineer MySQL Script) However, the relationships are not shown, ...
0
votes
1answer
88 views

Selecting maximized window sometimes selects windows behind it

To better explain the issue, lets say that on one monitor I have MySQL Workbench maximized and on the second monitor I have a browser (Chrome) open. Lets say I also have Windows Explorer open, it is ...
2
votes
0answers
568 views

mysql workbench data import hangs forever

My dump file is 76MB and it has generated in CentOS6 with follow command. $> mysqldump -uroot -p --routines testSchema > testSchema.sql And I am trying to import the file in my Windows7 with ...
1
vote
1answer
781 views

Open SSH tunnel and connect to MySQL

Hi I'm trying to use PuTTY to open a SSH tunnel and connect to a remote MySQL server. PuTTY: Remote SSH Server IP and port MySQL Port on the remote server Tunnel: Local address and port on local ...
0
votes
1answer
626 views

MySql Workbench Schema Privileges panel is truncated and I can't access the Add Entry button

I am trying set schema privileges for a new user in MySQL Workbench 6.3 ce, but in the Schema Privileges dialogue the schema list box and options checkbox panel does not span the whole dialogue area, ...
0
votes
1answer
3k views

Mysql Workbench import CSV 0 record imported

I'm using MySql workbench to import CSV files all the time. And it's always working perfectly besides the only I issue Im having now is, there's a CSV file would not get imported. No error occured ...
1
vote
1answer
165 views

MySQL Workbench 5.6 - Synchronize Model option missing under Database menu

I am trying to perform Database Synchronization in MySQL. Normally there is an option below in red: However I am missing the following options even though I have a proper schema selected within the ...
1
vote
1answer
2k views

Connect MySQL Workbench on PC to remote MariaDB server

MySQL Workbench operates on my PC at home with IP 1.2.3.4 and MariaDB is located on my server with IP 4.3.2.1. https://mariadb.com/kb/en/mariadb/configuring-mariadb-for-remote-client-access/ ...
0
votes
1answer
363 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, ...
2
votes
1answer
638 views

can't edit data with MYSQL WORKBENCH

I'm using mysql workbench 6.3 on my Ubuntu 16.10. I'm trying to, as I do in other Mysql Management tools, to edit value of a field directly in result grid. I'm able to write the value in, but when I ...
1
vote
0answers
672 views

MySql can't connect because i changed the “Limit to host matching”

Well i was playing with the MysqlWorkbench and i made a big mistake i think. I changed the "Limit to host matching" that said "localhost" to "0.0.0.0" so when i restart the Mysql server i couldn't log ...
0
votes
0answers
200 views

I've tried everything but sql workbench does not even load

I've installed MySql workbench 6.3 CE for Windows 7 and I have Microsoft.Net framework 4.5 installed and VC redist (x64 and x86) 2015 installed. But every time I try to open the application nothing ...
1
vote
1answer
718 views

SSH tunneling and port forwarding to connect with MySQL behind ssh proxy

I have a mysql running in a machine(C) behind an SSH proxy machine (B). I want to connect to mysql on C on port 3306 using mysql workbench in my local computer(A). Machine B is accessible by machine A ...
1
vote
1answer
10k views

How to change the MySQL Workbench editor background color?

How can I change the MySQL Workbench editor background color? It seems to always be white. I am using Workbench version 6.3.7. Beware: There are other Stack posts out there with descriptors on how to ...
0
votes
1answer
197 views

MySQL Workbench error for schema in database and table created from Workbench itself

Based on a database with a single simple table, created using MySQL Workbench (Community) version 6.3.7b1199-CE-64b connected to CentOS MySQL 5.1.73, I tried to use MySQL workbench to get information ...
1
vote
0answers
396 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 ...
1
vote
0answers
172 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
1answer
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 mysql-workbench-community-6.3.5-1.fc22.x86_64....
1
vote
0answers
728 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 ...
6
votes
2answers
9k 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
5k 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 ...
1
vote
1answer
593 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 ...
7
votes
1answer
9k 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
5k 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 mariadb-libs....
-1
votes
1answer
2k 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
1k 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
63 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
555 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
3k 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
522 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 ...
2
votes
3answers
27k 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
213 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 ...
-2
votes
4answers
15k 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 ...
1
vote
1answer
413 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 ...
4
votes
1answer
689 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
1k 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
843 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
38 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 5....
0
votes
0answers
715 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 ...