{"id":1895,"date":"2019-10-03T16:56:47","date_gmt":"2019-10-03T08:56:47","guid":{"rendered":"https:\/\/www.mondoze.com\/guide\/?post_type=kb&#038;p=1895"},"modified":"2022-10-07T07:50:58","modified_gmt":"2022-10-06T23:50:58","slug":"how-to-update-mysql-database-user-privilege","status":"publish","type":"kb","link":"https:\/\/www.mondoze.com\/guide\/kb\/how-to-update-mysql-database-user-privilege","title":{"rendered":"How to update MySQL Database user privilege"},"content":{"rendered":"\t\t<div data-elementor-type=\"wp-post\" data-elementor-id=\"1895\" class=\"elementor elementor-1895\" data-elementor-settings=\"[]\">\n\t\t\t\t\t\t<div class=\"elementor-inner\">\n\t\t\t\t\t\t\t<div class=\"elementor-section-wrap\">\n\t\t\t\t\t\t\t<section class=\"elementor-section elementor-top-section elementor-element elementor-element-2b8ae600 elementor-section-boxed elementor-section-height-default elementor-section-height-default\" data-id=\"2b8ae600\" data-element_type=\"section\">\n\t\t\t\t\t\t<div class=\"elementor-container elementor-column-gap-default\">\n\t\t\t\t\t\t\t<div class=\"elementor-row\">\n\t\t\t\t\t<div class=\"elementor-column elementor-col-100 elementor-top-column elementor-element elementor-element-34feb19e\" data-id=\"34feb19e\" data-element_type=\"column\">\n\t\t\t<div class=\"elementor-column-wrap elementor-element-populated\">\n\t\t\t\t\t\t\t<div class=\"elementor-widget-wrap\">\n\t\t\t\t\t\t<div class=\"elementor-element elementor-element-42a8b0e elementor-widget elementor-widget-heading\" data-id=\"42a8b0e\" data-element_type=\"widget\" data-widget_type=\"heading.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t<h2 class=\"elementor-heading-title elementor-size-default\">How To Update MySQL Database User Privilege<\/h2>\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t<div class=\"elementor-element elementor-element-36f11a95 elementor-widget elementor-widget-text-editor\" data-id=\"36f11a95\" data-element_type=\"widget\" data-widget_type=\"text-editor.default\">\n\t\t\t\t<div class=\"elementor-widget-container\">\n\t\t\t\t\t\t\t\t<div class=\"elementor-text-editor elementor-clearfix\">\n\t\t\t\t<p style=\"font-weight: 400;\">This article will show the steps on how you manage the database user privilege, update MySQL Database.\u00a0<\/p><p style=\"font-weight: 400;\">1) Login into your server\u2019s cPanel and look for the category &#8220;Databases&#8221;. Click the &#8220;MySQL@Databases&#8221;.<\/p><p style=\"font-weight: 400;\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-1896\" src=\"https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/Database-user-privilege1-300x69.png\" alt=\"\" width=\"300\" height=\"69\" \/><\/p><p style=\"font-weight: 400;\">2) Click on the database user under the &#8221; Current Databases &#8221; section table.<\/p><p style=\"font-weight: 400;\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-1897\" src=\"https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/Database-user-privilege2-300x84.png\" alt=\"\" width=\"300\" height=\"84\" \/><\/p><p style=\"font-weight: 400;\">3) Manage and update the privileges by tick or untick on the small boxes. Click &#8221; Make Changes &#8221; to save it.<\/p><p style=\"font-weight: 400;\"><img decoding=\"async\" loading=\"lazy\" class=\"alignnone size-medium wp-image-1900\" src=\"https:\/\/www.mondoze.com\/guide\/wp-content\/uploads\/2021\/03\/Database-user-privilege3-300x208.png\" alt=\"\" width=\"300\" height=\"208\" \/><\/p>\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/div>\n\t\t\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t<\/section>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t\t<\/div>\n\t\t\t\t\t<\/div>\n\t\t","protected":false},"excerpt":{"rendered":"<p>How To Update MySQL Database User Privilege This article will show the steps on how you manage the database user privilege, update MySQL Database.\u00a0 1) Login into your server\u2019s cPanel and look for the category &#8220;Databases&#8221;. Click the &#8220;MySQL@Databases&#8221;. 2) Click on the database user under the &#8221; Current Databases &#8221; section table. 3) Manage &hellip;<\/p>\n<p class=\"read-more\"> <a class=\"\" href=\"https:\/\/www.mondoze.com\/guide\/kb\/how-to-update-mysql-database-user-privilege\"> <span class=\"screen-reader-text\">How to update MySQL Database user privilege<\/span> Read More \u00bb<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","template":"","meta":{"site-sidebar-layout":"default","site-content-layout":"default","ast-site-content-layout":"","site-content-style":"default","site-sidebar-style":"default","ast-global-header-display":"","ast-banner-title-visibility":"","ast-main-header-display":"","ast-hfb-above-header-display":"","ast-hfb-below-header-display":"","ast-hfb-mobile-header-display":"","site-post-title":"","ast-breadcrumbs-content":"","ast-featured-img":"","footer-sml-layout":"","theme-transparent-header-meta":"default","adv-header-id-meta":"","stick-header-meta":"default","header-above-stick-meta":"","header-main-stick-meta":"","header-below-stick-meta":"","astra-migrate-meta-layouts":"","ast-page-background-enabled":"default","ast-page-background-meta":{"desktop":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}},"ast-content-background-meta":{"desktop":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"tablet":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""},"mobile":{"background-color":"var(--ast-global-color-5)","background-image":"","background-repeat":"repeat","background-position":"center center","background-size":"auto","background-attachment":"scroll","background-type":"","background-media":"","overlay-type":"","overlay-color":"","overlay-gradient":""}}},"kbtopic":[123],"kbtag":[110],"mkb_version":[],"_links":{"self":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/1895"}],"collection":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb"}],"about":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/types\/kb"}],"author":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/comments?post=1895"}],"version-history":[{"count":9,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/1895\/revisions"}],"predecessor-version":[{"id":18496,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kb\/1895\/revisions\/18496"}],"wp:attachment":[{"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/media?parent=1895"}],"wp:term":[{"taxonomy":"kbtopic","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtopic?post=1895"},{"taxonomy":"kbtag","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/kbtag?post=1895"},{"taxonomy":"mkb_version","embeddable":true,"href":"https:\/\/www.mondoze.com\/guide\/wp-json\/wp\/v2\/mkb_version?post=1895"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}