So the first thing we have to cover is making databases.
We have to have some databases before we can then put stuff anywhere inside of those databases.
So it's a couple of steps that we need to go through before we can even really work with real data.
But this is a really important piece of using my SQL or really any SQL database.
So we've got our database server that's already installed and set up and within the world of a database
server, we can have a bunch of different databases.
So these are self contained sort of silos of information, silos of data and tables, which we'll learn
about shortly.
And they have nothing to do with one another.
It's important to know that our data isn't all floating around together in one soup, but rather it's
divided up into these discrete databases so we can have a dog walker database, a new site database,
just a practice database if you're trying things out and they're all separate.
So let's zoom in on just to dog Walker database and a soap shop database.
So we have a dog walking app and a soap e commerce store.
I guess both of these will have some data that is unique to them.
So we'll have some dog stuff, dog profile walkers, something like that inside of the dog Walker database.
And we'll have a soaps set of information in the soap shop database.
But they also might both have users, they might both have payments, but we want them to be separate,
right?
We can't have contamination where all of a sudden we're charging people in the dog walker database when
they buy soap or vice versa.
We want to have each set of data in its own little bubble.
So that's what we call a database.
So one more time we have multiple databases within a MySQL database server.
So the first thing we need to do as far as code is take a look at what database is currently exist.
When you install my SQL, there will be some default databases you probably won't need to touch them
at all right now.
Well, you definitely won't need to right now.
But this command show databases, we've actually seen it briefly when we installed this will show us
those databases.
So I'm going to flip between using the terminal and workbench in this video just to make sure we cover
all the bases.
The first thing we'll do is fire it up in the terminal.
So again, this command is my SQL view and then I'm logging in as root.
That's the only user we have right now.
And then I'm going to provide a password afterwards.
Dash P So I need to provide the root password that I set up.
And I hit enter.
And if I have the right password, this is what I see.
Now I'm going to clear my screen with control l just so you don't have to look at all this text.
And my prompt has changed to my SQL.
So I type stuff in here and I am in my SQL and I get an error because that doesn't mean anything to
my SQL.
But this should, if I do a show databases with a semicolon, if I don't have that semicolon, you'll
see that I get this arrow.
It's asking me.
It's kind of waiting.
It's like, okay, and then what?
You haven't terminated your command, but a semicolon tells my SQL, this is the end.
So what do we see?
We get this printout that says, Here are the databases you have right now, Information schema, my
SQL performance schema.
Sis, you really don't need to worry about these, but the fact that we see something tells us databases
exist.
That's kind of all you need to know now over in the workbench to log in to connect to the database.
I have this local instant connection.
I have to provide my password here, right?
Because the whole point is that we're doing this with a graphical interface, not via the command line.
And then what I can do is run this command.
I'm going to type.
Unfortunately, it can't make this much larger show databases semicolon, and I'm going to click that
lightning bolt.
And I get a result back.
And it's the same information, the same data it's just displayed in this app, right?
Information schema, my SQL performance schema.
So this same thing here, just two different ways of accessing that.
Now, this is not that exciting at the moment.
Not at all exciting because we don't have any new databases and that's going to change in the next video.