// free-tools

WordPress Admin Account Generator

Generate SQL queries or WP CLI commands to create WordPress admin accounts. Useful when you're locked out or need quick database-level access.

Database Prefix

Admin Name

Username

Password

SQL Query

INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`,`user_registered`)
VALUES ('admin', MD5('changeme'), 'Mr Admin', 'admin@example.com', '0','2026-5-5');

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
VALUES (NULL, (Select max(id) FROM wp_users), 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');

INSERT INTO `wp_usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`)
VALUES (NULL, (Select max(id) FROM wp_users), 'wp_user_level', '10');

WP CLI

wp user create admin admin@example.com --role=administrator --porcelain

Related Tools

WP Search & Replace

Generate SQL queries for safe search-replace operations. Perfect for WordPress domain migrations.

wordpressmysqlmigration

WP Permissions Fixer

Generate correct chmod and chown commands to fix WordPress file and folder permissions.

wordpresslinuxsecurity

htpasswd Generator

Generate Apache .htpasswd entries for basic authentication with MD5, SHA-1, or plain text hashing.

apachesecurityauth