Stack Overflow
Stack Overflow

Questions tagged [workbench]

A term typically applied to a GUI that offers shortcuts or information displays that assist in some task.

Examples include MySQL Workbench, Microsoft Visual Studio and Eclipse.

598 questions
149
votes
24 answers

Access Denied for User 'root'@'localhost' (using password: YES) - No Privileges?

I am continuously receiving this error. I am using mySQL Workbench and from what I am finding is that root's schema privileges are null. There are no privileges at all. I am having troubles across platforms that my server is used for and this has…
Chase
  • 1,493
  • 2
  • 10
  • 5
68
votes
8 answers

Moving connections and instances between two computers

I´ve got a mysql-server that I´m administrate remotely with MySQL Workbench. Now I´ve got a new computer and I cant find any solution to move my connections and instances-profiles to my new computer. This can´t be an unsolved question, huh? Not the…
Mr Rebel
  • 702
  • 1
  • 5
  • 11
58
votes
9 answers

results grid not showing on mysql workbench 6.3.9 for macOS sierra

At firs it was working alright, but out of the blue it disappeared, and there is no way to bring it back. Note the gray area with the Apply and Revert buttons, where the results grid should be. I also tried clicking on the EXPLAIN command icon,…
Martin Ocando
  • 896
  • 2
  • 8
  • 16
47
votes
3 answers

Creating UNIQUE constraint on multiple columns in MySQL Workbench EER diagram

In MySQL Workbench's EER diagram, there is a checkbox to make each column in a table unique, not null, primary key etc. However, I would like to have a UNIQUE constraint on multiple columns. Is it possible to add it in in MySQL Workbench's EER…
zhenming
  • 1,029
  • 3
  • 11
  • 14
39
votes
2 answers

Workbench section not showing in apache jmeter

I am new to jmeter. I successfully installed jmeter into my windows machine. I opened "jmeter.bat" under apache-jmeter-4.0\bin. But the jmeter window is not showing the workbench section in the left panel. I have attached the screenshot below in the…
Aravinth
  • 536
  • 1
  • 5
  • 12
36
votes
5 answers

MySQL Workbench charset

Does there exist any way to change the MySQL Workbench charset? My schema uses UTF-8 and when I view the table data (saved as UTF-8) or add data manually, it appears with charset errors, probably MySQL Workbench uses LATIN1.
Math
  • 361
  • 1
  • 3
  • 4
34
votes
3 answers

MySQL Workbench - how to diagnose query failure problems

I have loaded MySQL and MySQL workbench on my PC, and am using it to build up my SQL skills, accessing only data stored on and served by the PC itself. When a query fails the only message I get is one telling me it failed because of an error. Is…
Andrew Kirk
  • 1,527
  • 1
  • 9
  • 14
30
votes
2 answers

MySQL Workbench > Plugins > Utilities > Reformat SQL Query

At some point I installed MySQL Workbench 5.2.47 Revision 10398. This version has the feature to reformat an SQL query located at: Plugins > Utilities > Reformat SQL Query I like this feature and I use it almost every day. Now every newer version I…
Robi Wan Kenobi
  • 1,191
  • 1
  • 8
  • 9
30
votes
9 answers

How to copy table between two models in Mysql workbench?

I am doing some databese thing, I need copy one table from one model to another, but i try many ways there no effect. Is there any way for doing this?
DraculaW
  • 345
  • 1
  • 3
  • 7
29
votes
8 answers

MySQL Workbench incompatible/nonstandard server

I am new to using MySQL and I needed to download it for school, however, I keep getting this error message (picture below). I am using xampp and connecting using the username root. the port also matches what it is telling me. It will let me proceed…
D. Coop
  • 311
  • 1
  • 3
  • 4
29
votes
4 answers

Errno 121, duplicate key on write or update?

SET @OLD_UNIQUE_CHECKS=@@UNIQUE_CHECKS, UNIQUE_CHECKS=0; SET @OLD_FOREIGN_KEY_CHECKS=@@FOREIGN_KEY_CHECKS, FOREIGN_KEY_CHECKS=0; SET @OLD_SQL_MODE=@@SQL_MODE, SQL_MODE='TRADITIONAL,ALLOW_INVALID_DATES'; CREATE SCHEMA IF NOT EXISTS `mydb` DEFAULT…
artem
  • 13,833
  • 33
  • 102
  • 170
25
votes
1 answer

Mysql Workbench connection ssl not enable

I'm trying to connect local database using mysql workbench but i can't connect.i tried test connection.it warned pop up window write "ssl not enable". how can i connect my local database this is screen shot
sedatbzdgn
  • 251
  • 1
  • 3
  • 5
23
votes
4 answers

Export dump file from MySql

I want to create a dump file of a table in the database. So database --> king, tablename --> castle So what I want to do is create a dump file.. and then the next part is to import it in my local host. database name --> king_local. Any ideas on how…
frazman
  • 27,605
  • 60
  • 159
  • 243
19
votes
3 answers

Does MySQL Workbench autocomplete work?

Using MySQL Workbench, when I press CTRL + space it looks like there is an autocomplete feature (However, no items appear in the auto complete box). I am not sure that MySQL workbench has an autocomplete feature like SQLyog has(See…
user605334
19
votes
6 answers

Eclipse workspace crashes on startup

I am using Spring Tool Suite(STS) 3.0.0 release (eclipse.buildId=3.0.0.201208091018-RELEASE-e42). It was running fine for a couple of months but lately my main workspace is crashing on splash screen with error as shown in last part of this post. I…
jeet
  • 589
  • 1
  • 3
  • 15
1
2 3
…
39 40