tableau连接不上mysql或不显示mysql表的终极解决方法

【报错一】连不上mysql

An error occurred while communicating with MySQL
The connection to the data source might have been lost.
Error Code: 2868C972
The protocol is disconnected!
Unable to connect to the MySQL server "*****". Check that the server is running and that you have access privileges to the requested database.

【解决方案】

alter user ‘root’@’%’ identified with mysql\_native\_password by ‘你的root密码’ ；

【问题二】tableau可以连接了，但是不显示mysql数据库表

【解决方案】

grant all privileges on . TO 'root'@'%' ;
flush PRIVILEGES;