Get to know MySQL

As a free, lightweight database that includes the core SQL tools you need to store relational data, MySQL quickly became the default database developers would use for new apps. It's the M in the LAMP stack), as the common server configuration of Linux, Apache, MySQL, Perl/PHP/Python is called. Post-acquisition, MySQL is still the world's most popular open source database engine—second only to Oracle's own proprietary database engine with roots tracing back to 1977. You can still download and run MySQL for free, and tweak its open source core to work the way you want. Or, for enterprise deployments, Oracle today offers enterprise and cluster editions of MySQL with additional features and support.

MySQL includes all the standard relational database features, with cross-platform support that lets you run your databases on almost any platform and an information schema to define and manage your metadata. You can build a relational database that stores as much data as your file system allows, with up to 256TB of data in each table by default that can be increased if you need. You can use SQL commands to find, view, and manage data, with user-level permissions and customized views that show only the data each user should be able to see. MySQL can replicate data to offer additional durability, and can partition your tables when they grow too large for better performance.

MySQL also supports multiple storage engines, connectors, plugins. Storage engines—such as the default InnodB, the simple CSV storage engine that saves data to a comma separated text file, or Memory which saves data in ram for fast access—let you choose how data is stored, with unique engines to process SQL requests for the type of data table you need. Connectors—or database drivers—help you connect MySQL to applications using standard languages like ODBC or toolkits for .NET, Node.js, Python, C++, PHP, and more to build your own applications. And extensions let you add on to your database, giving it extra features beyond core SQL commands. That's what Oracle's enterprise editions of MySQL include, and you can write your own or find extensions online to enhance your database.

You'll run MySQL via Terminal by default, as the back-end of your applications. With some apps, like WordPress, you may never have to touch the database itself, interacting with the database through the blog editor instead. Or, you could use a tool like phpMyAdmin to browse through your database and customize it from any browser. If you want a simple way to build your own personal database in MySQL, LibreOffice Base gives you an Office-style interface to build MySQL powered databases with tools that work similar to Microsoft Access.

As part of your next enterprise app, just for a personal database, or as the magic behind the scenes in the apps you use every day, MySQL is one of the core pieces of software that keep our modern world of apps running. It's the open source database engine you should try first, the tool that'll likely keep managing your data in one way or another for years to come.

MySQL Resources:

  • Find anything you need about MySQL with the MySQL documentation and reference manual.

  • Learn more about MySQL's latest features with the MySQL Developer Zone blog.

  • New to SQL? Learn the basics with the SQL Quick Reference.

  • Learn how Zapier uses MySQL and other tools to automate billions of tasks.

Do more with MySQL

Zapier allows you to instantly connect MySQL with 2,000+ apps to automate your work and find productivity super powers.

Connect to 2,000+ Apps

Google Sheets

Google +1Google, Spreadsheets

40 Integrations

Facebook Lead Ads

Ads & Conversion +2Ads & Conversion, Facebook, Premium


Email +1Email, Google

30 Integrations


MySQL Alternatives

See All

Firebase / Firestore


MySQL Updates

New for Our MySQL Integration: Run Automations on Updated Rows