【Amadeus原创】tableau连接不上mysql或不显示mysql表的终极解决方法

2年前 (2022) 程序员胖胖胖虎阿
223 0 0

【报错一】连不上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;

相关文章

暂无评论

暂无评论...