Users management mysql 5.6

romul's profile image romul posted 1 month ago in General Permalink

Since Heidi v12.12 i have a problem with users management. I'm adding access to a table for a user, as shown in the image. Then I save and get the following error. As far as I understand, the syntax is incorrect and doesn't match my MySQL version (5.6). Please, help.

1 attachment(s):
  • -_2025-11-07_173937700
romul's profile image romul posted 1 month ago Permalink

Error:

ALTER USER 'sokolov'@'%' REQUIRE NONE; / Ошибка SQL (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 /

ansgar's profile image ansgar posted 1 month ago Permalink

Yes such old MySQL versions were using different SQL statements for granting privileges. HeidiSQL does no longer support that old syntax.

MySQL 5.6 is from 2013, you should probably upgrade your server anyway.

notHeidi's profile image notHeidi posted 4 weeks ago Permalink

MySQL 5.6 is from 2013, you should probably upgrade your server anyway.

Ideally, yes, but it's not always that easy... still, I guess the answer (short of upgrading MySQL) is to run SQL commands directly in a query window.

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