Learn how to edit WordPress user accounts directly in the database with phpMyAdmin—bypassing WordPress entirely.
- [Voiceover] Hi, I'm Morten Rand-Hendriksen, staff author at Lynda.com and I'm delighted to welcome you to WordPress Developer Tips: Managing Users in the Database. In this short developer tip, I'll show you how to edit WordPress user accounts directly in the database using PHP my admit. This is an advanced developer technique that bypasses WordPress entirely to perform common tasks on the database and it's only recommended if you know how to make backups and also restore your database in case something goes wrong.
In the first section of the course, I'll show you how to access, manage, and edit existing user accounts and perform common tasks like resetting passwords and editing roles and capabilities. And in the second section, I'll show you how you add and remove users directly from the database itself. Understanding how you can edit user accounts in the database can be useful when managing large WordPress sites or when getting out of a pinch when a password won't reset, and I'm here to show you how to do it right.
So let's get cracking with WordPress Developer Tips: Managing Users in the Database.