The MySQL root password allows full access to the MySQL database and allows for all actions to be undertaken including creating new users, new databases, setting access rules and so on.
Losing one can be a difficult issue to encounter. Luckily, resetting the root password is easy as long as you have sudo access to the Server.
Not the Server root user
A common issue is confusing the Server root user with the MySQL root user. Continue reading “Reset a lost MySQL root password”
The can use phpMyAdmin to execute this SQL
DELETE FROM wp_comments WHERE comment_approved = 0
Once you have wp-config open, add this line of code to the bottom:
define( ‘WP_ALLOW_REPAIR’, true );
This line will enable you to optimize and repair your database by navigating to www.yourwebsite.com/wp-admin/maint/repair.php (just replace “yourwebsite.com” with your actual URL).
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)”
service mysqld stop
rm -rf /var/lib/mysql/XXXXX
service mysqld start
Where XXXXX is the offending database name.