MyCAT support MySQL 8.0 client for authenication
wangjuneng opened this issue · 4 comments
问题描述
A clear and concise description of what the problem is. Ex. I'm always frustrated when [...]
MySQL 8.0 client use caching_sha2_password authentication plugin as default authentication .
When MySQL8.0 client sent AuthPacket not contain password
描述您想要的结果及解决方案
A clear and concise description of what you want to happen.
when AuthPacket auth plugin name is null or not equal mysql_native_password
MyCAT send AuthSwitchPacket which auth method name is mysql_native_password
The next stage will deal with the same logic as before
额外内容
Add any other context or screenshots about the feature request here.
alter user 'admin'@'%' identified with mysql_native_password by 'your_password';
this is the mysql mechanism,but the MyCAT can only support mysql_native_password authentication.
mycat2.0支持caching_sha2_password