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
0answers
19 views

How to change MySQL Workbench tooltip/mouseover background or font color

MySQL Workbench on Execution Plan tab, displays data using dark gray font on black background which is totally unreadable. I hope that this is somehow configurable. I played with /usr/share/mysql-...
0
votes
1answer
53 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
1answer
91 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
1answer
102 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
0answers
102 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
0answers
69 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?
0
votes
1answer
295 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
0answers
47 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
0answers
31 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
0answers
22 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
0answers
34 views

Why am I having trouble creating a connection for mySQL workbench?

Recently, I was able to download mysql workbench, but I cannot configure a connection. I keep getting a (61) error when I try to create a new connection, but when I try to look up how to get around ...
0
votes
0answers
30 views

How to implement many-to-many relationship between a dimension and the fact table in Pentaho Schema Workbench?

I need help to implement the following example in Pentaho Schema Workbench: A patient can have many dental procedures (the same example applies to diagnostics). The key here is that it must be a many-...
0
votes
0answers
30 views

Error at data import thith import wizard in mySQL

I want to import a csv-file into a existing table in mySQL. But everytime i click on the next button after choosing my table I get an error. maybe it has something to do with the fact that the first ...
0
votes
0answers
2k 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' (...
0
votes
0answers
103 views

“Your connection attempt failed for user 'root' from your host to server at localhost:3306: Plugin 'mysql-native-password' is not loaded ”

Your connection attempt failed for user 'root' from your host to server at localhost:3306: Plugin 'mysql-native-password' is not loaded in ubantu 16.04 pls help.
0
votes
1answer
1k 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
1answer
201 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
1answer
4k 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 ...
3
votes
1answer
482 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
0answers
653 views

Can't connect to MySQL server from MySQL Workbench

I am not able to connect to MySQl server from MySQL Workbench. I did mysql_secure_installation after I installed MySQL server, then I tried sudo option also but not working , my OS is Ubuntu 18.10 LTS ...
0
votes
0answers
300 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 '<...
1
vote
1answer
1k 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-...
5
votes
2answers
7k 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
1answer
46 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
0answers
661 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 ...
1
vote
1answer
375 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
1answer
30 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
1answer
8k 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
22 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
638 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
868 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
104 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
1k 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
1k 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
858 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, ...
2
votes
1answer
6k 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
353 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
4k 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
454 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
2k 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
1k 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
1k 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
1k 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 ...
2
votes
2answers
20k 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
273 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
499 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
270 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....
2
votes
0answers
921 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 ...
8
votes
4answers
15k 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 ...