Build Your Own Business Website header image

Is there a way to change the Admin user name from admin after the site is created?

Difficulty Level -

Filed Under Topics - ,

Listed Under Lesson Subjects -

Whoops, you've found some premium content!

Watch the opening clip of this video to preview it,
the full video is available to paid members.

We demonstrate how change the Administrator user name.  The security for your WordPress installation is only as secure as it’s administrator user name and password.  WordPress formerly created an admin user that gave hackers half of the equation to your log in.  We use the instructions from the website www.splashnology.com/blog/wordpress/921.html.  We show you how to use MySQL to make the change.

Select the link below to watch a high definition version of this video

[S3VIDEO file=’public/liveanswers/LA12-27-10a-change-admin-login.mp4′ bgimage=’https://www.byobwebsite.com/wp-content/uploads/2012/10/LA12-27-10a-change-admin-login.jpg’ displaymode=’overlay’]

Video Transcript

Rick: We’re going to take a look at Sandy’s question. Is there a way to change login from Admin to something else after the blog is created? Yes and this is such a timely question because I was just sent a website by a friend here late last week which had directions on how to do that. Let’s see where that went…the site for this is www.splashnology.com/blog/wordpress921.html. That’s interesting – this guy probably has a WordPress blog but he thinks there is some reason why .HTML is helpful at the end of his page. And so he has his permalinks rewritten so that they have .html after the file name so that it looks like it’s straight HTML page and not a page that is generated out of the database by WordPress. That’s pretty interesting. Anyway, that’s off topic.

So then we come down here to… let’s see where is it? Right here to number 9, Kill the Admin. The problem is you get this admin login… it set up admin as the login originally and so the question is how do you fix that? And the answer would be that you would be updating the WP user login… I’m just going to demonstrate how to do that. So what we’re going to do is we are going to very quickly create a… where am I going to do that? I think I’m just going to go over to www.banner1.byobwebsite.com. Okay, perfect. And actually it looks like this has admin as the login. Let’s see if it does, I know it doesn’t. Okay, now so what we’re going to do is create an admin user. So we’ll come down to Admin and the username is going to be the Admin and the first name will be Rick and then rick@byobwebsite.com and okay, password. Just going to make it easy, bogus… because we’ll get rid of this anyway. Bogus. So we have an admin user and we’re going to add that admin user… oh, I want to make sure that we make that admin user a… let’s make that an administrator. We’ll update the user.

Okay, so we’ve done that. Now what we need to do is… well, let’s just make sure that works. So log out… we’re going to log back in as admin and then my log in is bogus. B O G U S. log in, okay. So I am now logged in as admin and we’ll go ahead and in fact, we’ll make a post. Add new post and this is a test post… and we’ll see what happens when we change the name and we’ll publish that. So if we view this post, you can see it’s a test post by admin. And so now if this works properly, we will be changing back – our log in name will change.

So let’s now… log out and then we will go into our… www.byobwebsite.com/cpanel. Okay. Confirm security exception… oh, yeah. So username is… and password is… okay. Now what we have to do is we have to find our banner1 database and the banner1 database probably is not going to be automatically obvious to me. If we go to PhpMyAdmin, you can see I have all kinds of databases down here and most of them do not have clearly descriptive names.

So what I have to do then is go to my file manager. This is a neat little trick – how to figure out which database it is if you got a bunch of them. And we would go to banner1 folder, we’re going to scroll down here to WP-config and we are going to edit it. Actually, we’re just going to read it. So the database name is wrd3, we can close that. And so it’s this one here, wrd3.

Now we are going to run that little query so we come back over to the site and what we’re going to do is we are going to complete this database query… so I’m just going to copy it for the moment. We’re going to be replacing this right here. And so then, I’m going to come back over to SQL, we’re going to place the query in here and instead of typing your login, I’m going to replace that with… we’re going to replace that with Ricky. Okay, so now this should replace all instances of admin with the user login Ricky and that should have eliminated or gotten rid of our admin login. Let’s go ahead and run it.

Okay, so it happened in one case so now let’s take a look and see if it works. So here we are and well first, let’s just try the old login. So you can see the old login doesn’t work anymore… admin and bogus didn’t work. Now if we change it to Ricky and then we go back to bogus and login, ta-ta-dah! It works.

If we switch this around, oh it just says admin there. Maybe I have to change my stuff on my users or profile. Oh, nickname… that’s what is happening here. The nickname is being displayed as admin but I could display it as Ricky and then pick Ricky, display the public name. That’s where you reset that but in any case, now if we just look at our list of users, we’ve got the name byobrick user which is the one that I created when I create one of these demonstration sites and then we have the one that used to be admin but is now Ricky. So if I log out, you see it’s not letting me log in that way. Log back in, this is my regular administrator, look at authors and users and there we go.

Sandy: That’s great. That’s exactly what I wanted to do.

0 Comments… add one

Save $200 on Membership Now!

Start learning today for as little as
$0.82 PER DAY!
THIS IS A LIMITED TIME OFFER!
Subscription Options
0 comments… add one

Leave a Comment