User manager playing up...

notHeidi's profile image notHeidi posted 4 weeks ago in General Permalink

Hello. I have an up to date version of Heidi, though my MySQL version is a bit old at 5.6, but I've had no issues until just recently I am getting errors with the user manager.

When I open it and click on an existing user (xxx) I see this is the output box:

SHOW CREATE USER 'xxx'@'localhost'; / SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'USER 'xxx'@'localhost'' at line 1 /

And if I try to add a new user, I enter the details, select an object (a table in my case), assign priveleges on it, on trying to save I get this in popupo:

SQL Error (1064): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'REQUIRE NONE' at line 1

After abandoning and closing the UM, on re-opening it I see that the new user has inf act saved, but without the privileges assigned.

...?

notHeidi's profile image notHeidi posted 4 weeks ago Permalink

Should add: I have also recently installed MySQL8, so have both instances running side by side - but this issue with Heidi is with MySQL5.6

When logging into Heidi to manage by MySQL8 instance, I can add a new user. So....

notHeidi's profile image notHeidi posted 4 weeks ago Permalink

AH sorry just seen the earlier post on this same topic - IDK how I managed to miss it before!

Ah well...

Please login to leave a reply, or register at first.