WP
SQL
Links
SQL command generator:
table-prefix:
sql-database:
sql-user:
sql-pass:
user-email:
neo_zacasni
f24f0765
Check wp-config.php values:
egrep '(\$table_prefix|DB_NAME|DB_USER)' wp-config.php
WP CLI add (delete) user to DB (only from WP homedir):
wp user create neo_zacasni email@example.com --role=administrator
wp user delete neo_zacasni --yes
WP SQL add (delete) user to DB:
INSERT INTO `users` (`user_login`, `user_pass`, `user_nicename`, `user_email`, `user_status`) VALUES ('neo_zacasni', MD5('f24f0765'), 'NEO Zacasni', 'email@example.com', '0'); INSERT INTO `usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select `id` FROM users WHERE `user_login` = 'neo_zacasni'), 'capabilities', 'a:1:{s:13:"administrator";s:1:"1";}'); INSERT INTO `usermeta` (`umeta_id`, `user_id`, `meta_key`, `meta_value`) VALUES (NULL, (Select `id` FROM users WHERE `user_login` = 'neo_zacasni'), 'user_level', '10');
DELETE FROM `usermeta` WHERE `user_id` = (SELECT `id` FROM `users` WHERE `user_login` = 'neo_zacasni'); DELETE FROM `users` WHERE `user_login` = 'neo_zacasni';