I want to write a query in Metabase where by default it would extract data for the last 7 days but if the filters are selected it would extract based on the filters. Can someone help with this?

I have a problem with the following code:
select
sum(Subtotal) as faturamento,
cast(Created_At as date) as Dia
from Orders

I am using digital ocean managed mysql database.
The connection is working since last 1 year. Suddenly the issue arrises.
Could not connect to address=(host=intercity-periphery-do-user-4241529-0.b.db.ondigitalocean.com)(port=25060)(type=master) : Client does not support authentication protocol requested by server. plugin type was = ‘mysql_native_password’