101 Tips to MySQL Tuning and Optimization

MySQL is a powerful open-source database.  With more and more database driven applications, people have been pushing MySQL to its limits.  Here are 101 tips for tuning and optimizing your MySQL install.  Some tips are specific to the environment they are installed on, but the concepts are universal.   I have …

ERROR: Too many failed login attempts. Please try again” in wordpress admin login page

This error comes from a wordpress limit_login plugin. Due to load balancing and DDoS protection the majority of our IPs are behind loadbalancers, as a result limit login plugin always sees the IP of the load balancer as the IP of requester. To fix this problem follow this steps: Login …

How to Reset Root Password MySQL

Shutdown MySQL service # service mysqld stop Start MySQL Service in safe mode # mysqld_safe –skip-grant-tables Login as root #mysql -u root update root password mysql> use mysql; mysql> UPDATE user SET Password = PASSWORD (‘New Password’) WHERE User=’root’; mysql> FLUSH PRIVILEGES; mysql> quit; Restart service MYSQL as normally # …