<div>
Adding to Dave's point, you can create other users who can be accessing from any (%) source while restricting what they can do on the system.
</div>


<div>
I tried to do the following as per your comments but ended with an error, could you please let me know if i'm missing something here ...<br />
<br />

<pre><code class="code-10 nolinks" id="code-20-41785322-1"><span>mysql&gt; UPDATE mysql.user SET HOST=&quot;127.0.0.1&quot; WHERE user=&quot;root&quot;;</span>
<span>Query OK, 1 row affected (0.00 sec)</span>
<span>Rows matched: 1  Changed: 1  Warnings: 0</span>
<span>mysql&gt; FLUSH PRIVILEGES;</span>
<span>Query OK, 0 rows affected (0.02 sec)</span>
<span>mysql&gt; exit</span>
<span>Bye</span>
<span></span>
<span>[siva@mysql ~]$ mysql -u root -p</span>
<span>Enter password:</span>
<span>ERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: YES)</span>
<span>[siva@mysql ~]$</span>
</code></pre>
</div>


<div>
Please read the &nbsp;--bind-address section on this page: <a href="http://dev.mysql.com/doc/refman/5.7/en/server-options.html" rel="ugc">http://dev.mysql.com/doc/refman/5.7/en/server-options.html</a>&nbsp; &nbsp;The default value is '*' which allows the server to connect on any IP address or hostname. &nbsp;It is probably better to use '*' and restrict access in the 'privileges' where you can limit users to specific IP addresses without blocking the entire server.
</div>


<div>
Changing the host, does not set a password, which seems that root might not have a password<br />
mysql -u root<br />
See if it loggs you in.<br />
select * from mysql.user where User='root';<br />
<br />
Also, usually the host us localhost, versus the equivalent 127.0.0.1.
</div>


<div>
<div class="content wysiwyg-content">
Hello, <br />
<br />
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 &quot;localhost&quot;. I'm able to fix this issue by updating the user Host field with binded ip or using wildcard '%' (any ip). <br />
<br />
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? <br />
<br />
Also, what is recommended approach for high privileged user accounts like root &amp;&nbsp;mysql.sys?<br />
<br />
Thank you
</div>
</div>


Hello, 

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

Lost user connectivity when MySQL is binded with IP address.

MySQL is an open source, relational database management system that runs as a server providing multi-user access to a number of databases. Acquired by Oracle in 2009, it is frequently used in combination with PHP installations, powering most of the WordPress installations.