w3hello.com logo
Home PHP C# C++ Android Java Javascript Python IOS SQL HTML videos Categories
#1130 - Host 'localhost' is not allowed to connect to this MySQL server weird message?

Does other connections to the MySQL server work?

I've seen in past this error in two occasions:

  • The mysql.user table was completely empty providing no privileges at all. For example SUSE Studio produced such virtual machines at some point (maybe it's still the case, I did not check).
  • You're missing localhost host in mysql.user. For MySQL localhost and 127.0.0.1 are different - first one is for socket based connections, while the latter for TCP based ones.




© Copyright 2018 w3hello.com Publishing Limited. All rights reserved.