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,076 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,140 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,140 points
361 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
• 58,100 points
13,842 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,544 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
111 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,140 points
70 views