MySQL - Unable to login with password, but without password its working
network mask - is part of user name in MySQL 


create user 'bhuvi'@'%' identified by 'bhuvi'; - You are create user with password
grant all privileges on . to 'bhuvi'@'localhost'; - You create 2nd user without password




1st have password, but not privileges

2nd have all privileges, but not password