I am getting a too many connections error with my web app: http://dev.mysql.com/doc/refman/5.5/en/too-many-connections.html
I therefore want to connect into the database to
show full processes/g so I can debug the code. I am using the following CLI command:
mysql -h domain.eu-west-1.rds.amazonaws.com -P 3306 -u username -p
The username I am using is the master username created when I launched the instance. It's my understanding that mysql always keeps one connection free to allow accounts with SUPER priveledges to connect, however when I do, I get the too many errors response.
Looking at the config, the master username appears to only have super priveledges on the database and not domain, is this correct? How else can I log into mysql to debug the server?