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,260 points
7,637 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. You can get a better understanding from the AWS Training in Bangalore.

Thank You

answered Apr 2, 2020 by MD
• 95,460 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,460 points
1,673 views
0 votes
3 answers

What is CPU Credit Balance in EC2 for AWS?

When you use fewer CPU resources then ...READ MORE

answered Nov 30, 2018 in AWS by Aniket
2,464 views
+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,670 points
5,505 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
706 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,460 points
653 views
webinar REGISTER FOR FREE WEBINAR X
REGISTER NOW
webinar_success Thank you for registering Join Edureka Meetup community for 100+ Free Webinars each month JOIN MEETUP GROUP