From the course: PHP with MySQL Essential Training: 1 The Basics
Join today to access over 24,000 courses taught by industry experts.
Create a database
From the course: PHP with MySQL Essential Training: 1 The Basics
Create a database
- [Instructor] In this movie, we're going to log into MySQL and create our first database. In order to interact with MySQL, we're going to do that from our command line program. If you're on windows, that program is going to be Command Prompt, on Mac, it's going to be the Terminal. So here I am inside my Terminal application, and the first thing we want to do is make sure that we have MySQL installed. So if you don't have it installed already, you'll want to do that. Let's just check and see here, mysql --version, you see I have version 5.7 installed. It doesn't matter if your version is slightly different from mine, MySQL in general works pretty much the same in all the versions. And then we want to actually try to log in to make sure that it's running. We try mysql -u and I have a root user created. Every MySQL installation has a root user by default. I'm going to hit return, and you'll see that it doesn't open up for me. And that's because I didn't tell it that I had a password. By…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.