On this Craft Cms lesson you'll learn to setup and access your MySQL database locally.
It has been the best investment I made in my design journey so far. I would consider myself a novice but I honestly feel like I've gained a genuine professional insight into the process of creating a high-level website.
I'm an early adopter of the KreativePro Masterclass, and I love how well put together it is. Neftali takes you through each step of the process from paper sketches to marketing all with fun visuals & clear instructions!
Hey guys. Okay. So now the next and final step for this local environment set up, is just to make sure that we can, manage our database in this case, mySQL, both the one online in this case, Fortrabbit and our local one. So, what I want to do is be able to connect to that database. Directly from Sequel Pro.
All right. So if we go over to our dashboard and then go to the tab of mySQL, you're going to see a button called mySQL from local. And we're going to click on that. It's going to take us to a documentation. We just scroll down a little bit. And we're going to find the instructions we need in order for us to connect mySQL to the, Sequel Pro.
So the first thing is: go it over to our SSH connection. And then from there, just copy the values that it shows on the actual page. So for example, the SQL host name, we copy that, bringing that over, the username is SVR the host name on the SSH. You copy and paste that as well. The database sorry, the SSH user is the same as well. Click on the actual key icon and select our SSH.public. We're going to rename this connection so we can save it and bookmark it in our favorites. And finally, we're going to go back to our dashboard, click my SQL copy the SQL password, and we're going to paste that over into our Sequel pro.
And finally, we're just going to make sure we add the port number 3306. And we're going to click connect, make sure you do a test connection first, and if it worked, then it should be good to go. We can go ahead and connect. Once you are connected, you will see something similar to what we saw locally, which is just the database of craft already installed.On that database.
All right, once you have that, you can click on file and then you can save this connection as a favorite. So you don't have to go through that again. Let's go ahead and do that same thing for our local. So going to our terminal at nitro info, pull the IP address and then just add the info nitro as user and password.
What we want to do is just make sure we add the database craft/new so we can connect to that one faster and just like we did we go ahead and add that as a favorite, and we're good to go.
Okay. I'm just going to quickly rename this so that I can recall it whenever I need to connect again, future lesson, I'm going to teach you how to upload and sync those databases, both on the server and locally.
Coming Soon
Access our premium community including bonus tutorials, project files & weekly resources.
UNLIMITED ACCCESS