How to delete spam users from your Joomla! site's database

spam

If your Joomla site has spam users then you can use one of the following ways to delete them all at once directly from your database

 

Step 1:

Login to your Joomla! site

Go to "Users"

Go to "User Manager"

Click "Options" (top right)

Choose: Allow User Registration: No

Choose: New User Registration Group: Public

 

Step 2 - Method 1:

Open the PhpMyadmin through your cpanel

Click on your database name

Click on "SQL"

Copy and paste this: DELETE FROM `jos_users` WHERE `usertype`=''

(modify the yellow above to your database users table name)

This will delete all users that do not have a user type specified

 

Step 2 - Method 2:

Open the PhpMyadmin through your cpanel

Click on your database name

Click on "SQL"

Copy and paste this:  DELETE from jos_users where lastvisitDate=’0000-00-00 00:00:00′ '