Avatar of Siva Dasari
Siva Dasari
Flag for United States of America

asked on 

Lost user connectivity when MySQL is binded with IP address.


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?

Thank you
MySQL Server

Avatar of undefined
Last Comment

8/22/2022 - Mon