You say picking up right where we left off last time. You also recommend watching the earlier videos but you dont have anything Numbered? How am I supposed to know what is the first video and the next video.
@Johnny9ball: They are all in a Playlist. There is an annotation at the beginning and end of the video. OR, you can click the first link in the description.
I found out why the password has to be right next to the "-p". It's because you can do a command line query for a database and you leave a space after the "-p" option and use the database name. e.g. mysql -h localhost -u root -p users -e "show tables"
The "users" is the database name for the "-e" query. After you hit enter, it asks for the password.
@TheKaymor: I've never heard of a silvermoon database, so I know nothing about it, but I do go over importing and exporting data from/to the database in future tutorials.
You say picking up right where we left off last time. You also recommend watching the earlier videos but you dont have anything Numbered? How am I supposed to know what is the first video and the next video.
Johnny9ball 4 months ago
@Johnny9ball: They are all in a Playlist. There is an annotation at the beginning and end of the video. OR, you can click the first link in the description.
metalx1000 4 months ago
I found out why the password has to be right next to the "-p". It's because you can do a command line query for a database and you leave a space after the "-p" option and use the database name. e.g. mysql -h localhost -u root -p users -e "show tables"
The "users" is the database name for the "-e" query. After you hit enter, it asks for the password.
tardis2005 11 months ago
@tardis2005: oh, I thought it asked for the password if you didn't use the "-p" option at all. Good to know. Thanks.
metalx1000 11 months ago
Thanks Sir
tony757575 1 year ago
I'm using LAMP now and for a while MySQL just freaked me out!! Thanks for your post...
benghaith 1 year ago
after the mysql is setup is there a way in load a premade database in? like the silvermoon database for the wow private server?
TheKaymor 1 year ago
@TheKaymor: I've never heard of a silvermoon database, so I know nothing about it, but I do go over importing and exporting data from/to the database in future tutorials.
metalx1000 1 year ago
Wouldn't "SELECT fname, username FROM users WHERE lname='Jones';" be more suitable att 3:15 :)
skiller517 1 year ago
@skiller517: Don't get ahead. I have at lest 10 more videos coming. We'll get to all that later.
metalx1000 1 year ago