Wait, what about the server real/public IP address? Have you specified in the hosts file if its also similar to localhost?<br><br>I am not sure if MySQL error logs record failed log ins, but if it does, maybe the error message can give you a clue as to which host is actually being sent...<br>
<br>And to prevent you from being fired immediately, you can set the host column in mysql.user table to %, as a very temporary measure.<br><br>I am not sure if the network service needs a restart after making changes to the hosts file.<br>
<br><br><div class="gmail_quote">On Wed, Jul 4, 2012 at 10:55 AM, gisho <span dir="ltr">&lt;<a href="mailto:gichuhie@gmail.com" target="_blank">gichuhie@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
i can&#39;t help but i checked my my.cnf and there&#39;s nothing close to your problem. this is my unmodified .cnf <br><br clear="all"><span style="font-size:12px"><div><font face="&#39;courier new&#39;, monospace">[root@lenana]# cat /etc/my.cnf<br>


[mysqld]<br>datadir=/var/lib/mysql<br>socket=/var/lib/mysql/mysql.sock<br>user=mysql<br># Disabling symbolic-links is recommended to prevent assorted security risks<br>symbolic-links=0<br><br>[mysqld_safe]<br>log-error=/var/log/mysqld.log<br>


pid-file=/var/run/mysqld/mysqld.pid<br>[root@lenana]#<br><br></font></div><div><font face="&#39;courier new&#39;, monospace">-erastus</font></div><div style="font-family:verdana"><br></div></span><div class="HOEnZb"><div class="h5">
<br>
<br><br><div class="gmail_quote">On Wed, Jul 4, 2012 at 10:39 AM, joe mwirigi <span dir="ltr">&lt;<a href="mailto:joemwirigi@gmail.com" target="_blank">joemwirigi@gmail.com</a>&gt;</span> wrote:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">


@kip,<div><br></div><div>The pings both return normal, my problem is getting mysql to re-learn that localhost== 127.0.0.1. and actually allow connections from localhost as would from the ip. This affects all apps that have localhost as the &#39;host&#39;</div>



<div><br></div><div>I also have the paths to mysqld.sock well defined</div><div><br></div><div>rgds<div><br clear="all"><i><font color="#666666">_______________________________________________________________<br>

We must Keep on, <br>
   </font></i><br>  <br>
<br><br></div><div><div><div class="gmail_quote">On Wed, Jul 4, 2012 at 10:29 AM, kipropest <span dir="ltr">&lt;<a href="mailto:kipropbrian@gmail.com" target="_blank">kipropbrian@gmail.com</a>&gt;</span> wrote:<br>

<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
What does ping localhost say.<div><br></div><div>Also try coffee. <br><br><div class="gmail_quote"><div><div>On Wed, Jul 4, 2012 at 8:25 AM, joe mwirigi <span dir="ltr">&lt;<a href="mailto:joemwirigi@gmail.com" target="_blank">joemwirigi@gmail.com</a>&gt;</span> wrote:<br>




</div></div><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>Hi All,<div>I encountered a unique problem(to me) While i was setting up remote Mysql Access to a server.</div>



<div><br>
</div><div>(1). Edited my.cnf to bind at the server address instead of 127.0.0.1</div><div>(2). Allowed access from my remote ip on the iptables</div>
<div>(3) Added host to mysql and granted access to the database</div><div>(4) Realized something was wrong all &#39;localhost&#39; configs could no longer access db -shoot! I reverted to the old my.cnf</div><div>(5)Hell broke and could no longer access server via localhost as host but can access only though 127.0.0.1 as host.</div>





<div><br></div><div>Stuff I have checked and done</div><div>(1) /etc/hosts had the directive that localhost is 127.0.0.1</div><div>(2) Passwords on mysql user are Ok</div><div>(3) Reset users,host and passwords but still access denied for user@localhost </div>





<div>(4) Restarted mysql n times</div><div>(5) Drunk lots of tea</div><div><br></div><div>My question:</div><div> How do I make it revert to the Old access where localhost meant 127.0.0.1</div><div><br></div><div>Could this be the sockets and TCPIP issue is there hope for getting back?</div>





<div><br></div><div>even a google pointer here is welcome since my eyes are now red (cant tell whether its sleep || &#39;am so screwed color&#39; || part of the bug</div><div><br></div><div>help!</div><div><br></div><div>





Regards again!</div><div><br></div><div><br></div><div><br></div><div><br></div><div><br clear="all"><i><font color="#666666">_______________________________________________________________<br>We must Keep on, <br>   </font></i><br>





  <br>
</div>
<br></div></div>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br></div></div></div>
<br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke" target="_blank">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br>
</div></div><br>_______________________________________________<br>
Skunkworks mailing list<br>
<a href="mailto:Skunkworks@lists.my.co.ke">Skunkworks@lists.my.co.ke</a><br>
------------<br>
List info, subscribe/unsubscribe<br>
<a href="http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks" target="_blank">http://lists.my.co.ke/cgi-bin/mailman/listinfo/skunkworks</a><br>
------------<br>
<br>
Skunkworks Rules<br>
<a href="http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94" target="_blank">http://my.co.ke/phpbb/viewtopic.php?f=24&amp;t=94</a><br>
------------<br>
Other services @ <a href="http://my.co.ke" target="_blank">http://my.co.ke</a><br></blockquote></div><br><br clear="all"><br>-- <br>Regards,<br>Peter Karunyu<br>-------------------<br><br>