Mysql 8.0.13 connect error


#1

when i was installing piwik with mysql 8.0.13, the page showed the following eorror:
Error while trying to connect to the database server: SQLSTATE[HY000] [2054] The server requested authentication method unknown to the client
after searching on csdn and other forum, most blogs tell that the error is caused by the encyped code-caching_sha2_password- of 8.0.13 edition,
is there any effective ways to solve this error?