WEBVTT

00:02.820 --> 00:07.190
So before we can work with the database, naturally we need to have a database, so I've started up

00:07.200 --> 00:13.410
sequel ACE because I'm on a Mac and you start up whatever minuscule client you happen to use, and I'm

00:13.410 --> 00:16.680
going to create a new connection, which I will call widgets.

00:19.150 --> 00:25.660
And the host in my case is one two seven zero zero one, which is the local host and my username, I'll

00:25.660 --> 00:31.330
just put root because that's the default user after you install Maria DB, at least on a Mac, and I'll

00:31.330 --> 00:32.350
test my connection.

00:32.800 --> 00:33.820
And it succeeded.

00:33.820 --> 00:40.620
So I'll connect and I'll create a new database by saying ad database and I'm going to call this widgets.

00:42.160 --> 00:48.430
Now, I don't want to connect to my database as root, so I'll open the query window and type grant

00:50.050 --> 00:50.770
A..

00:50.890 --> 00:53.130
All on widgets.

00:53.530 --> 01:02.670
I'd star two and I'll put my name in single quotes at and then in single quotes I'll just one percent

01:02.680 --> 01:09.040
so I can connect from anywhere and then identified by and whatever I want for a password.

01:09.040 --> 01:13.270
And this is a development server and I'm going to delete this database when I'm finished this course.

01:13.270 --> 01:15.430
So I'll just use secret OK.

01:15.850 --> 01:21.090
And I'll terminated with a semicolon and say run previous and there are no errors.

01:21.100 --> 01:26.290
So we've now created a database and we can use this connection information, your username and your

01:26.290 --> 01:29.170
password to connect to the database named Widgets.

01:29.170 --> 01:31.780
And we'll get started on that in the next lecture.