ERROR 1045 (28000): Access denied for user in AWS.

0 votes

Hi Guys,

In AWS, when connecting to the database server using MySQL, I am getting the below error. 

“ERROR 1045 (28000): Access denied for user….”

How can I resolve this?

Apr 2 in AWS by akhtar
• 34,150 points
1,911 views

1 answer to this question.

0 votes

Hi@akhtar,

You need to reset the password for this. First start the mysql server instance or daemon with the --skip-grant-tables option. (security setting)

Then Execute these statements.
$ mysql -u root mysql
mysql> UPDATE user SET Password=PASSWORD('your_new_password') where USER='root';
mysql> FLUSH PRIVILEGES;

Finally, restart the instance/daemon without the --skip-grant-tables option.

You should be able to connect with your new password.

$ mysql -u root -p
Enter password: your_new_password

Hope this will help.

Thank You

answered Apr 2 by MD
• 81,590 points

Related Questions In AWS

0 votes
1 answer

"access denied" error when trying to move a file into the AWS server.

Hi@akhtar, I think you are trying to transfer file to ...READ MORE

answered Apr 2 in AWS by MD
• 81,590 points
255 views
0 votes
3 answers
+1 vote
3 answers

Log in to AWS using Access Key ID and Secret Access Key ID

Access keys consist of an access key ...READ MORE

answered Aug 17, 2018 in AWS by Priyaj
• 57,700 points
11,185 views
0 votes
1 answer

Want to use an AWS Cognito User Pool without putting a password(for an easier approach)

Currently, AWS Cognito is not supporting passwordless ...READ MORE

answered May 4, 2018 in AWS by Cloud gunner
• 4,650 points
3,146 views
0 votes
1 answer
0 votes
1 answer

IOPS or Throughput?

Configure your database driver to print statistics ...READ MORE

answered Nov 14, 2018 in AWS by Theodor
• 740 points
90 views
0 votes
1 answer

How to create an access key for an IAM user in AWS?

Hi@akhtar, You can create a new AWS secret ...READ MORE

answered Nov 3 in AWS by MD
• 81,590 points
36 views