Tuesday 19 March 2013

ERROR 1396 (HY000): Operation DROP USER

Created new user like below mention snap

MySQL>grant select on migrate.active_table on 'qvviznte'@''
>identified by 'password';

MySQL>flush privileges;

but after trying to access user from application end its given some error.
so I decide drop and re-create the new user but I'm getting ERROR-1396(HY000)



delete from mysql.user where User = 'qvviznet';
flush privileges;
Then try to re-create the same user

grant select on migrate.active_table on 'qvviznte'@'' identified by 'password';

flush privileges;

then its working fine from application end....


No comments:

Post a Comment