{"id":2222,"date":"2021-09-23T13:29:13","date_gmt":"2021-09-23T13:29:13","guid":{"rendered":"https:\/\/ownwebservers.com\/kb\/?p=2222"},"modified":"2021-09-23T13:29:13","modified_gmt":"2021-09-23T13:29:13","slug":"database-troubleshooting-tips","status":"publish","type":"post","link":"https:\/\/ownwebservers.com\/kb\/database-troubleshooting-tips\/","title":{"rendered":"Database Troubleshooting Tips"},"content":{"rendered":"

While Troubleshooting if you get “Cannot connect to the database” such errors… Here are a some important things (common mistakes)that you have to take a look at:<\/p>\n

After you created your database and database user make sure that you didn’t forget to ADD the database user to the database (at the bottom of the “Databases” section in Control Panel > MySQL Databases. Just scroll down of page and you will see an “Add User to DB” button).<\/p>\n

\"mysqldb\"<\/p>\n

\"mysqldb-1\"<\/p>\n

Confirm that you entered your domain name as the database host\/server name and if applicable that you specified MySQL for the database server type.<\/p>\n

– Make sure that you specified the correct database and database username. These values are\u00a0cAsE sEnSiTiVe<\/em><\/strong>\u00a0be aware that your account userid (usually the first 7 characters of your domain name) is added with an underscore as a prefix to both your database and database user names (userid_dbname rather than just dbname and userid_dbuser instead of just dbuser).<\/p>\n

– As far as the password make sure that you use the password that you assigned to your database user in MySQL Manager (NOT your account password)<\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

While Troubleshooting if you get “Cannot connect to the database” such errors… Here are a some important things (common mistakes)that you have to take a look at: After you created your database and database user make sure that you didn’t forget to ADD the database user to the database (at the bottom of the “Databases” […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[23],"tags":[],"class_list":["post-2222","post","type-post","status-publish","format-standard","hentry","category-tutorials"],"yoast_head":"\nDatabase Troubleshooting Tips - 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\/database-troubleshooting-tips\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Database Troubleshooting Tips - OWS KB\" \/>\n<meta property=\"og:description\" content=\"While Troubleshooting if you get “Cannot connect to the database” such errors… Here are a some important things (common mistakes)that you have to take a look at: After you created your database and database user make sure that you didn’t forget to ADD the database user to the database (at the bottom of the “Databases” […]\" \/>\n<meta property=\"og:url\" content=\"https:\/\/ownwebservers.com\/kb\/database-troubleshooting-tips\/\" \/>\n<meta property=\"og:site_name\" content=\"OWS KB\" \/>\n<meta property=\"article:published_time\" content=\"2021-09-23T13:29:13+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/mysqldb-300x75.png\" \/>\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=\"1 minute\">\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\/database-troubleshooting-tips\/#primaryimage\",\"inLanguage\":\"en-US\",\"url\":\"https:\/\/ownwebservers.com\/kb\/wp-content\/uploads\/2021\/09\/mysqldb.png\",\"width\":1073,\"height\":270,\"caption\":\"mysqldb\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/database-troubleshooting-tips\/#webpage\",\"url\":\"https:\/\/ownwebservers.com\/kb\/database-troubleshooting-tips\/\",\"name\":\"Database Troubleshooting Tips - OWS KB\",\"isPartOf\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/database-troubleshooting-tips\/#primaryimage\"},\"datePublished\":\"2021-09-23T13:29:13+00:00\",\"dateModified\":\"2021-09-23T13:29:13+00:00\",\"author\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/#\/schema\/person\/4a40fe3fe17a08ddd1d7c113668e75f2\"},\"breadcrumb\":{\"@id\":\"https:\/\/ownwebservers.com\/kb\/database-troubleshooting-tips\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/ownwebservers.com\/kb\/database-troubleshooting-tips\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/ownwebservers.com\/kb\/database-troubleshooting-tips\/#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\/database-troubleshooting-tips\/\",\"url\":\"https:\/\/ownwebservers.com\/kb\/database-troubleshooting-tips\/\",\"name\":\"Database Troubleshooting Tips\"}}]},{\"@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\/2222","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=2222"}],"version-history":[{"count":1,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2222\/revisions"}],"predecessor-version":[{"id":2225,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/posts\/2222\/revisions\/2225"}],"wp:attachment":[{"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/media?parent=2222"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/categories?post=2222"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/ownwebservers.com\/kb\/wp-json\/wp\/v2\/tags?post=2222"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}