{"id":235,"date":"2013-07-01T08:59:00","date_gmt":"2013-07-01T08:59:00","guid":{"rendered":"http:\/\/118@jodohost.com\/\/blog\/"},"modified":"2013-07-01T08:59:00","modified_gmt":"2013-07-01T08:59:00","slug":"mysql-dba-permissions","status":"publish","type":"post","link":"http:\/\/www.jodohost.com\/blog\/index.php\/2013\/07\/01\/mysql-dba-permissions\/","title":{"rendered":"MySQL DBA permissions"},"content":{"rendered":"<p>Issue : While restoring the MySQL database using a third party tool like SQLyog, sometimes we get an error like this : <\/p>\n<p>Error occured at:2013-07-01 15:00:44<br \/>Line no.:XX<br \/>Error Code: 1142 &#8211; CREATE command denied to user &#8216;Database_User&#8217;<\/p>\n<p>Solution : The most probable solution for this issue is to grant DBA permission to the database user. Actually the reason for this issue is that the database user &#8220;Database_User&#8221; is not given the DBA permission. To know how to grant a DB user permissions, please follow this link :<\/p>\n<p>http:\/\/www.jodohost.com\/hsphere\/html\/mysql_support.html<\/p>\n<p> ]]><\/p>\n","protected":false},"excerpt":{"rendered":"<p>Issue : While restoring the MySQL database using a third party tool like SQLyog, sometimes we get an error like this : Error occured at:2013-07-01 15:00:44Line no.:XXError Code: 1142 &#8211; CREATE command denied to user &#8216;Database_User&#8217; Solution : The most probable solution for this issue is to grant DBA permission to the database user. Actually [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[2],"tags":[],"_links":{"self":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/235"}],"collection":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/comments?post=235"}],"version-history":[{"count":0,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/posts\/235\/revisions"}],"wp:attachment":[{"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/media?parent=235"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/categories?post=235"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.jodohost.com\/blog\/index.php\/wp-json\/wp\/v2\/tags?post=235"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}