{"id":434,"date":"2017-02-19T14:24:05","date_gmt":"2017-02-19T14:24:05","guid":{"rendered":"https:\/\/chemicloud.com\/kb\/?post_type=article&#038;p=434"},"modified":"2020-03-25T14:42:30","modified_gmt":"2020-03-25T14:42:30","slug":"create-database-user","status":"publish","type":"ht_kb","link":"https:\/\/chemicloud.com\/kb\/article\/create-database-user\/","title":{"rendered":"How to Create a Database User"},"content":{"rendered":"<p>You can easily create a new MySQL database user by following these steps:<\/p>\n<p><strong>1)<\/strong>\u00a0<a style=\"box-sizing: border-box; text-decoration: none; outline: none; background: none; color: #2a94e5; line-height: 1; display: inline-block;\" href=\"https:\/\/chemicloud.com\/kb\/article\/login-cpanel-whm-account\/\">Log into cPanel<\/a>.<\/p>\n<p><strong>2)<\/strong> Look for the &#8220;<strong>DATABASES<\/strong>&#8221; section and click on\u00a0<strong>&#8220;MySQL\u00ae Databases&#8221;<\/strong>.<\/p>\n<p><strong>3)<\/strong> Look for the <strong>&#8220;Add New User&#8221;<\/strong> section and enter the username and the password you want to be associated with the user in both fields. You can also click the <strong>&#8220;Password Generator&#8221;<\/strong> and cPanel generates a random, strong password for your username.<\/p>\n<h3 id=\"add-the-user-to-a-database\"><span style=\"font-size: 16px;\">Add the user to a database<\/span><\/h3>\n<p><strong>1)<\/strong> On the same page look for the\u00a0<strong>&#8220;Add User To Database&#8221;<\/strong> section and from the drop down menu select the username that you&#8217;ve just created and the database you want to assign the user to and click <strong>&#8220;Add&#8221;<\/strong>.<\/p>\n<p><strong>2)<\/strong> On the next page, you&#8217;ll assign privileges for the user to the database. If you want to assign full privileges for the user just check the box next to &#8220;<strong>All Privileges&#8221;<\/strong>\u00a0and then click Next Step.<\/p>\n<p><strong>3)<\/strong> You&#8217;ll see a confirmation message that the username has been assigned to your database.<\/p>\n<p>&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>You can easily create a new MySQL database user by following these steps: 1)\u00a0Log into cPanel. 2) Look for the &#8220;DATABASES&#8221; section and click on\u00a0&#8220;MySQL\u00ae Databases&#8221;. 3) Look for the &#8220;Add New User&#8221; section and enter the username and the password you want to be associated with the user in&#8230;<\/p>\n","protected":false},"author":10,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":{"_crdt_document":"","footnotes":""},"ht-kb-category":[38],"ht-kb-tag":[],"class_list":["post-434","ht_kb","type-ht_kb","status-publish","format-standard","hentry","ht_kb_category-mysql"],"_links":{"self":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/434","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/users\/10"}],"replies":[{"embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/comments?post=434"}],"version-history":[{"count":3,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/434\/revisions"}],"predecessor-version":[{"id":2140,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb\/434\/revisions\/2140"}],"wp:attachment":[{"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/media?parent=434"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-category?post=434"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/chemicloud.com\/kb\/wp-json\/wp\/v2\/ht-kb-tag?post=434"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}