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