mysql8.0 修改用户SSL权限
2019-08-26 本文已影响0人
singlec
查阅网上关于设置用户必须使用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;
