Created new user like below mention snap
MySQL>grant select on migrate.active_table on 'qvviznte'@'184.108.40.206'
>identified by 'password';
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';
Then try to re-create the same user
grant select on migrate.active_table on 'qvviznte'@'220.127.116.11' identified by 'password';
then its working fine from application end....
Post a Comment