🔥 AdonisJS From Scracth Early Access is Now Open!

Installing MySQL

Transcript

Adonis JS supports a handful of relational databases such as MySQL, Postgres, SQLite, and Microsoft SQL Server. In this course, we will use MySQL. Of course, feel free to use any of the other supported databases. So let's install MySQL. If you are on a Mac or Windows, the easiest way to install MySQL is using DB engine, which is a database version management tool.

So download the appropriate version for your operating system and follow the installation. Once DB engine is installed, you can open it up, and you should see a screen similar to this, of course, without the services because if you have installed it for the 1st time, you shouldn't have any services created yet. So to install MySQL, you simply click on the plus icon and select the service you want to create, which in this case is MySQL. Then you select the version of MySQL you want to install. Then you can give it a name, and you can leave out the other details so that it uses the default.

Then lastly, you can check this to automatically start the service upon login. That is when you start up your computer. Do note that by default, MySQL user is root with no password. That is empty password. This user and password is what you will use to connect to MySQL.

Then finally, we can click on the create button to create the service. Then we can click on the start button, which will install the necessary binaries and dependencies. So once that is done, we should have that version of MySQL installed and up and running on our computer. If you're on Linux, you can follow the official MySQL repositories to install MySQL depending on the distro of your Linux. So if you're on Ubuntu or Debian, you will use the MySQL apps repository, and you will download this and follow the installation accordingly.

After successfully installing MySQL, we should be all set. To access data inside our database, I will be using a tool called TablePlus, which is a database management system and it's available for the major operating systems. Though it's a paid software, but it has a free version, which is more than sufficient for our use case in this course, and that is what we'll be using. So download the appropriate version for your operating system.