amazon ec2 - MySQL error :ERROR 1045 (28000): Access denied for user 'guest'@'localhost' (using password: YES) -
i have linux ec2 instance has mysql server installed on it. i can login mysql root command: mysql -u root -p for reasons created user guest using following commands: create user 'guest'@'%' identified 'passpass'; grant privileges on * . * 'guest'@'%'; flush privileges; then exit root user , try login guest user: mysql -u guest -p entered correct password , got error: error 1045 (28000): access denied user 'guest'@'localhost' (using password: yes) i checked out anonymous user . mysql> select user, host, password mysql.user user=''; empty set (0.00 sec) kindly help. not able connect mysql using guest user credentials try run command grant on . 'guest'@'%' identified 'passpass'; flush privileges; thanks