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'@'121.244.254.30'
>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)

 














Solution:-

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'@'121.244.254.30' identified by 'password';

flush privileges;

then its working fine from application end....




 

No comments:

Post a comment