The can use phpMyAdmin to execute this SQL
DELETE FROM wp_comments WHERE comment_approved = 0
Tag: mysql
[SOLVED] mysqld: Can’t find file: ‘./mysql/plugin.frm’ (errno: 13)
I resolved this problem from these steps:
1) restarting your EC2 instance.
2) sudo service httpd restart
3) sudo chown -R mysql:mysql /var/lib/mysql Continue reading “[SOLVED] mysqld: Can’t find file: ‘./mysql/plugin.frm’ (errno: 13)”
Fixed, Mysql drop database Errno:39
service mysqld stop
rm -rf /var/lib/mysql/XXXXX
service mysqld start
Where XXXXX is the offending database name.
View All MySQL Databases on Linux
To view a list of databases simply issue the following command:
SHOW DATABASES;
Delete a MySQL Database on Linux
Pre-Flight Check
These instructions are intended for deleting a MySQL database on Linux via the command line.
I’ll be working from a Liquid Web Core Managed CentOS 7 server, and I’ll be logged in as root.
First we’ll login to the MySQL server from the command line with the following command:
mysql -u root -p
Continue reading “Delete a MySQL Database on Linux”