So before we can work with the database, naturally we need to have a database, so I've started up
sequel ACE because I'm on a Mac and you start up whatever minuscule client you happen to use, and I'm
going to create a new connection, which I will call widgets.
And the host in my case is one two seven zero zero one, which is the local host and my username, I'll
just put root because that's the default user after you install Maria DB, at least on a Mac, and I'll
test my connection.
And it succeeded.
So I'll connect and I'll create a new database by saying ad database and I'm going to call this widgets.
Now, I don't want to connect to my database as root, so I'll open the query window and type grant
A..
All on widgets.
I'd star two and I'll put my name in single quotes at and then in single quotes I'll just one percent
so I can connect from anywhere and then identified by and whatever I want for a password.
And this is a development server and I'm going to delete this database when I'm finished this course.
So I'll just use secret OK.
And I'll terminated with a semicolon and say run previous and there are no errors.
So we've now created a database and we can use this connection information, your username and your
password to connect to the database named Widgets.
And we'll get started on that in the next lecture.