info@anzum.com

Are you looking to create a WordPress user using an SQL query from the PhpMyAdmin area? Here is the query that you need to execute with proper parameters.

You need to update a few things like ID (Don’t use an existing id), Username, password in raw text, email and user name as profile info. You also need to check for a few thing while creating a WordPress user from database (The table prefix). Once you have


SET @id = 99;
SET @user = 'username';
SET @pass = 'password';
SET @email = 'info@example.coom';
SET @name = 'marshall';

INSERT INTO wp_users (ID, user_login, user_pass, user_nicename, user_email, user_url, user_registered, user_activation_key, user_status, display_name) VALUES (@id, @user, MD5(@pass), @name, @email, '', '2013-06-20 00:00:00', '', '0', @name);
INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, @id, 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, @id, 'wp_user_level', '10');
INSERT INTO wp_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, @id, 'active', '1');

Subscribe To Our Newsletter

Subscribe To Our Newsletter

Join our mailing list to receive the latest news and updates from our team.

You have Successfully Subscribed!

Discover what's new at Divi Extended

Discover what's new at Divi Extended

Connect with Divi Extended for info on our new products and updates.

Welcome on Board

%d bloggers like this: