If we open up a web browser we should be able to now access and login to the
administrative panel. So, "localhost/phpmyadmin" and it's remembering my password from a
long time ago. Alright, let's update that password. So, now that we're in here you
guys are probably used to using this you know if you servers in the past that use
c-panel, c-panel myphpadmin as the MySQL management tool. So, basically you can create a new
database here, call it my "db" "create" and let's just create a
users table and have rows. Then, let's name the rows "ID", "username", and "password".
It's gonna be "255" So, an integer limit is 255, "VARCHAR" I believe is "999" it might be
more than that actually,
generally this is what I stick with. The password is going to be, we can do "MD5" even though it's not
great, let's just go "VARCHAR" we can probably change it later. "AI" means autoincrement, that basically
means let's say I add a user I'm not gonna specify an ID number, it's
automatically going to assign to the number "1" And, then the next user it creates is going
to be a assigned the number "2" and so on and so forth. So, we don't need to specify
you know ID numbers for each one, they will automatically be assigned. And, I mean this
is straight run of the mill phpmyadmin stuff. I'm not doing a tutorial
because I don't think it's necessary enough, but I will give you guys a heads
up on a few things. So, you can browse tables trhough here, you can create a new
table in the table you're automatically gonna be put to this, and you just click over
to structure to see the current columns to add or delete columns. Let me,
you can either use the SQL and you can write your own like to insert into
users and may even have these helpers down here for you. And, you can search through
the database, I've never done this I've actually found with phpmyadmin that the
search functionality is limited, and so I.. what was called..adminor?
There's another one that's really good a search, but not so great in
everything that phpmyadmin is. You can just go to insert here and I'll show you.
I'm gonna leave this blank, I'm gonna insert a user and then a password. I should be able to turn this
into "MD5" in here, hit go. If you go to browse, here's where you can actually browse the table's
data. So, right now we've got one entry you'll see the idea was automatically
assigned as "1". You can export your data base, so if you're switching hosts or
servers, let's say, you would need to export your data base. You can just do
this, hit go. It's gonna download the, actually that just downloaded the table. If
you go to the database and go to export, it's gonna export the entire database
in SQL format, or CSV, PDF you got all these options here, and to import the data base you would just
make sure you're on your database or table if you just wanted to insert a table,
and then you just browse for the file and it's pretty straightforward. You
can drop the table, you can rename it, you can copy it and it;s pretty much just all
standard stuff. That's how to get setup with phpmyadmin using an Apache web server
on Ubuntu. Thanks for watching, I hope you guys enjoyed this video.