[SOUND] In order to keep persistent data for

our application, we're gonna need to integrate a database.

Laravel takes this normally verbose process and simplifies

it, without taking away any of the power.

To start with, we're gonna get our local database

setup, and then integrate it within our Laravel application.

Now we have our routes, we have our controller, we have actions.

We have everything we need to get going on

creating a new form and storing that to a database.

But in order to store it to the database, we're gonna actually need the database.

So let's go ahead and get our database setup now.

We're gonna start by connecting and creating a database manually.

I'm gonna switch over to a tool.

I'm going to use SQLPro, and then we're

going to move to connecting the database to Laravel.

So, let's get started by connecting manually here in our terminal by going to

our project, and then doing a shell connection to our vagrant box, so vagrant.

Ssh, okay,so here we're gonna connect using our MySQL command.

Okay, and that will get us to our MySQL console, but we're gonna

need to pass through a username and password in order to access this.

So it'll be a -u for the flag, and then

the user, how do we find our username and password.

Let's go back over to the Homestead Documentation.

So, under docs, under Homestead, here you'll see Daily Usage, go

to Daily Usage and then you'll see Connecting To Your Databases.

So it tells we've already got a Homestead database created.

We have Laravel local database configuration is

already set to use that database by default.

Were gonna change all of that, but what

we care about is connecting to the actual database.

So, we would need to connect using username and password.

Here it says is homestead and secret, lets try that now.

[SOUND] Flag dash p.

And then it says that the password is secret.

Okay so now we are into the MySQL monitor.

And the first command that we're gonna run,

just to see what's here, is show databases.

Okay, so here we have information schema,

MySQL and performance schema which are standard.

And then the actual homestead database.

Now, we're going to create a completely different database to

use, and that database is going to be called odot.

So, let's go ahead and create that database here.

Or you can switch over to your tool of choice.

So what I'll do is create it here manually and then

show you how to do it on the MySQL tool SQLPro.

[SOUND] Okay now we're going to do the same thing.

Show databases, [SOUND] and now we see we have odot.

Okay let's exit out of here now that we know what our user name password is.

We know we have MySQL installed.

We know we have our databases setup how we want.

Let's switch over to a more graphical user interface based tool, SQLPro.

To exit the MySQL monitor just type exit, and then it says bye,

and then you may also exit homestead to go back to your console.

Okay.

So, opening up SQLPro we're gonna need to create a new connection.

What we're gonna do is actually create a

favorite because we're gonna access this quite often.

We're gonna call it Laravel homestead.

All right.

Here we're going to try to do a connection to Laravel homestead.

We'll do it with a standard.

We'll go to 127.0.0.1.

And then our username is homestead.

And our password is secret.

Okay and we don't need to specify the database.

Now port 3306 if we test the connection we're gonna get unable to connect.

So what we need to do is look over at the

documentation and you'll se at the very bottom of homestead Daily Usage.

Here are our ports.

So MySQL will need to connect at this port.

33060.

Try that.

Test the connection, connection succeeded so, let's go ahead and save our changes.

And then we're gonna connect.

Okay, so inside of SQLPro, we're gonna get this screen a little bit bigger.

Look at our databases and here you'll see we have homestead and odot.

So if we wanted to create our database here, cuz we've already created it before.

We're going to delete this database.

Okay?

Delete.

And then now you'll see we don't have that database.

So to create a new database, we'll do a,

go to the Database drop down and do Add Database.

And then we will use odot.

It can be the same as before, database and coding as default.

Hit Add, and now we have our homestead and odot.

We're only gonna be using odot.

So, here we have the structure, the content relations, so on so forth.

We have a lot of information we can add and we're gonna

go into SQLPro and add data once we've created our database manually.

Now that we've created our database manually, we've gotta here

our final step here is to connect this database to Laravel.

So we're gonna need to go back to our code,

and connect up our config database to this particular MySQL database.