error that says that looker cannot connect to my dataset

[jufarbol]

What can I do when I have my report working fine and at this time is showing an error that says that looker cannot connect to my dataset, but my mysql server is up and running the same as always without changes?

[rob_shelby]

I'm experiencing the same error. Bigquery data connections that worked perfectly yesterday, today I can't even save without any changes.

[amybsharlin]

same issue 

[jufarbol · Accepted solution]

Finally found the fix for this on MySQL, it was to change the authentication method of the database with...

ALTER USER 'usuario_looker'@'%' IDENTIFIED WITH mysql_native_password BY 'tu_clave_segura';
FLUSH PRIVILEGES;