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.
...?