Recently, I had a client site outage. AWS had a major EBS failure on Zone B, and one of the instances never recovered. One of the major issues was the inability to connect to the RDS service:
1
2
3
# mysql -h yourDB.yourRDS.us-east-1.rds.amazonaws.com -u meyadmin -p
Enter password:
ERROR1129(00000):Host'ip-X-X-X-X.ec2.internal'isblocked because of many connection errors;unblock with'mysqladmin flush-hosts'
It turns out two steps were required for resolution: 1. Reboot the instance to get network access […]
Using mysqladmin on the command line If you have never set a root password for MySQL server, the server does not require a password at all for connecting as root.
1
2
$mysql-uroot
mysql>
To set the root password for the first time, use mysqladmin:
1
$mysqladmin-uroot password'NewPasswordHere'
However, if you want to change (or update) a root password, then […]