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.
100
questions
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 ...
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
...
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 ...
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.
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 ...
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 >...
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 ...
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 ...
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 ...
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:
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 ...
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?
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 ...
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 ...
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 ...
-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;
+------------------+-----------+ ...
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 ...
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?
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 ...
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 ...
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 ...
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 ...
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' (...
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 ...
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; ...
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 ...
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 ...
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 '<...
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-...
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 ...
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 ...
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 ...
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 ...
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 ...
-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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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 ...
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, ...
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 ...
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 ...
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/ ...
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, ...
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 ...
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 ...
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 ...
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 ...