amazon ec2 - Could not log in to mysql server with correct password -
i not able access mysql on amazon aws ec2
instance. able access same password yesterday night when today morning opened mysqlworkbench
not connect mysql server on ec2
instance, logged in ec2
server , there not connect
$ mysql -u root -p <gave password>
and got error
error 1045 (28000): access denied user 'root'@'localhost' (using password: yes)
i giving correct password
its production server worried :(
i think problem related forget permission giving access. please try grant privileges using below mysql code:
//login shell mysql> $ mysql -u root -p <give password> //grant full permissions. mysql> grant privileges on * . * 'root'@'localhost' identified 'give password'; //to tell server reload grant tables, perform flush-privileges operation. can done issuing flush privileges statement call it. mysql> flush privileges
this resolve issue.
Comments
Post a Comment