{"id":9929,"date":"2023-01-03T07:00:00","date_gmt":"2023-01-03T01:30:00","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=9929"},"modified":"2023-01-02T16:34:33","modified_gmt":"2023-01-02T11:04:33","slug":"remote-mysql-access-denied-for-user","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/remote-mysql-access-denied-for-user\/","title":{"rendered":"Remote MySQL (Solution for Access Denied For User)"},"content":{"rendered":"\n<p>access denied for user, access denied,php error access denied, error access denied for user mysql phpmyadmin, access denied for user root in mysql<\/p>\n\n\n\n<div class=\"wp-block-rank-math-toc-block\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#what-is-strong-hy-000-1045-strong-error\">What is HY000\/1045 Error<\/a><\/li><li><a href=\"#why-access-denied-error-show\">Why Access Denied Error Show<\/a><\/li><li><a href=\"#how-to-solve-access-denied-error\">How to Solve Access Denied Error<\/a><\/li><li><a href=\"#how-to-give-permission-permanently\">How to Give Permission Permanently <\/a><\/li><li><a href=\"#strong-\u0939\u092e\u093e\u0930\u0947-\u0905\u0928\u094d\u092f-\u0906\u0930\u094d\u091f\u093f\u0915\u0932-strong\">\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/a><\/li><\/ul><\/nav><\/div>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-is-strong-hy-000-1045-strong-error\">What is <strong>HY000\/1045<\/strong> Error<\/h2>\n\n\n\n<p><strong>Solution : Warning: mysqli_connect(): (HY000\/1045): Access Denied for User User@IP (using password: YES) in Path on line Line No.<\/strong><\/p>\n\n\n\n<p>\u091c\u092c \u092d\u0940 \u0906\u092a \u0915\u094b\u0908 Application \u0915\u0947 Front End \u0938\u0947 Web Server \u0915\u094b Connect \u0915\u0930\u0928\u0947 \u0915\u0940 \u0915\u094b\u0936\u0940\u0936 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u092c \u0906\u092a\u0915\u094b <strong>Access Denied <\/strong> for User \u0935\u093e\u0932\u0940 Error \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0924\u0940 \u0939\u0948 \u0964 <\/p>\n\n\n\n<figure class=\"wp-block-image size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"640\" height=\"131\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image.png?resize=640%2C131&#038;ssl=1\" alt=\"Access Denied For User\" class=\"wp-image-9930\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image.png?resize=1024%2C209&amp;ssl=1 1024w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image.png?resize=300%2C61&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image.png?resize=768%2C157&amp;ssl=1 768w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image.png?resize=150%2C31&amp;ssl=1 150w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image.png?w=1280&amp;ssl=1 1280w\" sizes=\"auto, (max-width: 640px) 100vw, 640px\" \/><\/figure>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"why-access-denied-error-show\">Why Access Denied Error Show<\/h2>\n\n\n\n<p>Web Server \u0915\u094b Secure \u0930\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0914\u0930 Unwanted Attack \u0938\u0947 \u092c\u091a\u093e\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f Hosting Server Provider \u0926\u094d\u0935\u093e\u0930\u093e \u0915\u093f\u0938\u0940 \u092d\u0940 \u0905\u0928\u094d\u092f Server \u092f\u093e local machine \u0938\u0947 \u0906\u092a\u0928\u0947 \u0935\u093e\u0932\u0940 \u0938\u092d\u0940 Request \u0915\u094b Block \u0915\u0930 \u0926\u093f\u092f\u093e \u091c\u093e\u0924\u093e \u0939\u0948\u0902 \u0964 \u092f\u0926\u093f \u0906\u092a \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0906\u092a\u0915\u0947 Computer \u0915\u094b Block \u0928\u0939\u0940\u0902 \u0915\u093f\u092f\u093e \u091c\u093e\u090f \u0924\u092c \u0906\u092a\u0915\u094b Remote MySQL \u092e\u0947 \u091c\u093e \u0915\u0930 \u0905\u092a\u0928\u0947 IP \u0915\u094b Remote Connection \u0915\u0940 Permission \u0926\u0947\u0928\u093e \u0939\u094b\u0924\u0940 \u0939\u0948\u0902 \u0964   <\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-solve-access-denied-error\">How to Solve Access Denied Error<\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>1. \u091c\u094b \u0906\u092a\u0915\u094b Error Message \u0906 \u0930\u0939\u093e \u0939\u0948\u0902 \u0909\u0938\u092e\u0947 \u0915\u094b IP \u0926\u093f\u0916\u093e\u092f\u093e \u091c\u093e \u0930\u0939\u093e \u0939\u0948\u0902 \u0909\u0938\u0915\u0947 Copy \u0915\u0930\u0947 \u0964<\/li>\n\n\n\n<li>2. Hosting Server (cPanel) Login \u0915\u0930\u0947 (Web Server)<\/li>\n\n\n\n<li>3. \u0907\u0938\u0915\u0947 \u092c\u093e\u0926 Database Option \u092e\u0947 Remote MySQL Option \u0915\u094b Open \u0915\u0930\u0947 \u0964<\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"242\" height=\"127\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-1.png?resize=242%2C127&#038;ssl=1\" alt=\"Remote MySQL\" class=\"wp-image-9946\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-1.png?w=242&amp;ssl=1 242w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-1.png?resize=220%2C115&amp;ssl=1 220w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-1.png?resize=140%2C73&amp;ssl=1 140w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-1.png?resize=60%2C31&amp;ssl=1 60w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-1.png?resize=150%2C79&amp;ssl=1 150w\" sizes=\"auto, (max-width: 242px) 100vw, 242px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>4. Host \u092e\u0947 \u091c\u094b IP \u0906\u092a\u0928\u0947 copy \u0915\u093f\u092f\u093e \u0925\u093e \u0909\u0938\u0947 Paste \u0915\u0930\u0947 <\/li>\n<\/ul>\n\n\n<div class=\"wp-block-image\">\n<figure class=\"aligncenter size-full\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"562\" height=\"216\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-2.png?resize=562%2C216&#038;ssl=1\" alt=\"Add Access Host\" class=\"wp-image-9949\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-2.png?w=562&amp;ssl=1 562w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-2.png?resize=300%2C115&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/image-2.png?resize=150%2C58&amp;ssl=1 150w\" sizes=\"auto, (max-width: 562px) 100vw, 562px\" \/><\/figure>\n<\/div>\n\n\n<ul class=\"wp-block-list\">\n<li>5. \u0905\u0902\u0924 \u092e\u0947 Add Host Button \u092a\u0930 Click \u0915\u0930\u0947 \u0964 <\/li>\n\n\n\n<li>6. \u0907\u0924\u0928\u093e \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u091c\u092c \u0906\u092a \u092b\u093f\u0930 \u0938\u0947 Check \u0915\u0930\u0947\u0902\u0917\u0947 \u0924\u094b Error Remove \u0939\u094b \u091a\u0941\u0915\u0940 \u0939\u094b\u0917\u0940 \u0964 <\/li>\n\n\n\n<li>7. \u091c\u092c \u0906\u092a\u0915\u0940 Local Machine Restart \u0939\u094b\u0917\u0940 \u0924\u092c \u092f\u0939 IP Change \u0939\u094b \u091c\u093e\u090f\u0917\u093e \u0915\u094d\u092f\u0941\u0915\u0940 \u0939\u092e\u0947 Dynamic IP Provide \u0915\u093f\u090f \u091c\u093e\u0924\u0947 \u0939\u0948\u0902 \u0964 <\/li>\n<\/ul>\n\n\n\n<p><a href=\"https:\/\/youtu.be\/2_gbEFjmbKw\" target=\"_blank\" rel=\"noopener\">Related Video : Solved : Remote Access Denied for User In MySQL<\/a><\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"how-to-give-permission-permanently\">How to Give Permission Permanently <\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li>\u092f\u0926\u093f \u0906\u092a \u092c\u093e\u0930 \u092c\u093e\u0930 Remote MySQL \u092e\u0947 IP \u0928\u0939\u0940\u0902 \u092c\u0926\u0932\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0906\u092a \u0939\u094b\u0938\u094d\u091f \u092e\u0947 Wildcard \u0915\u093e \u0909\u092a\u092f\u094b\u0917 \u092d\u0940 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964 \u092f\u093e \u0915\u0947\u0935\u0932 % \u0939\u0940 \u0926\u0947 \u0926\u0947\u0902\u0917\u0947 \u0924\u094b Universal Permission Grant \u0939\u094b \u091c\u093e\u090f\u0917\u0940\u0964 <\/li>\n\n\n\n<li>\u092a\u0930\u0902\u0924\u0941 \u0906\u092a\u0915\u094b \u0907\u0938 \u0924\u0930\u0939 \u0938\u0947 permission \u0928\u0939\u0940\u0902 \u0926\u0947\u0928\u093e \u091a\u093e\u0939\u093f\u090f \u0910\u0938\u093e \u0915\u0930\u0928\u0947 \u0938\u0947 \u0906\u092a\u0915\u093e Server Safe \u0928\u0939\u0940\u0902 \u0930\u0939\u0947\u0917\u093e \u0964 <\/li>\n<\/ul>\n\n\n\n<p><\/p>\n\n\n\n<p>\u0906\u0936\u093e \u0939\u0948\u0902 \u092e\u0941\u091d\u0947 \u0915\u0940 \u0906\u092a\u0915\u094b <strong>Remote MySQL<\/strong> \u092c\u0939\u0941\u0924 \u0905\u091a\u094d\u091b\u0947 \u0938\u0947 \u0938\u092e\u091d \u092e\u0947 \u0906 \u0917\u092f\u093e \u0939\u094b\u0917\u093e, \u092f\u0926\u093f \u092b\u093f\u0930 \u092d\u0940 \u0906\u092a\u0915\u0947 \u0915\u094b\u0908 Doubts \u0939\u0948\u0902 \u0924\u094b \u0906\u092a \u092e\u0941\u091d\u0947 Comment \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 \u0964<\/p>\n\n\n\n<p>\u092f\u0939 Article \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u092c\u0924\u093e\u0928\u093e \u0928 \u092d\u0942\u0932\u0947 , \u0905\u092a\u0928\u093e \u0915\u0940\u092e\u0924\u0940 \u0938\u092e\u092f \u0926\u0947\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0927\u0928\u094d\u092f\u0935\u093e\u0926 \u0964<\/p>\n\n\n\n<hr class=\"wp-block-separator has-alpha-channel-opacity\"\/>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"strong-\u0939\u092e\u093e\u0930\u0947-\u0905\u0928\u094d\u092f-\u0906\u0930\u094d\u091f\u093f\u0915\u0932-strong\"><strong>\u0939\u092e\u093e\u0930\u0947 \u0905\u0928\u094d\u092f \u0906\u0930\u094d\u091f\u093f\u0915\u0932<\/strong><\/h2>\n\n\n\n<ul class=\"wp-block-list\">\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-function\/\">MySQL Function<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-stored-procedure\/\">MySQL Stored Procedure<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/get-post-method\/\">PHP Get \/Post Method \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-math-function\/\">PHP Math Function \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/learn-cpp-from-c\/\">C \u0938\u0947 C ++ \u0938\u0940\u0916\u0947 \u0938\u0930\u0932 \u0936\u092c\u094d\u0926\u094b\u0902 \u092e\u0947\u0902<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/php-variables\/\">PHP Variable \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0947<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/arduino-control-structure\/\">Arduino Control Structure<\/a>&nbsp;<\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-union\/\">Union in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/c-pointer\/\">Declaration of Pointer in C<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/search-jquery\/\">jQuery Search Filter<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/mysql-table-create-alter-drop\/\">MySQL Create Table | Alter Table | Drop Table<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/api-using-node-react-express-mysql\/\">API Using NODE REACT EXPRESS MYSQL SEQUELIZE (For Backend OR Server Side)<\/a><\/li>\n\n\n\n<li><a href=\"https:\/\/selfimagination.in\/tips\/cpanel\/\">CPANEL In Hindi<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>access denied for user, access denied,php error access denied, error access denied for user mysql phpmyadmin, access denied for user root in mysql What is HY000\/1045 Error Solution : Warning: mysqli_connect(): (HY000\/1045): Access Denied for User User@IP (using password: YES) in Path on line Line No. \u091c\u092c \u092d\u0940 \u0906\u092a \u0915\u094b\u0908 Application \u0915\u0947 Front End \u0938\u0947 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":10003,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5,3,10],"tags":[],"class_list":["post-9929","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql","category-php","category-solution"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2023\/01\/Remote-MySQL.jpg?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9929","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/comments?post=9929"}],"version-history":[{"count":70,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9929\/revisions"}],"predecessor-version":[{"id":10002,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/9929\/revisions\/10002"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/10003"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=9929"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=9929"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=9929"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}