{"id":2870,"date":"2021-10-11T09:04:32","date_gmt":"2021-10-11T09:04:32","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=2870"},"modified":"2021-10-11T09:22:59","modified_gmt":"2021-10-11T09:22:59","slug":"how-to-grant-all-privileges-to-a-user-in-mysql-with-cpanel","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/how-to-grant-all-privileges-to-a-user-in-mysql-with-cpanel\/","title":{"rendered":"How to Grant all Privileges to a User in MySQL with cPanel?"},"content":{"rendered":"

In a database The MySQL privilege system authenticates a user to make specific changes. Supported the privileges granted, a user will carry functions like SELECT, INSERT, UPDATE, DELETE etc. on the database. you’ll be able to access this method in cPanel.<\/p>\n

To Grant all Privileges in MySQL with cPanel follow the steps as below:<\/h3>\n

Step 1.<\/strong> Log in to your cPanel<\/strong> account using login details.<\/p>\n

Step 2.<\/strong> Navigate to the DATABASES<\/strong> section and click on MySQL\u00ae Databases<\/strong>.<\/p>\n

\"dbmysql-1\"<\/p>\n

Step 3.<\/strong> Scroll right down to the Add User<\/strong> To Database within the MySQL Users<\/strong> section. choose the user you wish to assign privileges and along with the database of your choice. Now, click the Add<\/strong> button.<\/p>\n

\"dbmysql-2\"<\/p>\n

Step 4.<\/strong> The system redirects you to Manage User Privileges<\/strong>, where you’ll be able to choose the privileges you wish the user to possess.<\/p>\n

Step 5.<\/strong> Since we wish the user to possess all privileges, tick the ALL PRIVILEGES<\/strong> box and click on the Make Changes<\/strong> button. Successful message will flash indicating the system has saved the selected privileges for the user. From the bottom of the list Click on Go Back<\/strong>.<\/p>\n

\"dbmysql-3\"<\/p>\n

You will return to the MySQL\u00ae Databases. Here, you’ll be able to spot the user you simply granted privileges below the Privileged Users column of Current Databases table.<\/p>\n

\"dbmysql-4\"<\/p>\n","protected":false},"excerpt":{"rendered":"

In a database The MySQL privilege system authenticates a user to make specific changes. Supported the privileges granted, a user will carry functions like SELECT, INSERT, UPDATE, DELETE etc. on the database. you’ll be able to access this method in cPanel. To Grant all Privileges in MySQL with cPanel follow the steps as below: Step […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[17],"tags":[],"class_list":["post-2870","post","type-post","status-publish","format-standard","hentry","category-mysql"],"_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2870","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/comments?post=2870"}],"version-history":[{"count":4,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2870\/revisions"}],"predecessor-version":[{"id":2882,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2870\/revisions\/2882"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=2870"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=2870"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=2870"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}