{"id":9978,"date":"2023-04-01T07:08:54","date_gmt":"2023-04-01T07:08:54","guid":{"rendered":"https:\/\/www.scmgalaxy.com\/tutorials\/?p=9978"},"modified":"2023-04-01T07:08:55","modified_gmt":"2023-04-01T07:08:55","slug":"sqlstatehy000-1045-access-denied-for-user","status":"publish","type":"post","link":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/","title":{"rendered":"SQLSTATE[HY000] [1045] Access denied for user"},"content":{"rendered":"\n<h2 class=\"wp-block-heading\">Error<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;previous exception] &#91;object] (PDOException(code: 1045): SQLSTATE&#91;HY000] &#91;1045] Access denied for user 'root'@'localhost' (using\r\n password: YES) at \/opt\/lampp\/htdocs\/wizbrand\/wz-account-admin-ms\/vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connectors\/Co\r\nnnector.php:70)\r\n&#91;stacktrace]\r\n\r\n\r\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>  Do you really wish to run this command? (yes\/no) &#91;no]\r\n\u276f yes\r\n\r\n\r\n   Illuminate\\Database\\QueryException\r\n\r\n  SQLSTATE&#91;HY000] &#91;1045] Access denied for user 'root'@'localhost' (using password: YES) (SQL: select * from information_schema.tables where table_schema = wz-account-admin-ms and table_name = migrations and table_type = 'BASE TABLE')\r\n\r\n  at vendor\/laravel\/framework\/src\/Illuminate\/Database\/Connection.php:760\r\n    756\u2595         \/\/ If an exception occurs when attempting to run a query, we'll format the error\r\n    757\u2595         \/\/ message to include the bindings with SQL, which will make this exception a\r\n    758\u2595         \/\/ lot more helpful to the developer instead of just the database's errors.\r\n    759\u2595         catch (Exception $e) {\r\n  \u279c 760\u2595             throw new QueryException(\r\n    761\u2595                 $query, $this->prepareBindings($bindings), $e\r\n    762\u2595             );\r\n    763\u2595         }\r\n    764\u2595     }\r\n\r\n      +36 vendor frames\r\n  37  artisan:35\r\n      Illuminate\\Foundation\\Console\\Kernel::handle()\r\n<\/code><\/pre>\n\n\n\n<pre class=\"wp-block-code\"><code>&#91;2023-04-01 06:45:36] production.ERROR: SQLSTATE&#91;HY000] &#91;1045] Access denied for user 'root'@'localhost' (using password: YES) (\r\nSQL: select * from information_schema.tables where table_schema = wz-account-admin-ms and table_name = migrations and table_type\r\n = 'BASE TABLE') {\"exception\":\"&#91;object] (Illuminate\\\\Database\\\\QueryException(code: 1045): SQLSTATE&#91;HY000] &#91;1045] Access denied\r\nfor user 'root'@'localhost' (using password: YES) (SQL: select * from information_schema.tables where table_schema = wz-account-\r\nadmin-ms and table_name = migrations and table_type = 'BASE TABLE') at \/opt\/lampp\/htdocs\/wizbrand\/wz-account-admin-ms\/vendor\/lar\r\navel\/framework\/src\/Illuminate\/Database\/Connection.php:760)\r\n&#91;stacktrace]<\/code><\/pre>\n\n\n\n<h2 class=\"wp-block-heading\">Solution<\/h2>\n\n\n\n<pre class=\"wp-block-code\"><code>- Try delete next file: bootstap\/cache\/config.php\r\n- cache and config clear \r\n- Make sure that user password if you are having \"#\" then put it in single quote.<\/code><\/pre>\n\n\n\n<figure class=\"wp-block-image size-full\"><img loading=\"lazy\" decoding=\"async\" width=\"654\" height=\"319\" src=\"https:\/\/www.scmgalaxy.com\/tutorials\/wp-content\/uploads\/2023\/04\/image.png\" alt=\"\" class=\"wp-image-9979\" srcset=\"https:\/\/www.scmgalaxy.com\/tutorials\/wp-content\/uploads\/2023\/04\/image.png 654w, https:\/\/www.scmgalaxy.com\/tutorials\/wp-content\/uploads\/2023\/04\/image-300x146.png 300w\" sizes=\"auto, (max-width: 654px) 100vw, 654px\" \/><\/figure>\n","protected":false},"excerpt":{"rendered":"<p>Error Solution<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_joinchat":[],"footnotes":""},"categories":[1],"tags":[],"class_list":["post-9978","post","type-post","status-publish","format-standard","hentry","category-uncategorized"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.4 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>SQLSTATE[HY000] [1045] Access denied for user - scmGalaxy<\/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.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"SQLSTATE[HY000] [1045] Access denied for user - scmGalaxy\" \/>\n<meta property=\"og:description\" content=\"Error Solution\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/\" \/>\n<meta property=\"og:site_name\" content=\"scmGalaxy\" \/>\n<meta property=\"article:published_time\" content=\"2023-04-01T07:08:54+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2023-04-01T07:08:55+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.scmgalaxy.com\/tutorials\/wp-content\/uploads\/2023\/04\/image.png\" \/>\n<meta name=\"author\" content=\"rajeshkumar\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"rajeshkumar\" \/>\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\":\"Article\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/\"},\"author\":{\"name\":\"rajeshkumar\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/a40e0dd38feee7c2779460a804d49361\"},\"headline\":\"SQLSTATE[HY000] [1045] Access denied for user\",\"datePublished\":\"2023-04-01T07:08:54+00:00\",\"dateModified\":\"2023-04-01T07:08:55+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/\"},\"wordCount\":8,\"commentCount\":3,\"image\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/image.png\",\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/\",\"url\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/\",\"name\":\"SQLSTATE[HY000] [1045] Access denied for user - scmGalaxy\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/image.png\",\"datePublished\":\"2023-04-01T07:08:54+00:00\",\"dateModified\":\"2023-04-01T07:08:55+00:00\",\"author\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/a40e0dd38feee7c2779460a804d49361\"},\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/#primaryimage\",\"url\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/image.png\",\"contentUrl\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/wp-content\\\/uploads\\\/2023\\\/04\\\/image.png\",\"width\":654,\"height\":319},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/sqlstatehy000-1045-access-denied-for-user\\\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"SQLSTATE[HY000] [1045] Access denied for user\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#website\",\"url\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/\",\"name\":\"scmGalaxy\",\"description\":\"A Platform for Software Engineers\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/#\\\/schema\\\/person\\\/a40e0dd38feee7c2779460a804d49361\",\"name\":\"rajeshkumar\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g\",\"caption\":\"rajeshkumar\"},\"url\":\"https:\\\/\\\/www.scmgalaxy.com\\\/tutorials\\\/author\\\/rajeshkumar\\\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"SQLSTATE[HY000] [1045] Access denied for user - scmGalaxy","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.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/","og_locale":"en_US","og_type":"article","og_title":"SQLSTATE[HY000] [1045] Access denied for user - scmGalaxy","og_description":"Error Solution","og_url":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/","og_site_name":"scmGalaxy","article_published_time":"2023-04-01T07:08:54+00:00","article_modified_time":"2023-04-01T07:08:55+00:00","og_image":[{"url":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-content\/uploads\/2023\/04\/image.png","type":"","width":"","height":""}],"author":"rajeshkumar","twitter_card":"summary_large_image","twitter_misc":{"Written by":"rajeshkumar","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/#article","isPartOf":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/"},"author":{"name":"rajeshkumar","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#\/schema\/person\/a40e0dd38feee7c2779460a804d49361"},"headline":"SQLSTATE[HY000] [1045] Access denied for user","datePublished":"2023-04-01T07:08:54+00:00","dateModified":"2023-04-01T07:08:55+00:00","mainEntityOfPage":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/"},"wordCount":8,"commentCount":3,"image":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/#primaryimage"},"thumbnailUrl":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-content\/uploads\/2023\/04\/image.png","inLanguage":"en-US","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/","url":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/","name":"SQLSTATE[HY000] [1045] Access denied for user - scmGalaxy","isPartOf":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/#primaryimage"},"image":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/#primaryimage"},"thumbnailUrl":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-content\/uploads\/2023\/04\/image.png","datePublished":"2023-04-01T07:08:54+00:00","dateModified":"2023-04-01T07:08:55+00:00","author":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#\/schema\/person\/a40e0dd38feee7c2779460a804d49361"},"breadcrumb":{"@id":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/#primaryimage","url":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-content\/uploads\/2023\/04\/image.png","contentUrl":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-content\/uploads\/2023\/04\/image.png","width":654,"height":319},{"@type":"BreadcrumbList","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/sqlstatehy000-1045-access-denied-for-user\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.scmgalaxy.com\/tutorials\/"},{"@type":"ListItem","position":2,"name":"SQLSTATE[HY000] [1045] Access denied for user"}]},{"@type":"WebSite","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#website","url":"https:\/\/www.scmgalaxy.com\/tutorials\/","name":"scmGalaxy","description":"A Platform for Software Engineers","potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.scmgalaxy.com\/tutorials\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Person","@id":"https:\/\/www.scmgalaxy.com\/tutorials\/#\/schema\/person\/a40e0dd38feee7c2779460a804d49361","name":"rajeshkumar","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/82337e1fc8642c7f36795aa0775af055a4f38882994004b593efd31758d4434e?s=96&d=mm&r=g","caption":"rajeshkumar"},"url":"https:\/\/www.scmgalaxy.com\/tutorials\/author\/rajeshkumar\/"}]}},"_links":{"self":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts\/9978","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/comments?post=9978"}],"version-history":[{"count":1,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts\/9978\/revisions"}],"predecessor-version":[{"id":9980,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/posts\/9978\/revisions\/9980"}],"wp:attachment":[{"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/media?parent=9978"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/categories?post=9978"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.scmgalaxy.com\/tutorials\/wp-json\/wp\/v2\/tags?post=9978"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}