Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > Server Operation

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 28th October 2012, 23: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
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems with Virtual Hosting With PureFTPd And MySQL (Incl. Quota And Bandwidth Mana ikkem HOWTO-Related Questions 33 8th June 2012 19:27
apache log issues abubin General 13 1st August 2010 18:47
/boot is 100% full Sohail Khawaja HOWTO-Related Questions 6 6th January 2010 21:32
Management/system config/settings & /server/settings not working!! dactor Installation/Configuration 9 6th February 2008 10:11
Add Webmin to the system sushestvo Installation/Configuration 44 21st August 2007 17:52


All times are GMT +2. The time now is 05:50.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.