{"id":2795,"date":"2021-10-08T12:45:03","date_gmt":"2021-10-08T12:45:03","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=2795"},"modified":"2021-10-08T12:45:03","modified_gmt":"2021-10-08T12:45:03","slug":"how-to-delete-a-mysql-user","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/","title":{"rendered":"How to delete a MySQL user ?"},"content":{"rendered":"

Login to your server via SSH & access MySQL prompt, To delete a MySQL user.<\/p>\n

\"dltmsql\"<\/p>\n

Select the database mysql & follow the steps as given below. Here, the database is mysql. Replace the database name as required.<\/p>\n

mysql> use mysql;<\/strong>
\nmysql> DELETE FROM user where user=\u2019username\u2019;<\/strong>
\nmysql> FLUSH PRIVILEGES;<\/strong><\/p>\n

Replace \u2018username\u2019 with the username of the user you want to delete. Also, Which has the user records stored select that table make sure you select the correct table. Then run this as the root user or an account that has appropriate privileges on the grant tables.<\/p>\n","protected":false},"excerpt":{"rendered":"

Login to your server via SSH & access MySQL prompt, To delete a MySQL user. Select the database mysql & follow the steps as given below. Here, the database is mysql. Replace the database name as required. mysql> use mysql; mysql> DELETE FROM user where user=\u2019username\u2019; mysql> FLUSH PRIVILEGES; Replace \u2018username\u2019 with the username of […]<\/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-2795","post","type-post","status-publish","format-standard","hentry","category-mysql"],"yoast_head":"\nHow to delete a MySQL user ? - OWS KB<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to delete a MySQL user ? - OWS KB\" \/>\n<meta property=\"og:description\" content=\"Login to your server via SSH & access MySQL prompt, To delete a MySQL user. Select the database mysql & follow the steps as given below. Here, the database is mysql. Replace the database name as required. mysql> use mysql; mysql> DELETE FROM user where user=\u2019username\u2019; mysql> FLUSH PRIVILEGES; Replace \u2018username\u2019 with the username of […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-10-08T12:45:03+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/dltmsql-300x96.jpg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"0 minutes\">\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"OWS KB\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/ownwebservers.com\/kb\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/10\/dltmsql.jpg\",\"width\":638,\"height\":205,\"caption\":\"dltmsql\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/\",\"name\":\"How to delete a MySQL user ? - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/#primaryimage\"},\"datePublished\":\"2021-10-08T12:45:03+00:00\",\"dateModified\":\"2021-10-08T12:45:03+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/\",\"name\":\"Home\"}},{\"@type\":\"ListItem\",\"position\":2,\"item\":{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/how-to-delete-a-mysql-user\/\",\"name\":\"How to delete a MySQL user ?\"}}]},{\"@type\":\"Person\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\",\"name\":\"admin\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/#personlogo\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/ba5db5841d48bd7517bb2583e13983e6d2fa56a4099a0b3c61ad2daefc321303?s=96&d=mm&r=g\",\"caption\":\"admin\"},\"sameAs\":[\"https:\/\/ownwebservers.com\/kb\"]}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","_links":{"self":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2795","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=2795"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2795\/revisions"}],"predecessor-version":[{"id":2797,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2795\/revisions\/2797"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=2795"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=2795"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=2795"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}