Resetting a WordPress admin password

I'm a full-stack developer from South Africa 🇿🇦. I love writing about JavaScript, HTML and CSS.
Search for a command to run...

I'm a full-stack developer from South Africa 🇿🇦. I love writing about JavaScript, HTML and CSS.
Concise. Thanks for sharing. Now I know what to do when faced with such challenge.
Your welcome, it's one of these things once you know it's fine else you'll spend so much time looking for it.
Most of you know me for my consistency, a golden arrow in my blog series. I've written 1000 articles in 1008 days! Almost an article a day, and my honeymoon was the only holiday I ever took. I'm super proud of this achievement; it has been a fantasti...

It's not the first time I'll be talking about community. I think it's an essential aspect of any successful tool. This shows in my previous explorations of Astro, Medusa, and now Vendure as well. All these products thrive in a super open, welcoming, ...

The cool part about Vendure is how easy it is to set up and how abstract each layer is. Basically, we get the following elements: External database Server Worker Admin UI Frontend While this is amazing, it also brings a bit of complexity when it co...

The previous article looked at customizing Vendure on a data and process level. In this article, we'll look at customizing emails, as they are often a big part of a webshop system. We'll be looking at two different layers of customization for customi...

Even though Vendure is a pretty significant project out of the box, in some cases, we might want to go in and modify some elements to work to our specific use case. In this article, I'll take a high-level look at some elements we can customize within...

I'm not particularly eager to work on WordPress, but sometimes you inherit legacy code or have to support a client.
The worst thing is where you get access to the database, but nobody knows the login anymore.
So how do we go about changing the admin's password?
Pre: You must have access to the database!
The first thing we need to do is log in to phpMyAdmin and find our database.
Then we need to open up the wp_users (wp can be underscored by something unique for your install).

Now we need to click the edit button on the admin record.
In the password field, add the new password in a readable way and choose MD5 as the Function.

Please don't use passwords like this example above
Now you can click save, and we will be able to login with our new password!
Thank you for reading my blog. Feel free to subscribe to my email newsletter and connect on Facebook or Twitter