1 Reply Latest reply on Jan 10, 2018 12:45 PM by Chris McClellan

    Tableau Desktop IP not connecting to remote MySQL

    Devin Smith

      Hi All,


      I am trying to connect to my remote MySQL database with Tableau Desktop however I am getting kicked when attempting to establish the connection,


      I have added my PC's IP address to the remote MySQL access however still getting the error,


      Do you know Tableau Desktop perhaps uses a different connection to gain access other than using my PC's internal network?


      Currently I am having to establish a remote connection through a third party site, replicating the data to Google BigQuery then connect Tableau to BigQuery to pull the data - just not viable.


      Thanks in advance.


      Devin Smith

        • 1. Re: Tableau Desktop IP not connecting to remote MySQL
          Chris McClellan

          Are you at work or at home when you're doing this ?


          If you've configured mySQL with the proper IP address it should work, but there's a few reasons why your IP isn't the IP that the server will see.


          Do you have a way of checking what your IP is by the time it gets to the mySQL server ?


          An easy way might just be to google "what is my IP" and checking it that way.


          Sorry for all the questions, but I think it's a network/environment configuration rather than Tableau doing something wrong.