5 Great Tips You Need to Know About phpmyadmin
Phpmyadmin can be kinda scary thing to look at. Sometimes you need to go inside and make some changes because of lost password, migrations and many other reasons. Today we have 5 great tips that will get you more comfortable at navigating phpmyadmin
Today on UV Design Tips and Tricks, we show you five great tips you need to know about phpMyAdmin. Alright, before we get started with today’s tutorial, I have kind of a pre-announcement, stay tuned at the end, I have some exciting news about somethings we’re going to change already on the channel, it’s for the better. And I’ve already been told by one of the viewers that it would help out a lot, so we’re going to do it. Hurray for this, yay, stay tuned.
Alright, so phpMyAdmin, it can be a very scary thing when it comes to databases, because you’re not used to seeing it, it’s not very well explained, and it’s just scary looking, right. So today we’re going to show you five great tips that you should know about being inside phpMyAdmin, and working on your database. So what a database is, it stores data for your website, users, content, how websites work, WordPress, Druple, Joomla, and tons of other types of websites, custom websites, all use databases. The two most common ones are MySQL, which are used on Linux servers, and which can be used on Windows servers, and then you also have MSSQL databases, and those are only ran on Windows operating system servers.
Today we’re going to be talking about phpMyAdmin, which is basically the interface to take a look at MySQL databases, and stuff. So here, we have our database, Fix In Post Films, this is the database that we’ve been using for these past WordPress tutorials, and we’re just going to take a look at here. So, for number one, I have an error token mismatch, that’s fantastic. So let’s even backtrack even earlier to going jump right into the database. You have cPanel right here, again your cPanel might look different, you might not even have cPanel. But if you have a database, there’s a way to get inside there, it’s through phpMyAdmin. And here we go. Sort of, slowly.
All that kind of works the same, no matter if you’re using Joomla, Jouple, I mean even a custom database, they all work the same as long as you have everything labeled correctly, and working in a beautiful fashion, your database will be amazing. So again, we’re just using a WordPress database, but most of these tips are for general phpMyAdmin, and generally MySQL databases, so it’s not specifically for WordPress, we’re just using a WordPress database.
So the number one thing I’m going to show you here is users. Again, in WordPress it’s whatever prefix underscore users, Joomla it’s the same, Jouple it’s the same, and again, if you custom created yours, I hope you named your users, unless you didn’t, you named it somewhere else, then again, you probably wouldn’t be watching this tutorial, because you already know what you’re doing. So anyways, click on Users, and in this row, make sure you have Browse on here, make sure Users is clicked, and here is your user. You can’t have a lot more users, again, if you have people signed up, if they’ve bought stuff through your store before, through like root commerce or anything, you’re going to see all your users when they log in, this where it’s stored at. I don’t have anything else to log in but me, so here’s the only one you will see. So, here we have this, so you sign in here, and man, I don’t remember my password.
What do I do? Well you go inside phpMyAdmin, and you change it. So, we’re going to click Edit, and we have each now, row that makes up that particular user, and here we have password. So this is password that’s encrypted, we won’t know what that is. And there’s no way of knowing what that is, so you have to change it. You can change it to whatever you want. For the sake of this tutorial, we’re just going to call it password. I hope to God, Jeebus, higher on up powers, whoever you look up to, that you do not use password as your actual password, we’re just using it for the sake of this tutorial.
And then the major next thing you need, the major next thing, a very important part of this is, you can’t just hit GO, GO is like Save, in phpMyAdmin, you have to tell it what type of encryption, you have all these different types, that the database, or phpMyAdmin can encrypt the database for, or encrypt the password to. And we want to do MD5. I’m going to be super honest with you, I don’t know what that means, and I don’t why it’s over that, I just know that’s the one you need to choose.
Again this works for Joomla, Jouple, all the major content delivery, applications. And I’ve seen it used on custom ones too, again, if you’ve use super custom databases, you’re not watching this, so anyways. Go ahead and click GO, and now, you have a funky looking, super-weird password. But again, that’s just encrypted, so in case anyone ever breaks into your database, they won’t know the password for your users, inside website, but if they’re inside the database, their probably inside your website. Eh, let’s not even think about that, scary stuff. Okay, so that’s number one, tip number one, how to change your password. And since we’re in this lovely field, let’s say you had a developer give you a website, but they put in their information, so when you do the lost password, you never get the email.
Well, here’s how you update the email, you can change your email right here, and this is my email address, which I shouldn’t probably have up here, but whatever, it’s fine, I don’t use it for anything anyways, besides spam, so yay. Again you can click Edit, change the email to be whatever, and click Save, and now the email is saved. So if you do a lost password, that is the email address it’s going to go to. Now, on some newer versions of phpMyAdmin, you have this great way of, you can just double click in the field, and change it right there, so it’s pretty handy dandy.
You can’t do the password from there, since you can’t tell it what encryption method to go to, so yeah, so we’re going to go ahead, got my old password saved, I’m going to put it back. And bam. Now the third thing you want to do, is let’s say you need to move your website somewhere, and they tell you to export out your database. Well, tip three, is to show you how to export your database. So you’re going to go up here, well, first of all, you want to make sure you click on your database, so you see all your tables right here. You’re going to click Export, and you’re going to do a quick one or a custom one. Custom, you can select certain tables, if you just want to export out certain tables, save different files and all this other stuff. Again, if you’re doing this, you’re probably not watching this, for the sake of this tutorial, you’re just going to do a Quick, because you want the whole database backed up anyways, and saved, Format, we want SQL, and then hit GO. And then there you go, the database is now, saved to your computer.
Yay. So, let’s say, now for tip number four, we’re going to show you how to drop these tables, dropping tables means you’re basically, clear out the database. You can clear out individual tables this way, by clicking Drop, and this will delete and remove all things associated with this particular table. We’re not going to do that, there’s not a lot of scenarios where you need to just drop one table, especially if you’re using WordPress, Joomla, Jouple, things like that. So what you do is, you’re going to come here, Select All, Check All, check whichever one, it does all the same thing, go here, go here to drop this down, and you want to hit Drop, and here’s all the tables you’re going to drop. Are you really sure you want to do this? Yes I am, so click Yes. And then now your database is empty.
The reason why you want to this is, in case you’re importing a database to a fresh installed WordPress, you need to drop the default table, so you can add your own. And so let’s say, that’s what we’re doing, so we just did a fresh install WordPress, I’m going to drop the tables, now I want to import my database from my developer, or from my other server.
So then you click on here, no tables found, oh geeze, what do we do? Well, we have this beautiful Import button right here, we select that, choose your file, you can either click on here, like any other normal, and peruse for your database. Or you can just literally drag your database right on here.
Now sometimes you won’t get this screen, depending on your phpMyAdmin. Well, I don’t even know why that did that. That’s weird. Again, I don’t know why it’s doing that, it’s so weird, anyways. We’re just going to go like this, choose file, I feel awkward now, like I don’t know what I’m talking about, but it’s fine, it’s really, really fine.
Alright, there it is, I’ve got a lot of stuff in my Downloads folder, don’t look at it though, just look at this. Okay, now here we go, here’s the name of the database that we’re importing, max is 50 megabytes, so let’s say you have a database that’s like, let’s say, 300 megabytes. You would still do the same process, choose a file, upload and hit GO. And it’s going to sit here and spin, my screen is going to say, congratulations, you’ve uploaded a database, whoo-hoo, we’ve uploaded this many tables.
But let’s say you have a database that’s very large, like a 400 meg, a 300 meg database, in your system. Well, what you’re going to do is, and the reason why it says this error, is because I did the other drag and drop, and it put the wp comment meta table there. So it’s whatever. It’s still fine, because look, all the tables are here, it looks great.
So go back to my other thought, is if you have a 300 meg or plus, or 50 meg plus database, you’re going to click Browse, click GO, it’s going to sit here and spin, spin, spin, spin, spin, spin, spin, spin, spin, spin, spin, spin, spin. And it’s going to upload, basically, 50 megs of that database, then you’re going to get a nice error message, I don’t even know if it’s an error message, it’s just more like a, of a warning I guess, saying, we have stopped importing your database, if you would like to continue from where we left off, go ahead, browse for that same database, and click GO again.
And then it’s going to start from where it stopped, and it’s going to do the next 50 megs, and then it’s going to do the next, and the next, rinse and repeat, rinse and repeat, rinse and repeat. So it’s kind of time consuming, but you know, hey, you have a very large database, and that’s how you take care of it. So, yeah, don’t have large databases, just, you know, if you have a large database, you’re probably doing pretty well. Or you have a lot spam comments.
So that’s it, that is my five tips for phpMyAdmin, those are just some common ones that I’ve had people ask me about, especially the first two, how to update the email, and how to update the password for you. So that’s it for today. So, to go back to my exciting news, what I’ve decided to do is release two videos a week, that is two, T-W-O. On Mondays, I’m going to release videos, that talk about WordPress, and building out that WordPress site for FixItInPostFilms.com learning how to design, use, themes plugins, and make it pretty for the world to see. And then on Wednesdays, I’m going to do, well, maybe Wednesdays or Thursdays, haven’t debated, but anyways, the second video of the week, is going to be more on hosting support, tips and tricks for hosting cPanel VPSs, phpMyAdmin, things like that.
It’ll be a good way to separate the two, make life simpler, and not so confusing, for viewers, and kind of get an idea of how we do things, and kind of, maybe you only want to watch Mondays, maybe they only want to watch Wednesdays. I don’t know, you choose, watch them all, they’re pretty fantastic.
So yeah, that’ll do it for us today, make sure, if you like the video, go ahead and hit the Like button below. If you enjoy the videos, or would just like to do me a solid favor, hit the Subscribe button below, and check out some of the other videos, they might be very helpful for you to make life easier. Until next time, take it easy.