Creating a User in MySQL

Video Transcript

"Hi, My name is Dave Andrews. Today I'm going to show you how to create a new user in MySQL. Let's go to the computer where I have a command line interface pulled up. Very first thing we have to is login to the database as a user who has permission to create new users. To do so, let's type mysql and then the user and root is most common one that's allowed to create new users. That dash u tells us to log in as root and the dash p tells is to ask me for my password. Now that I'm logged into the database, I'm going to create a new user. To do so, just say create user, and let's give it a name. Type a apostrophe. Let's type the name of the user. I'm going to say myuser, another apostrophe to end the user name and then an @ symbol like you do in an email. And then another apostrophe. And then we're going to type the the ip address or the computer that that user is allowed to connect from. I'm only going to allow my user to connect directly from the local computer. So let's say localhost and then a closing apostrophe and then a semi-colon. Let's say enter. And as you can see that query went okay and the user way create. Now let's set the password for that user. Set password for and then let's retype our user myuser with all the apostrophes @ the location he's allowed to login to equal to password all upercase "myuserpassword". Now notice I put that in parenthesis, because this password is a function that's going to create a hash of that password. Let's end it with a semi-colon. Say enter. Let's login as that user by exiting, running mysql again, but this time saying myuser and for the password my userpassword. I'm now logged in as that user. My name is Dave Andrews and I've just showed you how to create a new user in MySQL."