{"id":653,"date":"2011-09-18T18:32:03","date_gmt":"2011-09-18T23:32:03","guid":{"rendered":"http:\/\/bucktownbell.com\/?p=653"},"modified":"2012-03-20T23:40:23","modified_gmt":"2012-03-21T04:40:23","slug":"error-1130-hy000-host-hostname-is-not-allowed-to-connect-to-this-mysql-server-kubers-posterous","status":"publish","type":"post","link":"http:\/\/bucktownbell.com\/?p=653","title":{"rendered":"ERROR 1130 (HY000): Host ‘hostname’ is not allowed to connect to this MySQL server"},"content":{"rendered":"

After a bit of research, the fix in my case was to “GRANT” user root to connect to MySQL on any hosts. By default, user “root” was only allowed to connect to localhost and 127.0.0.1 hosts of MySQL.<\/p>\n

#GRANT ALL PRIVILEGES ON *.* TO ‘root’@’%’ IDENTIFIED BY ‘<roots-password>’ WITH GRANT OPTION;<\/p><\/blockquote>\n

via ERROR 1130 (HY000): Host ‘hostname’ is not allowed to connect to this MySQL server – kuber’s posterous<\/a>.<\/p>\n","protected":false},"excerpt":{"rendered":"

After a bit of research, the fix in my case was to “GRANT” user root to connect to MySQL on any hosts. By default, user “root” was only allowed to connect to localhost and 127.0.0.1 hosts of MySQL. #GRANT ALL … Continue reading →<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[151,72],"class_list":["post-653","post","type-post","status-publish","format-standard","hentry","category-technical","tag-mysql","tag-problem-solved"],"_links":{"self":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/653","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=653"}],"version-history":[{"count":2,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/653\/revisions"}],"predecessor-version":[{"id":3517,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=\/wp\/v2\/posts\/653\/revisions\/3517"}],"wp:attachment":[{"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=653"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=653"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/bucktownbell.com\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=653"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}