{"id":74,"date":"2023-10-06T08:39:39","date_gmt":"2023-10-06T08:39:39","guid":{"rendered":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/?p=74"},"modified":"2023-10-06T14:15:55","modified_gmt":"2023-10-06T14:15:55","slug":"How-to-reset-the-password-for-a-MySQL-database","status":"publish","type":"post","link":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html","title":{"rendered":"How to reset the password for a MySQL database?"},"content":{"rendered":"<div class=\"kb-article-content\">\n<p><span style=\"font-family: arial, helvetica, sans-serif; font-size: medium; color: #000000;\">You may need to change the password of your database in order to improve the security of your website or if your account has been compromised by hackers. Basically the easiest way to change the password for your database is to recreate the MySQL user attached to it. You can use the following instructions to do so:<\/span><\/p>\n<ul>\n<li><span style=\"font-family: arial, helvetica, sans-serif; font-size: medium; color: #000000;\">Log in your <strong>cPanel -&gt; MySQL Databases<\/strong>. Find the corresponding database and see which is the user attached to it.<\/span><span style=\"font-family: arial, helvetica, sans-serif; font-size: medium;\">&nbsp;<\/span><\/li>\n<li>\n<ul>\n<li><span style=\"font-family: arial, helvetica, sans-serif; font-size: medium;\">Find the corresponding database and see which is the user attached to it. For example we will consider that your database is called <em>yourusername_database<\/em> and the database user attached to it is <em>yourusername_user<\/em>.<\/span><\/li>\n<li><span style=\"font-family: arial, helvetica, sans-serif; font-size: medium;\">Scroll to the bottom of the page and you will see a field called <em>Current Users<\/em>. There is a little circle with X in it \u2013 press it to delete the database user <em>yourusername_user<\/em>.<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><span style=\"font-family: arial, helvetica, sans-serif; font-size: medium; color: #000000;\">You will be prompted to confirm this action:<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif; color: #000000; font-size: medium;\"><em>Are you sure you wish to permanently remove user yourusername_user?<\/em><\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif; color: #000000; font-size: medium;\">Click on the <strong>Delete User<\/strong> button in order for the database user to be successfully deleted.<\/span><\/p>\n<p><span style=\"font-family: arial, helvetica, sans-serif; font-size: medium; color: #000000;\">Then you should create a new database user:<\/span><\/p>\n<ul style=\"list-style-type: circle;\">\n<li><span style=\"font-family: arial, helvetica, sans-serif; font-size: medium; color: #000000;\">Go back to <strong>cPanel -&gt; MySQL Databases<\/strong> and create a new user:<\/span><\/li>\n<li><span style=\"font-family: arial, helvetica, sans-serif; font-size: medium; color: #000000;\">Type the same database username and type (or generate) the new password for it. Bear in mind that you will be able to change only the <em>user<\/em> part of the database name <em>yourusername_user<\/em>. The prefix <em>yourusername_<\/em> is added by default by the system.<\/span><\/li>\n<\/ul>\n<p style=\"margin-left: 30px;\"><span style=\"font-size: medium; color: #000000;\"><span style=\"font-family: arial, helvetica, sans-serif;\">When the MySQL user is created you have to attach it to your database\/s. On the same page you will find a section called<\/span> <strong>Add User To Database<\/strong> \u2013 just assign the database user to the desired database\/s and grant all privileges for it.<\/span><\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<p>You may need to change the password of your database in order to improve the security of your website or if your account has been compromised by hackers. Basically the easiest way to change the password for your database is to recreate the MySQL user attached to it. You can use the following instructions to [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[53],"tags":[],"class_list":["post-74","post","type-post","status-publish","format-standard","hentry","category-cpanel-sql-cpanel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v21.3 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>How to reset the password for a MySQL database?<\/title>\n<meta name=\"description\" content=\"To reset the password for a MySQL database, you have to go through the following steps.\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"How to reset the password for a MySQL database?\" \/>\n<meta property=\"og:description\" content=\"To reset the password for a MySQL database, you have to go through the following steps.\" \/>\n<meta property=\"og:url\" content=\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html\" \/>\n<meta property=\"og:site_name\" content=\"Host IT Smart Knowledge base\" \/>\n<meta property=\"article:published_time\" content=\"2023-10-06T08:39:39+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-10-06T14:15:55+00:00\" \/>\n<meta name=\"author\" content=\"Admin\" \/>\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=\"2 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html#article\",\"isPartOf\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html\"},\"author\":{\"name\":\"Admin\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/8b538056beea86b043adbd20df3a6ee9\"},\"headline\":\"How to reset the password for a MySQL database?\",\"datePublished\":\"2023-10-06T08:39:39+00:00\",\"dateModified\":\"2023-10-06T14:15:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html\"},\"wordCount\":302,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization\"},\"articleSection\":[\"Cpanel sql\"],\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html\",\"url\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html\",\"name\":\"How to reset the password for a MySQL database?\",\"isPartOf\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#website\"},\"datePublished\":\"2023-10-06T08:39:39+00:00\",\"dateModified\":\"2023-10-06T14:15:55+00:00\",\"description\":\"To reset the password for a MySQL database, you have to go through the following steps.\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html\"]}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#website\",\"url\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/\",\"name\":\"Host IT Smart Knowledge base\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization\",\"name\":\"Host IT Smart Knowledge base\",\"url\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/logo\/image\/\",\"url\":\"\",\"contentUrl\":\"\",\"width\":240,\"height\":80,\"caption\":\"Host IT Smart Knowledge base\"},\"image\":{\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/8b538056beea86b043adbd20df3a6ee9\",\"name\":\"Admin\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/17348df3a33347d3945161d87b752de1d7a7ec25dcbe15baacbd3b8a35367f66?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/17348df3a33347d3945161d87b752de1d7a7ec25dcbe15baacbd3b8a35367f66?s=96&d=mm&r=g\",\"caption\":\"Admin\"},\"sameAs\":[\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/\"],\"url\":\"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/author\/admin\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"How to reset the password for a MySQL database?","description":"To reset the password for a MySQL database, you have to go through the following steps.","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:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html","og_locale":"en_US","og_type":"article","og_title":"How to reset the password for a MySQL database?","og_description":"To reset the password for a MySQL database, you have to go through the following steps.","og_url":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html","og_site_name":"Host IT Smart Knowledge base","article_published_time":"2023-10-06T08:39:39+00:00","article_modified_time":"2023-10-06T14:15:55+00:00","author":"Admin","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Admin","Est. reading time":"2 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html#article","isPartOf":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html"},"author":{"name":"Admin","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/8b538056beea86b043adbd20df3a6ee9"},"headline":"How to reset the password for a MySQL database?","datePublished":"2023-10-06T08:39:39+00:00","dateModified":"2023-10-06T14:15:55+00:00","mainEntityOfPage":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html"},"wordCount":302,"commentCount":0,"publisher":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization"},"articleSection":["Cpanel sql"],"inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html#respond"]}]},{"@type":"WebPage","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html","url":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html","name":"How to reset the password for a MySQL database?","isPartOf":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#website"},"datePublished":"2023-10-06T08:39:39+00:00","dateModified":"2023-10-06T14:15:55+00:00","description":"To reset the password for a MySQL database, you have to go through the following steps.","inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/74\/How-to-reset-the-password-for-a-MySQL-database.html"]}]},{"@type":"WebSite","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#website","url":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/","name":"Host IT Smart Knowledge base","description":"","publisher":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#organization","name":"Host IT Smart Knowledge base","url":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/logo\/image\/","url":"","contentUrl":"","width":240,"height":80,"caption":"Host IT Smart Knowledge base"},"image":{"@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/8b538056beea86b043adbd20df3a6ee9","name":"Admin","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/17348df3a33347d3945161d87b752de1d7a7ec25dcbe15baacbd3b8a35367f66?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/17348df3a33347d3945161d87b752de1d7a7ec25dcbe15baacbd3b8a35367f66?s=96&d=mm&r=g","caption":"Admin"},"sameAs":["https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/"],"url":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/author\/admin"}]}},"_links":{"self":[{"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/posts\/74","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/comments?post=74"}],"version-history":[{"count":1,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/posts\/74\/revisions"}],"predecessor-version":[{"id":373,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/posts\/74\/revisions\/373"}],"wp:attachment":[{"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/media?parent=74"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/categories?post=74"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/new.hostitsmart.com\/manage\/knowledgebase\/wp-json\/wp\/v2\/tags?post=74"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}