MySQL Bugs: #93080: Workbench crashes every time on users

Bug #93080	Workbench crashes every time on users
Submitted:	5 Nov 2018 10:21	Modified:	8 Nov 2018 12:19
Reporter:	Justin Levene	Email Updates:
Status:	Analyzing	Impact on me:	None
Category:	MySQL Workbench	Severity:	S3 (Non-critical)
Version:		OS:	Windows
Assigned to:		CPU Architecture:	Any

Description:
Click "Server" then "Users", go to the "Schema Privileges" tab, revoke a privilege and then press the "Apply" button in the bottom right, Workbench hangs as "Not responding"

How to repeat:
See above

Thank you for the bug report. Which version are you using? I couldn't repeat with 8.0.13.

I was using 8.0.12 but just upgraded to 8.0.13, however problem still persists.

Using Windows 10 64 bit doing this against a remote server, not localhost (an Amazon RDS database running MySQL 8.0.11).

Works fine when using localhost, its just when connecting to a remote server.

I crashes every time without fail.

Thank you for the feedback. Are you able to attach here screenshot of the steps are you doing? not sure if I am following exactly what you are reporting. Thanks.

A screen shot won't help, it's really simple, it's just a few mouse clicks:

Open a schema that is not hosted on your machine

In the menu, click "Server", then click the "Users and Privileges" menu option.

Select a user under the "User Accounts" left pane.  Best to use a standard user and one you are not logged in with.

In the right pane, click on the "Schema Privileges" tab.

Select a privilege and click the "Delete Entry" button, then click the "Apply" button in the bottom right of the pane and voila, Workbench freezes every time.

IMPORTANT: This only happens when connecting to a remote server and NOT localhost.  On localhost it works fine.

Thank you for the feedback. I couldn't repeat when connected remotely with a MySQL Server 8.0.13 running on Ubuntu Linux and Windows 10 PRO. The Amazon Database isn't supported.
https://www.mysql.com/support/supportedplatforms/workbench.html

The link you gave me (https://www.mysql.com/support/supportedplatforms/workbench.html) is regarding support for Workbench running on a machine.  Workbench for this bug is running on a Microsft Windows 10 64 bit machine (which is supported) and connecting to a Linux machine running a MySQL server in an AWS server farm.

I should add that clicking the "Apply" button does actually do as it should and removes the permission, it's just Workbench freezes every time and tested on different Windows machines.

The connection is via an internet connection and has the same bug when connected to a MySQL server on a JustHost Linux server (standard Linux server for a hosting supplier).

Workbench should not freeze.  The action happens on the server, its just Workbench freezes and has to be restarted.  This is 100% a MySQL Workbench bug.

Quickly attempted to reproduce this issue using MySQL Workbench Community (GPL) for Windows version 8.0.13 CE build 13780177 (64 bit) on Win7 connected to MySQL Server 8.0.13 hosted remotely on a OL7 physical box, later second attempt tried with a remotely hosted VM/Ubuntu 18.0.4 and running MySQL Server 8.0.13  but still I'm not seeing any lagging/freezing issues be it in "apply" etc after following your steps and changes are instantly reflected.  Since, my OL7, Ubuntu boxes are remote boxes but still inside our network and that could be the reason that I'm not seeing any issues.

As I said, its when the servers are outside the network.  It seems that the lag due to a remote server accessable via an internet connection is the problem.

https://bugs.mysql.com/bug.php?id=93316 marked as duplicate of this one.