mysql8.0 修改用户SSL权限

查阅网上关于设置用户必须使用SSL的方式登录,大多都是:

GRANT ALL PRIVILEGES ON . TO 'ssluser'@'%' IDENTIFIED BY 'zdh1234' REQUIRE SSL;
或者
grant usage on . to 'test'@'%' require ssl

但是都会报错
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 ssl' at line 1

于是去mysql官网查看文档发现:

Image.png

所以正确的用法是:
alter user 'xxx'@'%' require ssl;
取消ssl验证:
alter user 'xxx'@'%' require none;