HeidiSQL User Management - can't save SSL Options

Jxstin1337's profile image Jxstin1337 posted 4 days ago in General Permalink

Hey,

the commands in user management executed on MySQL/MariaDB 8+ doesn't seem to work when my user should have ssl options. If i define SSL options and try to save, it shows the error seen in the attached image.

I gave it specifications. However, the "Grant Usage "." on ....." doesn't work on MySQL/MariaDB 8.x. Especially if the user already exists.

Furthermore, the "AND"s are always missing between REQUIRE CIPHER '...' ISSUER '...', etc., so the command doesn't work anyway. If you create the user anew (directly with SSL), the "AND"s are also missing in the "Create User ..." command, which Heidi executes automatically.

1 attachment(s):
  • HeidiSQL-SSL-error

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