Amazon EC2: Access denied for user abc / while other users can connect
Posted on 2010-08-31
I've installed a php application on our server. I have created the user "abc", with a password, and I can login via commandline to mysql as this user. So the user seems to work correctly. We use Amazon EC2, and have a separate database server. When I run the installation wizard, I get the following error:
Access denied for user 'abc'@'ip-xxx.xxx.xxx.xxx.compute.internal' (using password: YES)
In the wizard, I can change the user to 'root', and then the connection works. I don't know what I'm doing wrong here. How can I get this working for this user?