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.

Filter by
Sorted by
Tagged with
0 votes
0 answers
44 views

mysql workbench navigator panel - move schemas up or down - change schema order

Is it possible to change the order (re-order/re-sort) of the schema listings in Navigator Panel in MySQL Workbench - to move them up or down in the Panel list? I'm running 8.0.16 to specifically match ...
dmh.sedev's user avatar
0 votes
1 answer
137 views

Ubuntu 22.10 not able install mysql

No LSB modules are available. Distributor ID: Ubuntu Description: Ubuntu 22.10 Release: 22.10 Codename: kinetic I trying sudo apt-get install mysql-server Reading package lists... Done ...
250121's user avatar
  • 1
0 votes
0 answers
123 views

MySQL workbench permission denied for files in media drives under "Other Locations" of Ubuntu 22.04 LTS

I've freshly installed MySQL workbench in a new Ubuntu system (Ubuntu 22.04 LTS) through Ubuntu Software center and all installations and database connections are configured smoothly. But when I try ...
mpsbhat's user avatar
  • 101
1 vote
0 answers
997 views

Sql Workbench does not work on macOs venture latest version

When ever I try to launch the MySql workbench it crashes and shows this error report. I tried uninstalling and reinstalling different versions it shows same error.
SHresTho12's user avatar
0 votes
1 answer
1k views

Mysql Workbench where I can see rows count

I start using Mysql Workbench. Before I used PhpMyAdmin which shows me all rows count in table automaticaly on select. Can somebody tell me please where I can find all rows count in table in ...
Čamo's user avatar
  • 345
2 votes
1 answer
3k views

Is there any way to export MySQL Workbench 8 connections by shell commands?

I need to add some shell commands to my backup script to take a backup of defined MySQL connections in the Workbench. MySQL workbench allows this in its GUI: menu bar > Tools > Configuration >...
Masoud Shariati's user avatar
2 votes
1 answer
2k views

mysqldump on windows with mysql 8 community

I have MySQL 8.0.26 installed but when I type mysqldump in PowerShell I get a The term 'mysqldump' is not recognized error. When I open up the installer everything is installed. Back in the day ...
neubert's user avatar
  • 7,092
0 votes
1 answer
292 views

Connecting to Raspberry database with TCP/IP over SSH

I am trying to connect to my raspberry MYSQL server with MySQL workbench over SSH but get the error: "Could not connect the SSH Tunnel WARNING: Server public key has changed" I´m not sure ...
Viktor J's user avatar
0 votes
1 answer
70 views

MySQL 1273 Workbench

I have initially started to run https://www.youtube.com/watch?v=7S_tz1z_5bA&t and installed it all. When using MySQL Work Bench I initially run it, I get thunder icon when it runs but then I get ...
David Daoud's user avatar
2 votes
0 answers
398 views

MySQL Workbench unable to backup connections

I tried to take backup from connections through tools from top menu, however I received this error which I have no idea how to get rid of it. Do you know how to solve it? 1:
Leon's user avatar
  • 21
1 vote
0 answers
40 views

Upgraded mysql server from 5.7 to 8.0 and lost local schema connections

I had a few local schemas I seem to have lost / disconnected from when I uninstalled mysql server 5.7 and installed mysql server 8.0. Is there a way to get the schemas back or reconnect them or am I ...
Jordan.J.D's user avatar
0 votes
2 answers
4k views

MySQL Workbencb while running pops out error message about keychain

When I open my mysql workbench on mac, the message pops up saying----- The specified item could not be found in the keychain. (-25300). How do I fix this?
Ujjwal Oli's user avatar
4 votes
1 answer
15k views

Is there a 64-bit version of MySQL for Windows?

On the MySQL download page, there are only downloads for "Windows (x86, 32-bit)" https://dev.mysql.com/downloads/installer/ However, MySQL Workbench seems to be 64-bit, it says "Windows ...
Aaron Franke's user avatar
  • 1,213
