--- title: Production MySQL SSL with Teleport Machine ID | daily.dev description: A step-by-step guide walks through hardening MySQL TLS from basic self-signed encryption to full VERIFY_IDENTITY/verify-full mode using Teleport Machine ID. It... canonical: https://daily.dev/posts/production-mysql-ssl-with-teleport-machine-id-02xiidqru twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Production MySQL SSL with Teleport Machine ID | daily.dev og:description: A step-by-step guide walks through hardening MySQL TLS from basic self-signed encryption to full VERIFY_IDENTITY/verify-full mode using Teleport Machine ID. It... og:url: https://daily.dev/posts/production-mysql-ssl-with-teleport-machine-id-02xiidqru og:image: https://api.daily.dev/og/posts/02xIidQRU.png og:image:alt: Production MySQL SSL with Teleport Machine ID og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Production MySQL SSL with Teleport Machine ID **[Teleport](https://daily.dev/sources/teleport)** · 6 min read · 0 upvotes · 0 comments ## Summary A step-by-step guide walks through hardening MySQL TLS from basic self-signed encryption to full VERIFY_IDENTITY/verify-full mode using Teleport Machine ID. It covers issuing certificates from a central CA, configuring MySQL to require secure transport and client certificates, installing the Teleport Database Service, and using tbot to automatically obtain and renew short-lived mTLS certificates for application clients, including a sample Go program demonstrating the final connection setup. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How do I upgrade MySQL SSL from self-signed certificates to VERIFY_IDENTITY mode? Issue certificates from a central certificate authority instead of using mysql_ssl_rsa_setup's self-signed certs, since self-signed certificates encrypt the connection but don't verify the server hostname, leaving it open to MITM attacks. Configure mysql.cnf with require_secure_transport=ON, ssl-ca, ssl-cert, and ssl-key pointing to CA-issued files, then require client certificates per user with REQUIRE SUBJECT. _Teams hardening database TLS setups can track access-security guides like this on daily.dev._ ### How does Teleport Machine ID automatically renew short-lived certificates for database clients? Teleport's tbot program runs on the application host, reading a tbot.yaml config that specifies the auth server, join token, and a database destination directory. It writes a TLS certificate, private key, and CA certificate (e.g. tlscert, key, teleport-database-ca.crt) to that directory, which client apps then reference directly, with tbot continuously renewing them. _Developers automating certificate rotation for machine-to-machine access can follow security workflows like this via daily.dev._ ## Similar posts on daily.dev - [Stop managing SSH keys on every server and switch to Teleport](https://daily.dev/posts/stop-managing-ssh-keys-on-every-server-and-switch-to-teleport-zoja48gov) · All Things Open · 0 upvotes · 0 comments - [A visual guide to Public Key Infrastructure \(PKI\) Part 2 — When the Server Needs to Trust the Client](https://daily.dev/posts/a-visual-guide-to-public-key-infrastructure-pki-part-2-when-the-server-needs-to-trust-the-client-u3icrtiag) · Towards Dev · 0 upvotes · 0 comments --- Tags: [#mysql](https://daily.dev/tags/mysql) [View this post on daily.dev](https://daily.dev/posts/production-mysql-ssl-with-teleport-machine-id-02xiidqru) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Production MySQL SSL with Teleport Machine ID","url":"https://daily.dev/posts/production-mysql-ssl-with-teleport-machine-id-02xiidqru","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/production-mysql-ssl-with-teleport-machine-id-02xiidqru"},"datePublished":"2026-08-23T12:22:05.159Z","dateModified":"2026-08-23T12:46:36.439Z","description":"A step-by-step guide walks through hardening MySQL TLS from basic self-signed encryption to full VERIFY_IDENTITY/verify-full mode using Teleport Machine ID. It...","image":"https://media.daily.dev/image/upload/s--ZrL_HSsR--/f_auto/v1722860399/public/Placeholder%2006","thumbnailUrl":"https://media.daily.dev/image/upload/s--ZrL_HSsR--/f_auto/v1722860399/public/Placeholder%2006","isAccessibleForFree":true,"articleSection":"Teleport","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Teleport","logo":"https://media.daily.dev/image/upload/s--Dw-Bbw6O--/c_limit,w_256/f_auto,q_auto/v1787487494/logos/teleport?_a=BAMAMicg0","url":"https://daily.dev/sources/teleport"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/production-mysql-ssl-with-teleport-machine-id-02xiidqru","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"mysql","timeRequired":"PT6M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Teleport","item":"https://daily.dev/sources/teleport"},{"@type":"ListItem","position":3,"name":"Production MySQL SSL with Teleport Machine ID"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/production-mysql-ssl-with-teleport-machine-id-02xiidqru#faq","mainEntity":[{"@type":"Question","name":"How do I upgrade MySQL SSL from self-signed certificates to VERIFY_IDENTITY mode?","acceptedAnswer":{"@type":"Answer","text":"Issue certificates from a central certificate authority instead of using mysql_ssl_rsa_setup's self-signed certs, since self-signed certificates encrypt the connection but don't verify the server hostname, leaving it open to MITM attacks. Configure mysql.cnf with require_secure_transport=ON, ssl-ca, ssl-cert, and ssl-key pointing to CA-issued files, then require client certificates per user with REQUIRE SUBJECT. Teams hardening database TLS setups can track access-security guides like this on daily.dev."}},{"@type":"Question","name":"How does Teleport Machine ID automatically renew short-lived certificates for database clients?","acceptedAnswer":{"@type":"Answer","text":"Teleport's tbot program runs on the application host, reading a tbot.yaml config that specifies the auth server, join token, and a database destination directory. It writes a TLS certificate, private key, and CA certificate (e.g. tlscert, key, teleport-database-ca.crt) to that directory, which client apps then reference directly, with tbot continuously renewing them. Developers automating certificate rotation for machine-to-machine access can follow security workflows like this via daily.dev."}}]} ```