{"id":24,"date":"2012-08-30T10:45:33","date_gmt":"2012-08-30T10:45:33","guid":{"rendered":"https:\/\/www.nicktailor.com\/?p=24"},"modified":"2012-11-06T11:53:26","modified_gmt":"2012-11-06T11:53:26","slug":"how-to-fix-horde-db-connect-failed-error-with-cpanel","status":"publish","type":"post","link":"https:\/\/nicktailor.com\/tech-blog\/how-to-fix-horde-db-connect-failed-error-with-cpanel\/","title":{"rendered":"How to fix horde DB connect failed error with cpanel"},"content":{"rendered":"<p>The easiest way to see whats wrong is see if horde is able to connect to mysql<\/p>\n<p>cat \/usr\/local\/cpanel\/base\/horde\/config\/conf.php | grep conf | grep sql<\/p>\n<p>This should show what horde is using for mysql user and pass<\/p>\n<p>Then run<\/p>\n<p>mysql -h &lt;host if remote&gt; or localhost -u horde -p&lt;password&gt;<\/p>\n<p>If you get an error of some kind, then you need log into mysql and run the following below<\/p>\n<p>GRANT ALL ON *.* TO &#8216;horde&#8217;@&#8217;whatever host the error said or use localhost&#8217; identified by &#8216;whatever password it said above&#8217;;<\/p>\n<p>Example<br \/>\nGRANT ALL ON *.* TO &#8216;horde&#8217;@&#8217;localhost&#8217; identified by &#8216;password&#8217;;<\/p>\n<p>Next run<\/p>\n<p>Mysql&gt; flush privileges; &lt;&#8211;at the mysql prompt<\/p>\n<p>test your mysql connect again with the first step if it works try in a browser, it should work now.<\/p>\n<p>Cheers<\/p>\n<p>Nick Tailor<\/p>\n","protected":false},"excerpt":{"rendered":"<p>The easiest way to see whats wrong is see if horde is able to connect to mysql cat \/usr\/local\/cpanel\/base\/horde\/config\/conf.php | grep conf | grep sql This should show what horde is using for mysql user and pass Then run mysql -h &lt;host if remote&gt; or localhost -u horde -p&lt;password&gt; If you get an error of some kind, then you need<a href=\"https:\/\/nicktailor.com\/tech-blog\/how-to-fix-horde-db-connect-failed-error-with-cpanel\/\" class=\"read-more\">Read More &#8230;<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[4],"tags":[],"class_list":["post-24","post","type-post","status-publish","format-standard","hentry","category-cpanel"],"_links":{"self":[{"href":"https:\/\/nicktailor.com\/tech-blog\/wp-json\/wp\/v2\/posts\/24","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/nicktailor.com\/tech-blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/nicktailor.com\/tech-blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/nicktailor.com\/tech-blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/nicktailor.com\/tech-blog\/wp-json\/wp\/v2\/comments?post=24"}],"version-history":[{"count":6,"href":"https:\/\/nicktailor.com\/tech-blog\/wp-json\/wp\/v2\/posts\/24\/revisions"}],"predecessor-version":[{"id":135,"href":"https:\/\/nicktailor.com\/tech-blog\/wp-json\/wp\/v2\/posts\/24\/revisions\/135"}],"wp:attachment":[{"href":"https:\/\/nicktailor.com\/tech-blog\/wp-json\/wp\/v2\/media?parent=24"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/nicktailor.com\/tech-blog\/wp-json\/wp\/v2\/categories?post=24"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/nicktailor.com\/tech-blog\/wp-json\/wp\/v2\/tags?post=24"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}