{"id":3262,"date":"2020-11-20T04:17:53","date_gmt":"2020-11-19T22:47:53","guid":{"rendered":"https:\/\/www.24x7serversupport.com\/blog\/?p=3262"},"modified":"2020-11-20T04:17:57","modified_gmt":"2020-11-19T22:47:57","slug":"plesk-repair-utility-mysql","status":"publish","type":"post","link":"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/","title":{"rendered":"Plesk Repair Utility: MySQL"},"content":{"rendered":"\n<ul class=\"wp-block-list\"><li><code>connection<\/code> &#8211; Checks that the MySQL database servers registered in Plesk are available and can be connected to. &#8220;<code>plesk repair mysql -connection\"<\/code> &#8211; Checks that the MySQL database servers registered in Plesk are available and can be connected to.<\/li><li><code>-databases<\/code> &#8211; Checks that all MySQL databases created in Plesk exist on the database servers. Recreates any databases that are missing. &#8220;<code>plesk repair mysql<\/code>&#8221; &#8211; Checks the availability of MySQL database servers and verify the integrity of MySQL databases and database users.<\/li><li><code>-database-users<\/code> &#8211; Checks that all MySQL database users created in Plesk exist on the database servers. Checks database users\u2019 privileges and corrects them if there are discrepancies. Recreates any database users that are missing. <code>plesk repair mysql -database-users<\/code> &#8211; Checks that all MySQL database users created in Plesk exist on the database servers. Checks database users\u2019 privileges and corrects them if there are discrepancies. Recreates any database users that are missing.<\/li><\/ul>\n\n\n\n<p>Plesk Repair Utility: Plesk Database<\/p>\n\n\n\n<p><strong>plesk repair db<\/strong> \u2013 Check the Plesk database for consistency.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>connection &#8211; Checks that the MySQL database servers registered in Plesk are available and can be connected to. &#8220;plesk repair mysql -connection&#8221; &#8211; Checks that the MySQL database servers registered in Plesk are available and can be connected to. -databases &#8211; Checks that all MySQL databases created in Plesk exist on the database servers. Recreates [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":"","jetpack_publicize_message":"","jetpack_publicize_feature_enabled":true,"jetpack_social_post_already_shared":false,"jetpack_social_options":{"image_generator_settings":{"template":"highway","enabled":false}}},"categories":[35,37],"tags":[],"class_list":["post-3262","post","type-post","status-publish","format-standard","hentry","category-plesk","category-windows"],"jetpack_publicize_connections":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v22.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>Plesk Repair Utility: MySQL | 24x7serversupport Blog<\/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:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Plesk Repair Utility: MySQL | 24x7serversupport Blog\" \/>\n<meta property=\"og:description\" content=\"connection &#8211; Checks that the MySQL database servers registered in Plesk are available and can be connected to. &#8220;plesk repair mysql -connection&quot; &#8211; Checks that the MySQL database servers registered in Plesk are available and can be connected to. -databases &#8211; Checks that all MySQL databases created in Plesk exist on the database servers. Recreates [&hellip;]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/\" \/>\n<meta property=\"og:site_name\" content=\"24x7serversupport Blog\" \/>\n<meta property=\"article:published_time\" content=\"2020-11-19T22:47:53+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2020-11-19T22:47:57+00:00\" \/>\n<meta name=\"author\" content=\"24x7support\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:site\" content=\"@24x7serversuppo\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"24x7support\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"1 minute\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebPage\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/\",\"name\":\"Plesk Repair Utility: MySQL | 24x7serversupport Blog\",\"isPartOf\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\"},\"datePublished\":\"2020-11-19T22:47:53+00:00\",\"dateModified\":\"2020-11-19T22:47:57+00:00\",\"author\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\"},\"breadcrumb\":{\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/www.24x7serversupport.com\/blog\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Plesk Repair Utility: MySQL\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#website\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/\",\"name\":\"24x7serversupport Blog\",\"description\":\"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401\",\"name\":\"24x7support\",\"url\":\"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Plesk Repair Utility: MySQL | 24x7serversupport Blog","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/","og_locale":"en_US","og_type":"article","og_title":"Plesk Repair Utility: MySQL | 24x7serversupport Blog","og_description":"connection &#8211; Checks that the MySQL database servers registered in Plesk are available and can be connected to. &#8220;plesk repair mysql -connection\" &#8211; Checks that the MySQL database servers registered in Plesk are available and can be connected to. -databases &#8211; Checks that all MySQL databases created in Plesk exist on the database servers. Recreates [&hellip;]","og_url":"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/","og_site_name":"24x7serversupport Blog","article_published_time":"2020-11-19T22:47:53+00:00","article_modified_time":"2020-11-19T22:47:57+00:00","author":"24x7support","twitter_card":"summary_large_image","twitter_creator":"@24x7serversuppo","twitter_site":"@24x7serversuppo","twitter_misc":{"Written by":"24x7support","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"WebPage","@id":"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/","url":"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/","name":"Plesk Repair Utility: MySQL | 24x7serversupport Blog","isPartOf":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#website"},"datePublished":"2020-11-19T22:47:53+00:00","dateModified":"2020-11-19T22:47:57+00:00","author":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401"},"breadcrumb":{"@id":"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/www.24x7serversupport.com\/blog\/plesk-repair-utility-mysql\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.24x7serversupport.com\/blog\/"},{"@type":"ListItem","position":2,"name":"Plesk Repair Utility: MySQL"}]},{"@type":"WebSite","@id":"https:\/\/www.24x7serversupport.com\/blog\/#website","url":"https:\/\/www.24x7serversupport.com\/blog\/","name":"24x7serversupport Blog","description":"Linux | CPanel | WHM | webhosting| Plesk | DirectAdmin | CentOs | Debian | Ubuntu Blog","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.24x7serversupport.com\/blog\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.24x7serversupport.com\/blog\/#\/schema\/person\/decfb5fad6bde6ac6822d4e965c6d401","name":"24x7support","url":"https:\/\/www.24x7serversupport.com\/blog\/author\/24x7support\/"}]}},"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3262","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/comments?post=3262"}],"version-history":[{"count":1,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3262\/revisions"}],"predecessor-version":[{"id":3263,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/posts\/3262\/revisions\/3263"}],"wp:attachment":[{"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/media?parent=3262"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/categories?post=3262"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.24x7serversupport.com\/blog\/wp-json\/wp\/v2\/tags?post=3262"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}