• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 799
  • Last Modified:

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?
0
R7AF
Asked:
R7AF
  • 2
2 Solutions
 
chatarosCommented:
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
 
chatarosCommented:
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

Featured Post

Free Tool: Site Down Detector

Helpful to verify reports of your own downtime, or to double check a downed website you are trying to access.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now