0 votes
1 answer
132 views

I'm having trouble connecting to my MySQL RDS

I created an RDS MySQL DB following the AWS steps but I can't connect to it. I tried disabling the firewall and nothing works and I tried using allow everyone in the security profiles for the DB. In ...
DeadSec's user avatar
  • 129
0 votes
1 answer
4k views

Installed MySQL, but it is not showing in the installer (Windows10)

I tried installing MySQL from the official installer (https://dev.mysql.com/downloads/file/?id=492815). I ran the installer, but I think the installer stopped someplace midway. Now, I am not able to ...
user3055349's user avatar
-1 votes
1 answer
535 views

How do I safely remotely connect to my database via SSH?

I have these users in MySQL database mysql> select User,Host from mysql.user; +------------------+-----------+ ...
code-8's user avatar
  • 444
1 vote
0 answers
369 views

How to change MySQL Workbench editor highlighted text background color?

Is there a way to change background color of highlighted text in query editor of MySQL Workbench? It seems it's somehow set to very unreadable default, as shown in the picture: In comparison, this is ...
TheJavaGuy-Ivan Milosavljević's user avatar
0 votes
0 answers
645 views

Which MySQL Workbench version support windows xp 32 bit?

I'm developing software for windows xp I want to install MySQL Workbench which version support windows xp 32 bit?
Swapnil's user avatar
  • 163
4 votes
1 answer
8k views

mysql-workbench fails to connect with an error: Service org.freedesktop.secrets not provided

Running on kubuntu 18.04.3 LTS Installed mysql-workbench from mysql.com website (not repository) After re-install, when I try to open one of the saved sites in the Connection manager, I get the ...
TimSparrow's user avatar
0 votes
0 answers
75 views

Can't connect to MySQL server on 'sam-G5-5587' (111)

I am new to SQL, I was trying to setup SQL and SQL Workbench, but when I tried to create a connection, I got this error: I tried a solution from the internet, to comment bind address in mysqld.cnf ...
Sameh Abdelbadie's user avatar
1 vote
0 answers
263 views

Error while connecting MySQL Workbench SSH tunnelling with AWS EC2 (Linux -Free tier)

First what I have done so far In AWS In Security group given 3306 port access for all MySQL/Aurora: Created a .pem key and saved it. PuTTY I am able to connect to MySQL (5.7) using PuTTY Created ...
ATUL ANAND's user avatar
1 vote
0 answers
470 views

MySQL Workbench: How do you move query results to a separate window?

Is there a way to move query results to a separate window? I would like to move my results from queries to another monitor, and have them always appear there once ran. Does MySQL Workbench offer this ...
SovietFrontier's user avatar
0 votes
1 answer
3k views

MySql error: Access denied for user 'root'@'localhost' (using password: NO)

I am trying to retrieve my data from MySQL to be used in python. But it prints out TypeError: 'NoneType' object is not iterable The server log shows that Access denied for user 'root'@'localhost' (...
Wolfeatspotatoes's user avatar
1 vote
1 answer
6k views

How to unlock gnome-keyring using command line

My purpose is simply getting GnomeKeyring to prompt for a password. As some people may want to know why, MySQL Workbench only uses GnomeKeyring for password protection for some reason and doesn't ...
timuçin's user avatar
  • 138
0 votes
1 answer
1k views

MySQL Workbench: Error When Attempting Schema Export "global name "self" is not defined"

This comes up as soon as Export is clicked in MySQL Workbench. Error log entry: 18:19:12 [ERR][wb_admin_main.py:tab_changed:211]: Unhandled exception in Admin for <wb_admin_export.WbAdminExport; ...
Will's user avatar
  • 101
2 votes
1 answer
6k views

Fresh Installation of MySql: Access denied for user 'root'@'localhost' (using password: YES) (MacOS)

I have just installed MySQL on MacOS and I cannot login to the database in either terminal or workbench. I'm not sure how to solve this issue. Your connection attempt failed for user 'root' to the ...
garmars's user avatar
  • 31
6 votes
3 answers
7k views

How do I run multiple instances of SQL Workbench on Windows?

I use SQL workbench (not mysql-workbench) to connect to Redshift clusters. I might need to query tables from different clusters at the same time. Since one instance can only be connected to a single ...
Sajith Ravi's user avatar
0 votes
0 answers
498 views

Remote Access to MySQL on Raspberry Pi not working

I installed MySQL on my Raspberry Pi and I'm trying to set up remote access. I set up a user account like so: GRANT ALL PRIVILEGES ON <database>.* TO '<username>'@'%' IDENTIFIED BY '<...
liaquore's user avatar
  • 115
3 votes
2 answers
6k views

MySQL Workbench installation failing on Ubuntu 16.04

I am trying to install MySQL Workbench. I installed mysql server and next downloaded package: mysql-workbench-community-6.3.10-1ubuntu16.04-amd64.deb And I used command: sudo dpkg -i mysql-...
quark's user avatar
  • 31
6 votes
2 answers
21k views

MySQL workbench giving an error "Unsupported operating system" when running under Windows 8.1

I'm running Windows 8.1. I've successfully installed MySQL Workbench with server. The connection is successfully established but it says: "You are running Workbench on an unsupported operating ...
M. Umar's user avatar
  • 63
0 votes
1 answer
52 views

What password to give here?

Before asking my question, i want to tell you background of my problem. I installed MYSQL workbench 8.0. When i first installed it then it was working fine but then I installed xamp, when i started ...
Muhammad Ammar Malik's user avatar
0 votes
0 answers
2k views

MySQL workbench fonts are very small on windows 10

MySQL left sidebar fonts are very small on my computer which is having (1920 x 1080) and running on windows 10 pro. I tried to change the font size by changing the scaling, resolutions and MySQL ...
Naveen's user avatar
  • 1
2 votes
1 answer
2k views

MySQL Workbench 8.0 Users and Privileges tab is blank

I'm trying to work on an assignment and the professor asked us to create two users to use for the database, however, when I go to the Users and Privileges tab and try to add an account, it is all ...
SheepWaffle's user avatar
0 votes
1 answer
95 views

MySQL is still using the old server instance that I have deleted for good

I am facing problem of connecting to Mysql Server 8.0.15 even though I have upgraded everything from 8.0.13 to 8.0.14 and to 8.015. Furthermore, I have deleted, using Administrator's right all the ...
Karen Goh's user avatar
-1 votes
1 answer
11k 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 ...
EEstereo's user avatar
0 votes
1 answer
110 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 ...
Allan Mabele's user avatar
0 votes
0 answers
1k 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 ...
HerrimanCoder's user avatar
0 votes
1 answer
1k 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, ...
Arthur Attout's user avatar
0 votes
1 answer
121 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 ...
Nicholas Summers's user avatar
3 votes
0 answers
2k 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 ...
Juneyoung Oh's user avatar
1 vote
1 answer
2k views

OpenSSH 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 ...
The One's user avatar
  • 115
0 votes
1 answer
1k 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, ...
Ginny Harvey's user avatar
1 vote
1 answer
15k 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 ...
Zhenyu's user avatar
  • 275
1 vote
1 answer
689 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 ...
Apparently Im user2212428's user avatar
1 vote
1 answer
5k 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/ ...
user1032531's user avatar
  • 1,651
0 votes
1 answer
562 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, ...
neubert's user avatar
  • 7,092
4 votes
1 answer
4k 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 ...
Zhenyu's user avatar
  • 275
0 votes
0 answers
2k 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 ...
Mashrur Hyder's user avatar
1 vote
1 answer
2k 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 ...
Vijay Muvva's user avatar
6 votes
2 answers
28k 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 ...
HerrimanCoder's user avatar