Create WordPress admin user with sql only

If you don’t have access to you WordPress website anymore, but still can update the MySQL database. You can easily add a new admin user with this sql script:

USE <database>;
SET @username = '<username>';
SET @password = MD5('<password>');
SET @fullname = '<Firstname Lastname>';
SET @email = '<>';
SET @url = '<>';
INSERT INTO `wp_users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_url`, `user_registered`, `user_status`, `display_name`) VALUES (@username, @password, @fullname, @email, @url, NOW(), '0', @fullname);
SET @userid = LAST_INSERT_ID();
INSERT INTO `wp_usermeta` (`user_id`, `meta_key`, `meta_value`) VALUES (@userid, 'wp_capabilities', 'a:1:{s:13:"administrator";s:1:"1";}');
INSERT INTO `wp_usermeta` (`user_id`, `meta_key`, `meta_value`) VALUES (@userid, 'wp_user_level', '10');

Get the latest version of this snippet here:

Manage multiple WordPress sites with Jetpack

Hurray, WordPress 4.1 and the Jetpack Plugin 3.3 has been released.
Jetpack is a must have plugin for your WordPress site, it offers tons of new functions and integrates your blog neatly with your account. If you haven’t already installed it, head right now to your plugin manager!
With the last Update the developer have added a great feature. It’s now possible to manage the plugins for multiple WordPress sites at one location.
Here’s a screenshot, which shows the plugins admin panel of
Continue reading “Manage multiple WordPress sites with Jetpack”