Lost user connectivity when MySQL is binded with IP address.
Posted on 2016-09-05
I have used bind-address option in MySQL config file which stopped my connectivity to mysql instance on specific user. I have figured it out that the user is created with host as "localhost". I'm able to fix this issue by updating the user Host field with binded ip or using wildcard '%' (any ip).
I'm trying to understand is there is any possible security issue using wild card '%' to allow on any IP or it is recommended to bind with specific IP?
Also, what is recommended approach for high privileged user accounts like root & mysql.sys?