In the last several days I have been receiving spam in the comments section. I have 100 pages of over 1000 "comments" and it is ALL spam. :( Is there a way to delete all of the comments?

The only way I have found is to mark each one individually. This will take too long. Also, how can I prevent ...

We run our MySQL 5 server on a non standard port due to a parallel install of MySQL 4 (migration in process). Thus, the database server I want is not on port 3306. But when I specify db.host.com:3307, I get this message back:

Unknown MySQL server host 'db.host.com:3307'

I'm doing expert install ...