MyCAT support MySQL 8.0 client for authenication

[wangjuneng]

问题描述 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.

[junwen12221]

alter user 'admin'@'%' identified with mysql_native_password by 'your_password';

[wangjuneng]

this is the mysql mechanism,but the MyCAT can only support mysql_native_password authentication.

[zwyqz]

mycat2.0支持caching_sha2_password

[junwen12221]

http://dl.mycat.org.cn/1.6.7.6/20220419132943/