1

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?

1

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.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.