11 tra.

Kreiranje WP Admin korisnika kroz MySQL

Create a WordPress admin user with MySQL

If you’ve ever been locked out of a WordPress installation, but have access to the database, here’s a nifty snippet to grant you administrator-level access. There are a couple of things you need to do before using this MySQL code. First, set the variables to your own information. Next, if your WordPress installation is based on a non-standard wp_ table prefix, you must find/replace ‘wp_’ with your current table prefix.
http://coderrr.com/create-a-wordpress-admin-user-with-mysql/

SET @id = 99;
SET @user = ‘username’;
SET @pass = ‘password’;
SET @email = ’email@ddress’;
SET @name = ‘Your Name’;

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) VA

Moj primjer
________________

SET @id = 99;
SET @user = ‘adminko’;
SET @pass = ‘Ajm00!!.Asad.’;
SET @email = ‘webmaster@ideja.in’;
SET @name = ‘Administrator’;

INSERT INTO  good_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  good_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, @id, ‘wp_capabilities’, ‘a:1:{s:13:”administrator”;s:1:”1″;}’);
INSERT INTO  good_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, @id, ‘wp_user_level’, ’10’);
INSERT INTO  good_usermeta (umeta_id, user_id, meta_key, meta_value) VALUES (NULL, @id, ‘active’, ‘1’);

—-
a:1:{s:13:”administrator”;b:1;}
a:1:{s:13:”administrator”;s:1:”1″;}

Odgovori

Vaša adresa e-pošte neće biti objavljena. Nužna polja su označena s *