ThoughtSpot logo
Cloud
Software Mobile Spotter ThoughtSpot
Embedded SeekWell

Cloud

    • About this release
      • Release notes
      • Fixed issues
      • Known issues
      • Accessibility
      • Deprecated and removed features
      • Release life cycle
    • Getting started
      • Requirements and support
      • Features not supported in GCP
      • Activate your account using IAMv2
      • User onboarding experience
      • Finding your way around
      • New home page and navigation
      • Web notifications
      • ThoughtSpot browser access
      • Your user preferences
      • Use tags to organize
    • Free Trial
      • What’s new
      • Load CSV files
    • ThoughtSpot for…​
      • Business Users
        • Business user onboarding
        • Home page
        • Search Answers
        • Search Data
        • New answer experience
        • New Liveboard experience
        • Using Liveboards and Answers
        • Ask Sage
        • Collaborative Liveboards
        • Using Parameters
        • Search Assist
        • AI-suggested searches
        • Sage search
        • Best practices for Sage
        • ThoughtSpot Sync
          • Sync data to Excel
          • Sync data to Gainsight
          • Sync to Google BigQuery
          • Sync data to Google Sheets
          • Sync data to HubSpot
          • Sync data to Microsoft Teams
          • Sync data to Redshift
          • Sync data to Salesforce
          • Sync data to ServiceNow
          • Sync data to Snowflake
          • Sync data to Slack
          • Sync data to Zoho
        • Privileges
        • Google Sheets add-on
        • Google Slides add-on
        • ThoughtSpot Dev Slack app
      • Analysts
        • Analyst onboarding
        • Connect to data
        • Join tables
          • Supported join types
        • Create Worksheets in Setup
        • Create Worksheets
        • Create Models
        • Search Assist Coach
        • Sage search
          • Best practices for Sage
          • Sage enablement
          • Worksheet readiness for Sage
          • Sage feedback process
          • Sage Coach
        • Visualize search results
        • Create Answers in Setup
        • Create a Liveboard
        • Liveboard note tiles
        • Collaborative Liveboards
        • Linked Liveboard filters
        • Selective Liveboard filters
        • Mandatory Liveboard filters
        • Liveboard cross filters
        • Personalized Liveboard views
        • Create Parameters
        • Column Sets
        • Query Sets
        • Disable Answer Search for specific Worksheets
        • How Users are searching Answers Liveboard
      • Data Engineers
        • About connections
          • Share a connection
          • ThoughtSpot query tags
          • Column indexing with OAuth
        • Connect to Amazon Athena
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Amazon Athena
        • Connect to Amazon Aurora MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon Aurora MySQL
        • Connect to Amazon Aurora PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon Aurora PostgreSQL
        • Connect to Amazon RDS MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon RDS MySQL
        • Connect to Amazon RDS PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Amazon RDS PostgreSQL
        • Connect to Amazon Redshift
          • Add connection
          • Edit connection
          • Remap connection
          • Query external tables
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure AWS IDC OAuth
          • Configure Azure AD OAuth
          • Best practices
          • Enable a PrivateLink
          • Enable a Redshift-managed PrivateLink
          • Connection reference
          • Redshift Partner Connect overview
          • Passthrough functions for Redshift
        • Connect to Azure Synapse
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Connection reference
          • Passthrough functions for Synapse
        • Connect to Databricks
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Configure OAuth with AAD
          • Enable a PrivateLink
          • Connection reference
          • Databricks best practices
          • Databricks Partner Connect overview
          • Passthrough functions for Databricks
        • Connect to Denodo
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Denodo
        • Connect to Dremio
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Dremio
        • Connect to Generic JDBC
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Generic JDBC
        • Connect to Google AlloyDB for PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google AlloyDB for PostgreSQL
        • Connect to Google BigQuery
          • Prerequisites
          • Access levels and ingress rules for Google BigQuery
          • Add connection
          • Edit connection
          • Remap connection
          • Query external tables
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Connection reference
          • Passthrough functions
        • Connect to Google Cloud SQL for MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google Cloud SQL for MySQL
        • Connect to Google Cloud SQL for PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google Cloud SQL for PostgreSQL
        • Connect to Google Cloud SQL for SQL Server
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Google Cloud SQL for SQL Server
        • Connect to Looker
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
        • Connect to Mode
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
        • Connect to MySQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for MySQL
        • Connect to Oracle
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Oracle
        • Connect to PostgreSQL
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for PostgreSQL
        • Connect to Presto
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Presto
        • Connect to SAP HANA
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for SAP HANA
        • Connect to SingleStore
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for SingleStore
        • Connect to Snowflake
          • Add connection
          • Edit connection
          • Remap connection
          • Upload CSV
          • Query external tables
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Configure Azure AD OAuth
          • Configure Okta OAuth
          • Configure CSV Upload
          • Best practices
          • Enable a PrivateLink
          • Enable a GCP Private Service Connect between ThoughtSpot Cloud and your Snowflake data warehouse
          • Connection reference
          • Passthrough functions
          • Snowflake Partner Connect overview
          • Snowflake Partner Connect tutorials
        • Connect to SQL Server
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for SQL Server
        • Connect to Starburst
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Configure OAuth
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Starburst
        • Connect to Teradata
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Enable a PrivateLink
          • Connection reference
          • Passthrough functions for Teradata
        • Connect to Trino
          • Add connection
          • Edit connection
          • Remap connection
          • Delete table
          • Delete table with dependencies
          • Delete connection
          • Connection reference
          • Passthrough functions for Trino
        • Custom calendar
          • Create custom calendar
          • Update custom calendar
          • Delete custom calendar
        • AWS PrivateLink
          • Enable a PrivateLink for Amazon Redshift
          • Enable a PrivateLink for Databricks
          • Enable a PrivateLink for Denodo
          • Enable a PrivateLink for Dremio
          • Enable a PrivateLink for Oracle
          • Enable a PrivateLink for PostgreSQL
          • Enable a PrivateLink for SAP HANA
          • Enable a PrivateLink for Snowflake
          • Enable a PrivateLink for SQL Server
          • Enable a PrivateLink for Starburst
          • Enable a PrivateLink for Teradata
        • Query external tables
          • Query external tables from your Amazon Redshift connection
          • Query external tables from your Google BigQuery connection
          • Query external tables from your Snowflake connection
        • Integrate with dbt
          • Metadata tags for dbt
        • Alation catalog integration
        • Atlan catalog integration
        • Collibra catalog integration
      • IT and Ops
        • Managing users
        • Managing groups
        • Understand RBAC and privileges
        • Authentication overview
        • Managing local authentication
        • Identity and Access Management V2
        • Managing authentication with SAML
        • Managing authentication with SAML using IAMv2
        • Configure SAML group mapping
        • Search and SpotIQ settings
        • Email and onboarding settings
        • Scheduled maintenance
        • Style customization
        • Help customization
        • AWS PrivateLink
          • Enable a PrivateLink for Amazon Redshift
          • Enable a PrivateLink for Databricks
          • Enable a PrivateLink for Denodo
          • Enable a PrivateLink for Dremio
          • Enable a PrivateLink for Oracle
          • Enable a PrivateLink for PostgreSQL
          • Enable a PrivateLink for SAP HANA
          • Enable a PrivateLink for Snowflake
          • Enable a PrivateLink for SQL Server
          • Enable a PrivateLink for Starburst
          • Enable a PrivateLink for Teradata
        • OpenVPN for Google BigQuery
        • OpenVPN for Azure Synapse and Snowflake on Azure
        • Configure IPSec VPN for your cloud data connection
        • OIDC authentication
        • Custom domain configuration
        • Performance Tracking Liveboard
        • User Adoption Liveboard
        • Object Usage Liveboard
        • Billable Query Stats Liveboard
        • Indexing Queries Liveboard
        • Index Statistics Liveboard
        • ThoughtSpot use agreement
      • Developers
    • Search
      • Search Answers
      • Search Data
      • Search basics
        • Choose a data source
        • Search bar features
        • Search suggestions
        • Search results and column types
        • Last data refresh time
        • Work with Answers
        • Results that are tables
      • Use keywords in search
        • Time series analysis
        • Date filters for Answers
        • Search using growth over time
        • Using the keyword in for nested searches
        • Proximity search: near and farther than
      • Work with filters
        • Add a filter to a table
        • Add a filter to a chart
        • Create a bulk filter
        • Delete a filter
        • Filter on null, blank, or empty values
      • Other search actions
        • Change result display options
        • Show underlying data
        • See the search behind a result
        • Apply conditional formatting
        • Download your search
      • ThoughtSpot Sage
      • Query and autocomplete options
    • Charts
      • Chart types
        • Column charts
        • Stacked column charts
        • Line charts
        • KPI charts
        • Pivot table
        • Donut charts
        • Bar charts
        • Stacked bar charts
        • Line column charts
        • Area charts
        • Stacked area charts
        • Line stacked column charts
        • Scatter charts
        • Bubble charts
        • Waterfall charts
        • Heatmap charts
        • Treemap charts
        • Funnel charts
        • Geo charts
          • Geo bubble charts
          • Geo heatmap charts
          • Geo area charts
        • Sankey charts
        • Radar charts
        • Candlestick charts
        • Pareto charts
      • Changing charts
        • Change axes options
        • Configure the columns
        • Rename columns and axes
        • Customize titles and descriptions with HTML
        • Reorder labels
        • Set the y-axis range
        • Hide and show values
        • Charts with a large number of data values
        • Change chart colors
        • Show data labels
        • Show data markers
        • Add regression lines
        • Display gridlines
        • Zoom into chart
        • Advanced chart customization settings
      • Custom charts
    • Formulas
      • Add formula to search
      • View or edit formula in search
      • Semi-additive measures with first_value and last_value functions
        • Modeling semi-additive measure data for slowly-changing dimensions
      • Aggregate formulas
        • Cumulative functions
        • Moving functions
        • Flexible aggregation functions
        • Grouping functions
        • Keywords "of", "percentage of"
        • Filtered aggregation functions
        • Aggregate filters
        • Conversion functions
        • Date functions
        • Percent calculations
        • Formula operators
        • Nested formulas
        • Formulas for chasm traps
    • Liveboards
      • Edit Liveboard layouts
      • Liveboard tabs
      • Liveboard filters
      • Personalized Liveboard views
      • Verified Liveboards
      • Answer Explorer
      • AI Highlights
      • Schedule a Liveboard job
      • Search actions within a Liveboard
      • Copy a Liveboard
      • Copy a Liveboard or visualization link
      • Reset a Liveboard visualization
      • Present Liveboard as slideshow
      • Download as PDF
    • SpotIQ
      • Monitor KPI
      • Webhooks for Monitor
      • Custom SpotIQ analysis
      • SpotIQ change analysis
      • Forecasting
      • Anomaly detection
      • SpotIQ preferences
      • Insight feedback
      • Best practices for SpotIQ Analyze
    • Mobile
      • About this release
        • Release notes
        • Compare mobile and web
      • Getting started
        • Deploy
        • Install and set up
      • Features
        • Ask Sage
        • KPI change analysis
        • Internationalization and localization
        • ThoughtSpot mobile push notifications
        • Sharing with deep linking
        • Drill down
      • FAQ
    • Work with data
      • Set your display language (locale)
    • Share your work
      • Share Liveboards
      • Share Answers
      • Request access
      • Revoke access
    • Help and support
      • Contact support
    • Modeling
      • Improve search with data modeling
        • Change a table’s data model
        • Edit system-wide data model
        • Data model settings
          • Set column name, description, and type
          • Set additive and aggregate values
          • Hide a column or define a synonym
          • Manage suggestion indexing
          • Add a geographical data setting
          • Upload custom geo maps
          • Set number, date, and currency formats
          • Change the attribution dimension
          • Exclude from SpotIQ analyses
          • Chasm traps
          • Data types
        • Link tables using relationships
          • Create a relationship
          • Delete a relationship
          • Use tags
      • Content migration with ThoughtSpot Modeling Language
        • Import and export TML files
        • Migrate multiple TML files
        • TML for Answers
        • TML for connections
        • TML for joins
        • TML for Liveboards
        • TML for Monitor alerts
        • TML for SQL views
        • TML for tables
        • TML for views
        • TML for Worksheets
        • TML for Models
    • Administration
      • Support Handbook
      • ThoughtSpot editions
        • Administration
        • Usage limits
      • High Availability and resilience
      • Data Protection and Disaster Recovery
      • Multi-tenancy with Orgs
        • Orgs administration
        • Create, edit, or delete a user in a multi-tenant environment
        • Create, edit, or delete a group in a multi-tenant environment
        • Admin Console for Orgs
          • Create, edit, and delete Orgs
          • Managing users in a multi-tenant environment
          • Managing groups in a multi-tenant environment
          • Managing local authentication
          • Managing authentication with SAML
          • User Adoption Liveboard
            • User productivity
          • Performance Tracking Liveboard
          • Managing search and SpotIQ settings
          • Managing email and onboarding settings
          • Style customization
          • Scheduled maintenance
      • Manage data
        • How to view a data schema
        • Delete a data source
      • Manage users and groups
        • Understand groups and privileges
        • Create, edit, or delete a group
        • Create, edit, or delete a user
        • Create, edit, or delete a user using IAMv2
        • Manage user logins and sessions
        • Allow users to sign up
      • Enable Early Access features
      • Version control
      • Security
        • System security
        • Data security
          • Data and object security
          • Share tables and columns
          • Share Worksheets
          • Share views
          • Share Liveboards
          • Share Answers
          • Revoke access
        • Row-level security
          • How rule-based RLS works
          • Set rule-based RLS
        • Data masking with system variables
        • ThoughtSpot lifecycle
      • Simplify search with Worksheets
        • Edit a Worksheet
        • Create a formula in a Worksheet
        • Create a Worksheet filter
        • Define a custom sort order for a Worksheet
        • How the Worksheet join rule works
        • Create join rule or RLS for a Worksheet
        • Create a join relationship
        • Modify joins between Worksheet tables
        • Delete Worksheets or tables
        • Migrate or restore Worksheets
        • Worksheet TML specification
      • Work with views
        • SQL-based views
        • Save a search as a view
        • Create a search from a view
        • View example scenarios
      • Manage scheduled jobs
        • Scheduled Liveboards management
      • Monitoring
        • System Worksheets
        • System Liveboards
      • Troubleshooting
        • Generate a HAR file for ThoughtSpot Support
        • Network connectivity issues
        • Clear the browser cache
        • Cannot open a saved Answer that contains a formula
        • Search results contain too many blanks
      • Consumption-based pricing
        • Query-based usage
          • User actions and queries
          • Subscription and rollover
          • Billable Query Stats Liveboard
        • Time-based usage
        • Consumption data storage
      • Contact ThoughtSpot Support
    • Reference
      • Keyword reference
        • Dansk: Danish keyword reference
        • Deutsch: German keyword reference
        • English (American) keyword reference
          • Period to-date keywords
        • Español (España): Spanish keyword reference
        • Español (Latinoamérica): Spanish Latin American keyword reference
        • Français (Canada): French Canadian keyword reference
        • Français (France): French keyword reference
        • Italiano: Italian keyword reference
        • Nederland: Dutch keyword reference
        • Norsk: Norwegian keyword reference
        • Português (Portugal): Portuguese keyword reference
        • Português (Brasil): Portuguese Brazilian keyword reference
        • русский (ограниченный выпуск): Russian (Limited Edition) keyword reference
        • Suomi: Finnish keyword reference
        • Svenska: Swedish keyword reference
        • 中文 (简体): Chinese (Simplified) keyword reference
        • 中文 (繁體): Chinese (Traditional) keyword reference
        • 日本語: Japanese keyword reference
        • 한국어: Korean keyword reference
      • Date and time formats reference
      • Row-level security rules reference
      • Formula function reference
      • Alert codes reference
      • Search data error reference
      • Cluster-level settings
      • User action codes reference
      • Geo map reference
      • REST API reference
      • Glossary
      • Frequently asked questions
    • ThoughtSpot in practice
      • Reaggregation in practice
      • Liveboard schedule gating conditions in practice
      • Add a hyperlink to a search
  • Cloud
    • 10.3.0.cl
    • 10.1.0.cl
    • 10.0.0.cl
    • 9.12.5.cl
  • Home
    • master
  • Mobile
    • 3.0.0
  • SeekWell
    • latest
  • Software
    • 9.8.0.sw
    • 9.5.0.sw
    • 9.0.1.sw
    • 8.8.sw
    • 8.4.sw
    • 7.2
    • 7.1
    • 7.0
    • 6.3
    • 6.2
    • 6.1
    • 6.0
  • Spotter
    • 10.4.0.cl
  • Cloud
  • ThoughtSpot for…​
  • Data Engineers
  • Connect to MySQL
