wp woocommerce后台好久没去打开,今日打开突然发现快一万个用户了
一页一页删除,手都要废掉了,赶紧数据库删除
切记做下数据库备份先
上才艺!
-- 首先,删除除管理员外的所有用户
DELETE FROM wp_users WHERE ID NOT IN (SELECT ID FROM (SELECT ID FROM wp_users WHERE user_login = 'admin') AS admins);
-- 接下来,删除不再存在于 wp_users 表中的用户的元数据
DELETE FROM wp_usermeta WHERE user_id NOT IN (SELECT ID FROM wp_users);
第一行命令的admin切记要改成你自己的名字,比如你是adminabc要改成对应的哦
for example: DELETE FROM wp_users WHERE ID NOT IN (SELECT ID FROM (SELECT ID FROM wp_users WHERE user_login = 'adminabc') AS admins);
完事!美好的一天又开启了