How to fix: “Another MySQL daemon already running with the same unix socket.”
You can see this error when restarting MySQL. The system has detected that MySQL is running when it is not. This is probably due to and hard reboot of the system.
To fix this problem, remove the file /var/lib/mysql/mysql.sock
as root user:
# rm /var/lib/mysql/mysql.sock
Then start the MySQL daemon:
# service mysqld start
or
# /etc/init.d/mysqld start
How to delete spam comments on WordPress?
I am self-hosting a WordPress blog site (not this one). And though I did not allow “Comments”, my site received hundred and thousands of spam comments. To delete these unapproved comments all at once, I directly access my database and issue the command:
Note: I have not installed a plugin for spam protection like Akismet.
Category:
Database, How To's, Linux, System Administration
Tagged with: