LMSouq
database Open

MySQL ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)

AL
Ali
1 month ago
3 views
Problem Description
I'm connected to my Amazon EC2 instance. I can login with MySQL root with this command: mysql -u root -p Then I created a new user bill with host % CREATE USER 'bill'@'%' IDENTIFIED BY 'passpass'; Granted all the privileges to user bill: grant all privileges on *.* to 'bill'@'%' with grant option; Then I exit from root user and try to login with bill: mysql -u bill -p entered the correct password and got this error: > ERROR 1045 (28000): Access denied for user 'bill'@'localhost' (using password: YES)

AI-Generated Solution

Powered by LMSouq AI · GPT-4.1-mini

✓ Solution Ready
Analyzing problem and generating solution…
Was this solution helpful?
Back to Knowledge Base