10.3.0.cl 10.1.0.cl 10.0.0.cl 9.12.5.cl

MySQL overview

You can connect to a MySQL database in ThoughtSpot Cloud, and perform live queries to create Answers and Liveboards.

You must use MySQL version 8.0.0 or later.

  • Add a MySQL connection

  • Edit a MySQL connection

  • Remap a MySQL connection

  • Delete a table from a MySQL connection

  • Delete a table with dependent objects

  • Delete a MySQL connection

  • Connection reference for MySQL

  • Passthrough functions for MySQL

Was this page helpful?Give us feedback!
×

ThoughtSpot is the Modern Analytics Cloud company. Our Live Analytics services deliver personalized, actionable insights at the point of impact for every user, at every level.

Product
  • Product
  • Auto Analyze
  • Visualize
  • Connect
  • Operationalize
  • Embed
  • Mobile
  • Govern & Secure
  • New features
  • Pricing
By Role
  • Business Leader
  • Data Leader
  • Analyst
  • Product Leader
  • Developer
By Department
  • Marketing
  • Sales
  • ServiceNow Analytics
Solutions
  • Banking
  • Financial Services
  • Retail & E-commerce
  • Manufacturing & Logistics
  • Healthcare & Life Sciences
  • Media & Communications
  • Procurement
  • Public Sector
About Us
  • Team
  • Customers
  • Atlas Marketplace
  • Partner Directory
  • Events
  • News
  • Careers
  • Blog
  • Legal
  • Trust
Connect
  • Free Trial
  • Resources
  • Request Demo
  • Professional Services
  • Community
  • Support
  • Contact Us

(800) 508-7008

©2024 ThoughtSpot Inc. All Rights Reserved
Terms of Use Privacy Statement Cookie Policy