- ER_ACCESS_DENIED_ERROR: Access denied for user 'someuser'@'ec2-52-34-31-72.us-west-2.compute.amazonaws.com' (using password: YES) or ER_HOST_NOT_PRIVILEGED: Host 'ec2-52-34-31-72.us-west-2.compute.amazonaws.com' is not allowed to connect to this MySQL server
If you are getting one of the above 2 errors, this means that your user account does not have enough privileges in order to connect to the server.
After MySQL database was installed, it would only allow "localhost" connection by default. Therefore, most server-side scripts program can easily connect with the local database in the same server. Any client computers will be blocked by the remote MySQL server until the user privileges has been configured.
Steps to fix:
You can run the following command in your MySQL server command prompt. Please consult with your database administrator as they usually will have administration right to set the privilege.
GRANT ALL PRIVILEGES ON *.* TO 'YourUserName'@'ec2-52-34-31-72.us-west-2.compute.amazonaws.com' IDENTIFIED BY "YourPassword";
Replace "YourUserName" and "YourPassword" with actual username/password for the mysql user.
2) Cannot connect to the database. Please make sure you have whitelisted the Kloudio IP addresses.
This issue occurs if Kloudio cannot connect to your DB because of firewall.
Steps to fix:
Your IT admin has to make some changes to firewall.
- Open database port in the firewall for connecting from remote server.
- Whitelist Kloudio IP Addresses (220.127.116.11 and 18.104.22.168) in your database firewall so that Kloudio can connect to your database.