Amazon EC2: Access denied for user abc / while other users can connect

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?
LVL 13
R7AFAsked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
chatarosConnect With a Mentor Commented:
I think you may need to change the pass and try again with the new password:
MySQL Change User Password                               

 to change a password for user called tom using command line option.
   
First,  login to MySQL server, type following command at prompt to login as root
 1) mysql -u root -p
2) Use mysql database (type command at mysql> prompt, do not include string "mysql>"):
 mysql> use mysql;
3) Change password for user tom:
 mysql> update user set password=PASSWORD("NEW-PASSWORD-HERE") where User='tom';

then try again  to login
0
 
chatarosConnect With a Mentor Commented:
Or if this still doesn't work, you may need to grant permissions to the tables:

GRANT SELECT,INSERT,UPDATE,DELETE,CREATE,DROP
    ->     ON Database.Table
    ->     TO 'user'@'localhost'
    ->     IDENTIFIED BY 'pass';


0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.