{"id":2124,"date":"2020-06-09T03:04:10","date_gmt":"2020-06-08T19:04:10","guid":{"rendered":"https:\/\/www.wesbytes.com\/guide\/?post_type=kb&#038;p=2124"},"modified":"2026-03-17T15:11:54","modified_gmt":"2026-03-17T07:11:54","slug":"how-to-update-mysql-database-user","status":"publish","type":"kb","link":"https:\/\/www.servergigabit.com\/guide\/kb\/how-to-update-mysql-database-user","title":{"rendered":"4 Simple Steps to Update MySQL Database User Privileges Effectively"},"content":{"rendered":"<h4>This article will show the steps on how you manage update MySQL Database user privilege.<\/h4>\n<p>1) Login into your server\u2019s<a href=\"https:\/\/www.cpanel.net\/\" rel=\"nofollow noopener\" target=\"_blank\"> cPanel<\/a> and look for the category \u201c<strong>Databases<\/strong>\u201d. Click the \u201c<strong>MySQL@Databases<\/strong>\u201d.<\/p>\n<p>2) Click on the database user under the \u201d Current Databases \u201d section table.<\/p>\n<p>3) Manage and update the MySQL User privileges by tick or untick on the small boxes.<\/p>\n<p>4) Click \u201d Make Changes \u201d to save it and you&#8217;re sucessfully update MyQSL user privilege.<\/p>\n<p><span style=\"font-size: 16px;\">\u00a0<\/span><\/p>\n<p>&nbsp;<\/p>\n<p><em>Please refer to the following article to know more.\u00a0<\/em><br \/>\n<strong>Knowledge Base: <\/strong><a href=\"https:\/\/www.servergigabit.com\/guide\/kb\/what-is-the-port-does-mysql-use\/\">What is the port does MySQL use?<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"<p>This article will show the steps on how you manage update MySQL Database user privilege. 1) Login into your server\u2019s cPanel and look for the category \u201cDatabases\u201d. Click the \u201cMySQL@Databases\u201d. 2) Click on the database user under the \u201d Current Databases \u201d section table. 3) Manage and update the MySQL User privileges by tick or untick on the small boxes.&hellip;<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"footnotes":""},"kbtopic":[51],"kbtag":[1311],"class_list":["post-2124","kb","type-kb","status-publish","hentry","kbtopic-mysql","kbtag-updat-mysql-database"],"_links":{"self":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2124","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/comments?post=2124"}],"version-history":[{"count":5,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2124\/revisions"}],"predecessor-version":[{"id":6376,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kb\/2124\/revisions\/6376"}],"wp:attachment":[{"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/media?parent=2124"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=2124"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.servergigabit.com\/guide\/wp-json\/wp\/v2\/kbtag?post=2124"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}