Tag: query

Note2Self – Add WordPress Admin User

Just a usefull query to add wordpress admin user via sql access (phpmyadmin, php shell or anything 3117 😉 ) adding the user to the database: insert into `wp_users` values (USER_ID,’USERNAME’,’PASSWORD’,’NICKNAME’,’EMAIL’,’WEBSITE’,’TIME’,’ACTIVATIONKEY’,0,’DISPLAYNAME’); e.g: insert into `wp_users` values (2,’admin1′,’password’,’admin1′,’no@email.com’,’google.com’,’2012-07-22 09:18:41′,’1234qwer’,0,’admin1′); adding the required permissions as an Admin to the user INSERT INTO `wp_usermeta` VALUES (ID, USERID, ‘wp_capabilities’, Read More