View Single Post
  #1  
Old 28th October 2012, 22:31
SwOsHiE SwOsHiE is offline
HowtoForge Supporter
 
Join Date: Jun 2011
Location: Stockholm, Sweden
Posts: 82
Thanks: 8
Thanked 8 Times in 7 Posts
Send a message via Skype™ to SwOsHiE
Exclamation MySQL - root access denied if not 127.0.0.1

Hello,

Got a serious problem with our MySQL service a couple of days ago. You cannot login as root unless you type in "-h 127.0.0.1". I've searched and searched on the web and looked up so many things but still not getting it to work.

The things I've tried:
  • Checked that /etc/hosts points localhost to 127.0.0.1
  • Mysqld is running on port 3306 and with IPv4
  • The path to the mysql socket is correct both in my.cnf and debian.cnf
  • Checked that "bind adress" is uncommented

Getting really frustrated as ISPConfig is not able to make database changes!

I appreciate all the help I can get!!

Best regards,
Mattias
Reply With Quote
Sponsored Links