This website uses Cookies. Click Accept to agree to our website's cookie use as described in our Privacy Policy. Click Preferences to customize your cookie settings.
Accept
Reject
Preferences
Log in to ask a question
Log in to ask a question

error that says that looker cannot connect to my dataset

Posted 3 weeks ago
jufarbol
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

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?

jufarbol_0-1747775248070.png

 

jufarbol_0-1747774997792.png

 

 

Solved Solved
1 3 203
Jump to Solution
1 ACCEPTED SOLUTION

Posted on --/--/---- --:-- AM
jufarbol
Bronze 1
Bronze 1
Reply posted on --/--/---- --:-- AM

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;

View solution in original post

Jump to Solution
0 Likes
3 REPLIES 3