5

I just created this brand new database (MySQL 5.6 on Windows) and created a new admin user but now I can't modify any of the users privileges. I can click the Add Account button (notice there's one called "newuser") but then I can't set any of the privileges for this new user as everything is disabled, and no matter what user I select, everything is disabled. I can't even click on the other tabs.

Notice also that even though I have the "admin" user selected there is no Login Name displayed on the Login tab. It's all blank, like I haven't selected any user at all.

enter image description here

enter image description here

I've tried restarting the MySQL service, but that didn't help. What is going on here?

asked Nov 18, 2021 at 18:41

1 Answer 1

4

Turns out there's a bug in MySQL Workbench 8.0.23 which does not allow it to play nice with MySQL 5.6. The solution in my case was to uninstall MySQL Workbench 8 and install MySQL Workbench 6.3 instead.

answered Nov 18, 2021 at 23:27
1
  • This is showing as the version for Ubuntu 16.04. I have a ton of missing dependencies with this version. You're telling me it's 2022, and this still isn't fixed? I'll just use Ansible. At least I know that's reliable. Commented Jan 24, 2022 at 15:01

Your Answer

Draft saved
Draft discarded

Sign up or log in

Sign up using Google
Sign up using Email and Password

Post as a guest

Required, but never shown

Post as a guest

Required, but never shown

By clicking "Post Your Answer", you agree to our terms of service and acknowledge you have read our privacy policy.

Start asking to get answers

Find the answer to your question by asking.

Ask question

Explore related questions

See similar questions with these tags.