# Set Up a Local Database

There are plenty of ways to set up a database for local development. You can use Docker containers, install locally using Homebrew or other tools, and various other GUI tools.

My option of choice is [DBngin](https://dbngin.com/). It is a simple tool that lets you add databases quickly for whatever you need including MySQL, Postgres, and even Redis.

![DBngin Services](https://dev-to-uploads.s3.amazonaws.com/uploads/articles/ie9ra9bis4vh1zhzdgz0.png align="left")

I am going to create a MySQL database.

![Create a MySQL database in DBngin](https://cdn.hashnode.com/res/hashnode/image/upload/v1696377836641/5635fdf1-bd95-4722-8d33-63db3bad1ed5.png align="left")

...and it is just that simple! Now just start the new database and DBngin will take care of the rest!

![Running service from DBngin](https://cdn.hashnode.com/res/hashnode/image/upload/v1696377837966/6f959852-7f5b-49fb-8394-72246f678d0a.png align="left")

DBngin also happens to be made by the company behind my favorite database GUI tool, [TablePlus](https://tableplus.com/). If you use TablePlus, you can click on the arrow next to the "Start/Stop" button and open the database right in TablePlus.

![TablePlus](https://cdn.hashnode.com/res/hashnode/image/upload/v1696377839436/161dbf33-1e9c-4efa-940e-095d43f9fbaa.png align="left")

From there, it is easy to create databases, and tables, and set up users.

![Creating tables and databases in TablePlus](https://cdn.hashnode.com/res/hashnode/image/upload/v1696377841675/6edc76f9-0a48-45a5-adca-91d8a30319bf.png align="left")

A future post can go into more MySQL or TablePlus usage, but if you want to dive deeper into MySQL, I cannot recommend the [MySQL for Developers](https://planetscale.com/learn/courses/mysql-for-developers/introduction/course-introduction) course on Planetscale by Aaron Francis enough. It is a fantastic resource and even if you have been using MySQL for a while, I am sure there will still be something to learn!

I know this was a simple post, but hopefully, others getting started in their careers can find it helpful.