I was trying the activeRecord to connect to the MySQL server which giving me the following error “Unable to connect to the database. Authentication plugin ''caching_sha2_password cannot be loaded: the specific module could not be found”. I can connect the same server using ODBC but the existing MySQL plugin also shows this particular error? any suggestion how to solve this issue?
Solved: create a new user with standard authentication instead of caching_sha2_password will solve the issue.