Free tool
Generate SQL to create a WordPress user via phpMyAdmin
Locked out of wp-admin? Build the exact SQL to insert a new WordPress user and role, then paste it into phpMyAdmin. Your password never leaves the browser.
create-user.sql
Runs fully in your browser. Nothing you type is sent to a server.
How it works
Create a WordPress admin in three steps
01
Fill the fields
Enter username, email, password, role and your table prefix.
02
Copy the SQL
Hit copy to grab the generated INSERT statements.
03
Run in phpMyAdmin
Open the SQL tab on your WordPress database and run it.
FAQ
Quick answers
The SQL uses MySQL MD5() so the database hashes it. WordPress accepts the MD5 hash on first login and upgrades it to its secure format automatically. Change the password after you log in.
Check wp-config.php for the table_prefix value. The default is wp_, but many installs use a custom one for security.
No. Everything runs in your browser. Nothing you type is sent to a server.
Administrator gives full control. Use Editor, Author, Contributor or Subscriber for limited access.
Need the real thing?
Locked out for good reasons?
We fix, secure and maintain WordPress sites so this never happens again.