Please read: Work with your IT team or DBA before performing the below steps, as they are outside of the scope of Tableau Technical Support. We've made this information available as a TabWiki Document because the information might be valuable, but some steps may vary due to third party product changes and specfic environments.
These steps should be followed for use cases which involve a greater level of DBA tuning than RDS. To set up a simple RDS instance of MySQL see Creating a MySQL DB Instance and Connecting to a Database on a MySQL DB Instance - Amazon Relational Database Service .
Connecting to a MYSQL database hosted in AWS.
- Launch a Linux VM on Amazon console.
- Click "Review and launch".
- Select "Create new key pair".
- Give it a name (for example, testkeypair) and then click on download.
- Once the key is downloaded, click "Launch Instances".
- On the Launch Status page, click the helpful resource "How to connect to Linux instance"
- Then, click the link "Connecting to your Linux instance using SSH" and read the documentation.
- Note: for PuTTY to connect you only need the DNS name of the instance: https://docs.aws.amazon.com/AWSEC2/latest/UserGuide/putty.html
- In the PuTTY key generator, load testkeypair.pem previously saved
- Note: Puttygen.exe and Putty.exe available here: http://www.chiark.greenend.org.uk/~sgtatham/putty/latest.html
- In PuTTY key generator, save to private key testkeypair.ppk.
- Using Putty.exe, expand SSH > click Auth > load the testkeypair.ppk file
- Using Putty.exe, click Session > paste the DNS name of the instance > Name the connection (for example: test) > Click Save
- After saving the connection , double click to open it
- In the prompt:
- Insert the the universal username to connect using your key pair: type, login as: name-user
- Install MySQL Server by typing: sudo yum install mysql-server
- Start MySQL Server: sudo /sbin/service mysqld start
- Secure MySQL server installation: sudo /usr/bin/mysql_secure_installation
- Ensure to answer carefully to each question
- Log in to MySQL as root: mysql -u root -p
- Grant user root access to connect from everywhere: GRANT ALL ON *.* to root@'%' IDENTIFIED BY 'test';
- Install MySQL Workbench and create a test Schema and a test Table to successfully connect from Tableau Desktop
Note: Login and update the above information if Menus/Options evolve, or if the above information is incorrect.