FlexSim连接MySQL时出现caching_sha2_password报错

小王子波

如果使用FlexSim的Database Connector连接MySQL数据库时，遇到如下图报错，解决思路如下：



错误提示“[i][color=#ff0000]Connetion Failed with Error: Authenticationplugin ‘caching_sha2_password’ cannot be loaded:[/color][/i]”


解决思路：更新用户密码规则：
[align=left][color=black][font="][size=9.0pt]ALTER USER [/size][/font][/color][color=#7F0000][font="][size=9.0pt]'bobcsn'[/size][/font][/color][color=black][font="][size=9.0pt]@[/size][/font][/color][color=#7F0000][font="][size=9.0pt]'localhost'[/size][/font][/color][color=black][font="][size=9.0pt] IDENTIFIED WITH mysql_native_password BY [/size][/font][/color][color=#7F0000][font="][size=9.0pt]'repalce by real [/size][/font][/color][b][color=red][font="][size=9.0pt]password[/size][/font][/color][/b][color=#7F0000][font="][size=9.0pt]'[/size][/font][/color][color=black][font="][size=9.0pt];[/size][/font][/color][/align]

中机国际

:)

zjj0605

强，谢谢分享

susan

强，谢谢分享

lulu-luka

Mark