Fixing MySQL Error Code 1419 on AWS RDS: Missing SUPER Privilege with Binary Logging Enabled If you’ve ever tried to create a stored function or trigger in MySQL on Amazon RDS and encountered the error below, you’re not alone: Error Code: 1419. You do not have the SUPER privilege and binary logging is enabled (you …

Today, we faced a problem where our client application was not working because of the database connection issue. I have checked and found that their credentials were incorrect. As per the client, this was that same credentials which their application was using. So, To resolve the problem, we decided to reset the root …

Today we will learn, How to change/reset/update MySQL root password. First, the most important thing is "Are you able to access the data using root credentials." If No, Please follow the below steps: Log-in to your server using SSH. Stop Mysql Service: For CentOS and Fedora, Run below command: 1service mysqld stop For …