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:

mysql> DELETE FROM wp_comments WHERE comment_approved = '0';

Note: I have not installed a plugin for spam protection like Akismet.

How to reset MySQL root password?

It is easy to forget the root password as it is advised to use the user account for security reason. Today, I needed to access my MySQL database as root, but I could not remember the password. After searching for a solution, I found this method to be awesome:

1. Run the server with –skip-grant-tables option so that you can log in without a password.

# /etc/init.d/mysqld stop
# mysqld_safe --skip-grant-tables &
$ mysql -u root

2. Reset the root password.

mysql> use mysql;
mysql> update user set password=PASSWORD("YOUR-NEW-ROOT-PASSWORD") where user='root';
mysql> flush privileges;
mysql> quit

3. Restart MySQL and log in using your new root password.

# /etc/init.d/mysqld stop
# /etc/init.d/mysqld start
# mysql -u root -p