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, 2020 in AWS by akhtar
• 38,180 points
3,690 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, 2020 by MD
• 95,240 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, 2020 in AWS by MD
• 95,240 points
414 views
0 votes
3 answers
+1 vote
3 answers
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,740 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
131 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, 2020 in AWS by MD
• 95,240 points
99 views