DELETE FROM users WHERE `status` = 0 AND `uid` != 0;
Also had 49,000+ failed admin login attempts on my site - had caused a lockout of my admin user.Did this in phpmyadmin
DELETE FROM flood;
Also these bash script commands to set the permissions for a standard Drupal site:
cd /path_to_drupal_installation
sudo chown -R greg:www-data .
find . -type d -exec chmod u=rwx,g=rx,o= '{}' \;
find . -type f -exec chmod u=rw,g=r,o= '{}' \;
and...
cd /path_to_drupal_installation/sites
find . -type d -name files -exec chmod ug=rwx,o= '{}' \;
for d in ./*/files
do
find $d -type d -exec chmod ug=rwx,o= '{}' \;
find $d -type f -exec chmod ug=rw,o= '{}' \;
done