2 Replies Latest reply on Jan 7, 2019 7:37 PM by Lewis Wong

    MySQL Connection problem

    Alexandr Nicolaev

      Can't Conect to Mysql Server when adding DataSource to WorkBook.
      No Error displayed when Datasource added. But can't select Database on DataSource Page
      MySQL Server working, mysql user have full access from ANY IP to all databases (Checked using other IDE).

      Installed Server version (TRIAL) Linux Ubuntu with MySQL Drivers
      https://www.tableau.com/downloads/server/deb

      I made TCP dump at MYSQL port 3306 and found that no username transfered when connection established.

      Will appreciate any help.

       

       

      MySQL Drivers:

      [MySQL]

      Driver=/usr/lib/x86_64-linux-gnu/odbc/libmyodbc8w.so

      UsageCount=1

       

      [MySQL ODBC 5.3 Driver]

      Driver=/usr/local/lib/libmyodbc5w.so

      UsageCount=1

       

      [MySQL ODBC 5.3]

      Driver=/usr/local/lib/libmyodbc5a.so

      UsageCount=1

       

       

       

       

      Screenshot_1.png

       

       

      Screenshot_4.png

       

      Screenshot_3.png

        • 1. Re: MySQL Connection problem
          patrick.byrne.0

          Hello Alexander,

           

          There is definitely something that is not working as expected. In the first screenshot, there should be the ability to select a database under the "Database" header on the left side panel. After selecting the database a corresponding list of data tables should be made available and can be dragged into the view.

           

          Once the connection is established, you can move to the first sheet, and begin creating your visuals.

           

          Hope this helps!

           

          Cheers,

          Byrne, Patrick

          Community Manager

          Tableau Software

          • 2. Re: MySQL Connection problem
            Lewis Wong

            Have you tried the 'edit connection' option for this MySQL data source in Tableau Server?

            Press the 'test connection' button to test the if can connect or not.

            Also, you may edit port there.

            Linux Server has no problem connecting MySQL.

             

            I suspect issue is due to the network configuration to MySQL different between your Tableau Desktop machine and the Server machine.

             

            Hope it helps.

             

            Lewis