You can therefore use a MySQL database remotely in local development.

Even low-cost shared hosts offer MySQL with remote HTTPS or tunneled SSH connections. MySQL services are offered by AWS, Azure, Google Cloud, Oracle, and many other specialist hosting services. For more on MySQL, read Jump Start MySQL. This popular article was updated in 2020 to accurately reflect the current process for installing MySQL. The following sections examine three primary ways to use MySQL in your local development environment: That said, MySQL also supports NoSQL-like data structures such as JSON fields so you can enjoy the benefits of both worlds. While NoSQL databases have surged in recent years, relational data is generally more practical for the majority of applications. (It’s is functionally identical, so most of the concepts described in this article also apply to MariaDB.) MariaDB is a fork of the database created in 2010 following concerns about the Oracle acquisition of MySQL. MySQL is a free, open-source relational database.

This article discusses various options for using MySQL on your local system during development. Almost all web applications require server-based data storage, and MySQL continues to be the most-used database solution.