{"id":103,"date":"2010-12-21T11:34:39","date_gmt":"2010-12-21T16:34:39","guid":{"rendered":"http:\/\/mtecheasy.wordpress.com\/?p=103"},"modified":"2010-12-21T11:34:39","modified_gmt":"2010-12-21T16:34:39","slug":"grant-access-permissions-on-mysql","status":"publish","type":"post","link":"https:\/\/bourbonnaisservices.com\/blog\/2010\/12\/grant-access-permissions-on-mysql\/","title":{"rendered":"Grant access permissions on MySQL"},"content":{"rendered":"<p><em><strong>mysql&gt; GRANT ALL ON &lt;database&gt;.* TO &lt;user&gt;@&lt;host&gt; IDENTIFIED BY &#8216;&lt;password&gt;&#8217;;<\/strong><\/em><\/p>\n<p><em>*** Note that if the specified user account does not exist, it will be created. ***<\/em><\/p>\n<p><strong>&lt;database&gt;:<\/strong> The name of the database, for example &#8220;my_new_database&#8221;.<br \/>\n<strong>&lt;user&gt;:<\/strong> The username that will be used to access the database.<br \/>\n<strong>&lt;host&gt;: <\/strong>The hostname of the server on which the database will be running.<br \/>\n<strong>&lt;password&gt;: <\/strong>The password you wish to set in order to limit access to the database.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>mysql&gt; GRANT ALL ON &lt;database&gt;.* TO &lt;user&gt;@&lt;host&gt; IDENTIFIED BY &#8216;&lt;password&gt;&#8217;; *** Note that if the specified user account does not exist, it will be created. *** &lt;database&gt;: The name of the database, for example &#8220;my_new_database&#8221;. &lt;user&gt;: The username that will be used to access the database. &lt;host&gt;: The hostname of the server on which the [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":[],"categories":[8],"tags":[],"_links":{"self":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/posts\/103"}],"collection":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/comments?post=103"}],"version-history":[{"count":0,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/posts\/103\/revisions"}],"wp:attachment":[{"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/media?parent=103"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/categories?post=103"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/bourbonnaisservices.com\/blog\/wp-json\/wp\/v2\/tags?post=103"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}