KreativePro Masterclass
Hello, {first_name}
3.3
Database Installation
Learn to Build Websites with Craft Cms
Completed
Oops! Something went wrong while submitting the form.
Completed
Browse Lessons
38
lessons
4
hours
MINUTES
2
files
Level

Access our premium community including bonus tutorials, project files & weekly resources.

UNLIMITED ACCESS
Overview

Database Installation

On this Craft Cms lesson you'll learn to setup and access your MySQL database locally.

Reviews

Manases
Being the best means investing in the best, no matter what level you are at, this course will take you through the entire process you need to be able to implement an idea and turn it into a fully functional business.
Manasés Padilla
Photographer & Entrepreneur
Noel
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.
Noel Hale
Founder of Slush Monkeys®
Mae
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!
Mae Green
Product Designer @ Dropbox

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

Designers ultimate weapon of choice
38
lessons
4
hours
MINUTES
2
files
Level
Digital Media Masterclass by Neftali Loria

Neftali Loria

Author & Instructor
@kreativepro
KreativePro Masterclass Bundle

Access our premium community including bonus tutorials, project files & weekly resources.

UNLIMITED ACCCESS
PRICE INCREASE:
00
Days
00
hrs
00
mins
00
secs
🚀