{"id":596,"date":"2021-02-04T16:26:44","date_gmt":"2021-02-04T10:56:44","guid":{"rendered":"https:\/\/selfimagination.in\/tips\/?p=596"},"modified":"2021-05-31T08:44:41","modified_gmt":"2021-05-31T03:14:41","slug":"mysql-installation","status":"publish","type":"post","link":"https:\/\/selfimagination.in\/tips\/mysql-installation\/","title":{"rendered":"MySQL Installation"},"content":{"rendered":"\n<p><strong>MySQL Installation<\/strong> \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0939\u092e\u0947\u0902 <strong>MySQL<\/strong> \u0938\u0947\u091f\u0905\u092a \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u0940, \u0909\u0938\u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0947\u0902 \u0915\u0941\u091b <strong>\u0938\u0949\u092b\u094d\u091f\u0935\u0947\u092f\u0930 \u0907\u0928\u0938\u094d\u091f\u0949\u0932 <\/strong>\u0915\u0930\u0928\u0947 \u0939\u094b\u0902\u0917\u0947<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"> <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 1<\/strong> : Check Bit (32\/64)<\/h2>\n\n\n\n<p>\u0915\u094b\u0908 \u092d\u0940 \u0938\u0949\u092b\u094d\u091f\u0935\u0947\u092f\u0930 \u0907\u0928\u0938\u094d\u091f\u0949\u0932 \u0915\u0930\u0928\u0947 \u0938\u0947 \u092a\u0939\u0932\u0947 \u0905\u092a\u0928\u0947 \u0911\u092a\u0930\u0947\u091f\u093f\u0902\u0917 \u0938\u093f\u0938\u094d\u091f\u092e \u0915\u0947 \u092c\u093f\u091f \u0915\u094b \u091c\u0930\u0942\u0930 \u091a\u0947\u0915 \u0915\u0930\u0947 \u0915\u0940 \u0935\u0939 64 Bit \u0939\u0948\u0902 \u092f\u093e 32 Bit, \u0915\u094d\u092f\u0941\u0915\u0940 \u091c\u094b \u0938\u0947\u091f\u0905\u092a \u0906\u092a \u0921\u093e\u0909\u0928\u0932\u094b\u0921 \u0915\u0930\u0947\u0902\u0917 \u0909\u0938\u092e\u0947 Bit&nbsp; \u0915\u0947 \u0939\u093f\u0938\u093e\u092c \u0938\u0947 Down&nbsp;load \u0915\u0930\u0928\u093e \u0939\u094b\u0924\u093e \u0939\u0948\u0902.<\/p>\n\n\n\n<p>\u0935\u093f\u0902\u0921\u094b\u091c \u0915\u093e \u092c\u093f\u091f \u0926\u0947\u0916\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0926\u094b \u0924\u0930\u0940\u0915\u0947 \u0939\u0948\u0902<\/p>\n\n\n\n<ol class=\"wp-block-list\"><li>\u0938\u094d\u091f\u093e\u0930\u094d\u091f -&gt; \u0938\u0947\u091f\u093f\u0902\u0917 -&gt; <strong>About<\/strong> \u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0915\u0947 .<\/li><li>\u0906\u092a \u0938\u0930\u094d\u091a \u092e\u0947\u0902 <strong>About<\/strong> \u091f\u093e\u0907\u092a \u0915\u0930\u0947 \u0914\u0930 <strong>About Your PC <\/strong>\u092a\u0930 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0915\u0947 \u092d\u0940 \u0906\u092a \u092f\u0939 \u0911\u092a\u094d\u0936\u0928 \u0913\u092a\u0928 \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902 <\/li><\/ol>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter size-large\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" width=\"485\" height=\"251\" src=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/02\/image.png?resize=485%2C251&#038;ssl=1\" alt=\"how to check window bit\" class=\"wp-image-615\" srcset=\"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/02\/image.png?w=485&amp;ssl=1 485w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/02\/image.png?resize=300%2C155&amp;ssl=1 300w, https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/02\/image.png?resize=465%2C241&amp;ssl=1 465w\" sizes=\"auto, (max-width: 485px) 100vw, 485px\" \/><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 2<\/strong> : Install WAMP<\/h2>\n\n\n\n<p>WAPM\u00a0 (\u091c\u092c \u0939\u092e WAMP\u00a0 \u0907\u0928\u0938\u094d\u091f\u0949\u0932 \u0915\u0930\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b MySQL \u0907\u0928\u0938\u094d\u091f\u0949\u0932 \u0939\u094b \u091c\u093e\u0924\u093e \u0939\u0948\u0902 (\u092f\u0939\u093e\u0901 WAMP\u00a0 \u092e\u0947\u0902 M \u092f\u093e\u0928\u093f MySQL \u0939\u0940 \u0939\u094b\u0924\u093e \u0939\u0948\u0902 !<br>\u0906\u092a \u0907\u0938 \u0932\u093f\u0902\u0915 \u0938\u0947 WAMP \u0915\u093e \u0938\u0947\u091f\u0905\u092a \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902<br><a href=\"http:\/\/www.wampserver.com\/en\/\" target=\"_blank\" rel=\"noopener\">http:\/\/www.wampserver.com\/en\/<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 3<\/strong> : Install SQLYog<\/h2>\n\n\n\n<p>2. SQLYog, (\u092f\u0939 \u090f\u0915 \u091f\u0942\u0932\u00a0 \u0939\u0948\u0902 \u091c\u094b SQL \u0915\u0940 Command \u0915\u094b \u091a\u0932\u093e\u0928\u0947 \u092e\u0947\u0902 \u0939\u092e\u093e\u0930\u0940 \u092e\u0926\u0926 \u0915\u0930\u0924\u093e \u0939\u0948\u0902 )<br>\u0906\u092a \u0907\u0938 \u0932\u093f\u0902\u0915 \u0938\u0947 SQLYog\u00a0\u00a0\u0915\u093e \u0938\u0947\u091f\u0905\u092a \u0915\u0930 \u0938\u0915\u0924\u0947 \u0939\u0948\u0902<br><a href=\"https:\/\/www.webyog.com\/\" target=\"_blank\" rel=\"noopener\">https:\/\/www.webyog.com\/<\/a><\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 4<\/strong> : Restart WAMP<\/h2>\n\n\n\n<p>\u0907\u0902\u0938\u094d\u091f\u093e\u0932\u0947\u0936\u0928 \u0939\u094b\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 WAMP \u0915\u094b \u0930\u0940\u0938\u094d\u091f\u093e\u0930\u094d\u091f \u0915\u0930\u0947 !<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><a href=\"https:\/\/www.blogger.com\/blog\/post\/edit\/1531462899967919649\/4361643536026259693#\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/1.bp.blogspot.com\/-IxffwkRTlyE\/XkuBlbj4NpI\/AAAAAAAAAAM\/CrmXDXta5TAFrgYcEKuXO-C2RF7-_XywACLcBGAsYHQ\/s1600\/Restart.png?resize=280%2C347&#038;ssl=1\" alt=\"MySQL Installation\" width=\"280\" height=\"347\"\/><\/a><\/figure><\/div>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 5<\/strong> : Open SQLYog<\/h2>\n\n\n\n<p>\u0905\u092c SQLYog \u0938\u094d\u091f\u093e\u0930\u094d\u091f \u0915\u0930\u0947 , \u0913\u092a\u0928 \u0915\u0930\u0928\u0947 \u0915\u0947 \u092c\u093e\u0926 \u092f\u0939 \u0938\u094d\u0915\u094d\u0930\u0940\u0928 \u0913\u092a\u0928 \u0939\u094b\u0917\u0940, \u0907\u0938\u092e\u0947\u0902 \u0906\u092a\u0915\u094b \u0915\u0928\u0947\u0915\u094d\u0936\u0928 \u0938\u0947\u091f\u093f\u0902\u0917 \u0926\u093f\u0916\u093e\u0908 \u0926\u0947\u0917\u0940 .  <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"> <\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><a href=\"https:\/\/www.blogger.com\/blog\/post\/edit\/1531462899967919649\/4361643536026259693#\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/1.bp.blogspot.com\/-fGPY2Lu4inU\/XkuCbVVN91I\/AAAAAAAAAAU\/yopicKhZQDEYT6GGD6uOD323eUBRQB2rQCLcBGAsYHQ\/s320\/Connecttomysql.png?resize=410%2C330&#038;ssl=1\" alt=\"MySQL Installation (Connection)\" width=\"410\" height=\"330\"\/><\/a><\/figure><\/div>\n\n\n\n<p>\u0907\u0938 \u0938\u094d\u0915\u094d\u0930\u0940\u0928 \u0938\u0947 \u0915\u0928\u0947\u0915\u094d\u091f \u0915\u0930\u0915\u0947 \u0906\u092a \u0915\u0947 \u0938\u093e\u092e\u0928\u0947 \u090f\u0915 \u0915\u092e\u093e\u0902\u0921 \u0935\u093f\u0902\u0921\u094b \u0913\u092a\u0928 \u0939\u094b\u0917\u0940 \u091c\u093f\u0938\u092e\u0947 \u0917\u094d\u0930\u093e\u092b\u093c\u093f\u0915\u094d\u0938 \u092d\u0940 \u0939\u094b\u0902\u0917\u0947<\/p>\n\n\n\n<div class=\"wp-block-image\"><figure class=\"aligncenter is-resized\"><a href=\"https:\/\/www.blogger.com\/blog\/post\/edit\/1531462899967919649\/4361643536026259693#\" target=\"_blank\" rel=\"noopener\"><img data-recalc-dims=\"1\" loading=\"lazy\" decoding=\"async\" src=\"https:\/\/i0.wp.com\/1.bp.blogspot.com\/-Ln4Mwc7WvKk\/XkuDZl86uPI\/AAAAAAAAAAg\/isy8c8xoTqUEoyNlkA_VNmyoySu4bsDSACLcBGAsYHQ\/s320\/SQLYog.png?resize=416%2C267&#038;ssl=1\" alt=\"MySQL Installation (SQLYog)\" width=\"416\" height=\"267\"\/><\/a><\/figure><\/div>\n\n\n\n<p>MySQL Installation \u0915\u093e \u0915\u093e\u0930\u094d\u092f \u092a\u0942\u0930\u093e \u0939\u0941\u0906 \u0906\u092a \u0906\u0917\u0947 Query&nbsp;\u0915\u0948\u0938\u0947 execute&nbsp; \u0915\u0930\u0947\u0902\u0917\u0947 \u0935\u0939 \u0938\u0940\u0916\u0947\u0902\u0917\u0947<\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"> <\/p>\n\n\n\n<h2 class=\"wp-block-heading\"><strong>Step 5<\/strong> : Execute Queries<\/h2>\n\n\n\n<p>\u0907\u0938\u092e\u0947\u0902 Query&nbsp; \u0935\u093e\u0932\u0947 Tab&nbsp;&nbsp;\u092e\u0947\u0902 \u0939\u092e\u0915\u094b SQL Command Execute \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u0940<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">MySQL Installation Completed<\/h3>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u092f\u0939\u093e\u0901 \u092a\u0930 \u0907\u0902\u0938\u094d\u091f\u093e\u0932\u0947\u0936\u0928 \u0915\u092e\u094d\u092a\u0932\u0940\u091f \u0939\u0941\u090f \u092f\u0926\u093f \u0906\u092a \u0911\u0928\u0932\u093e\u0907\u0928 SQL \u0938\u0940\u0916\u0928\u093e \u091a\u093e\u0939\u0924\u0947 \u0939\u0948\u0902 \u0924\u094b \u0939\u092e\u0947\u0902 \u0915\u092e\u0947\u0902\u091f \u0915\u0930\u0947, <a href=\"https:\/\/play.google.com\/store\/apps\/details?id=com.sl.SQL_Logic\" target=\"_blank\" rel=\"noopener\">\u0939\u092e\u0928\u0947 \u090f\u0915 \u090f\u0902\u0921\u094d\u0930\u093e\u0907\u0921 \u090f\u092a\u094d\u092a \u092d\u0940 \u092c\u0928\u093e\u0908 \u0939\u0948\u0902 \u0909\u0938\u0947 \u0921\u093e\u0909\u0928\u0932\u094b\u0921 \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u092f\u0939\u093e\u0901 \u0915\u094d\u0932\u093f\u0915 \u0915\u0930\u0947  <\/a><\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\"><a href=\"https:\/\/selfimagination.in\/tips\/category\/mysql\/\">MYSQL Code \u0915\u0947 \u092c\u093e\u0930\u0947 \u092e\u0947\u0902 \u091c\u093e\u0928\u0915\u093e\u0930\u0940 \u0915\u0947 \u0932\u093f\u090f \u0926\u0947\u0916\u0947<\/a> <\/p>\n\n\n\n<p class=\"wp-block-zozuk-wphindi\">\u0906\u0930\u094d\u091f\u093f\u0915\u0932 \u0906\u092a\u0915\u094b \u0915\u0948\u0938\u093e \u0932\u0917\u093e \u0939\u092e\u0947\u0902 \u091c\u0930\u0942\u0930 \u092c\u0924\u093e\u092f\u0947, \u0927\u0928\u094d\u092f\u0935\u093e\u0926 \u0964<\/p>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>MySQL Installation \u0915\u0930\u0928\u0947 \u0915\u0947 \u0932\u093f\u090f \u0938\u092c\u0938\u0947 \u092a\u0939\u0932\u0947 \u0939\u092e\u0947\u0902 MySQL \u0938\u0947\u091f\u0905\u092a \u0915\u0930\u0928\u093e \u0939\u094b\u0917\u0940, \u0909\u0938\u0915\u0947 \u0932\u093f\u090f \u0939\u092e\u0947\u0902 \u0915\u0941\u091b \u0938\u0949\u092b\u094d\u091f\u0935\u0947\u092f\u0930 \u0907\u0928\u0938\u094d\u091f\u0949\u0932 \u0915\u0930\u0928\u0947 \u0939\u094b\u0902\u0917\u0947 Step 1 : Check Bit (32\/64) \u0915\u094b\u0908 \u092d\u0940 \u0938\u0949\u092b\u094d\u091f\u0935\u0947\u092f\u0930 \u0907\u0928\u0938\u094d\u091f\u0949\u0932 \u0915\u0930\u0928\u0947 \u0938\u0947 \u092a\u0939\u0932\u0947 \u0905\u092a\u0928\u0947 \u0911\u092a\u0930\u0947\u091f\u093f\u0902\u0917 \u0938\u093f\u0938\u094d\u091f\u092e \u0915\u0947 \u092c\u093f\u091f \u0915\u094b \u091c\u0930\u0942\u0930 \u091a\u0947\u0915 \u0915\u0930\u0947 \u0915\u0940 \u0935\u0939 64 Bit \u0939\u0948\u0902 \u092f\u093e 32 Bit, \u0915\u094d\u092f\u0941\u0915\u0940 \u091c\u094b \u0938\u0947\u091f\u0905\u092a \u0906\u092a \u0921\u093e\u0909\u0928\u0932\u094b\u0921 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":621,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[5],"tags":[],"class_list":["post-596","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-mysql"],"jetpack_sharing_enabled":true,"jetpack_featured_media_url":"https:\/\/i0.wp.com\/selfimagination.in\/tips\/wp-content\/uploads\/2021\/02\/MySQL-installation-imagination.png?fit=1200%2C628&ssl=1","_links":{"self":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/596","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=596"}],"version-history":[{"count":14,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/596\/revisions"}],"predecessor-version":[{"id":1191,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/posts\/596\/revisions\/1191"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media\/621"}],"wp:attachment":[{"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/media?parent=596"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/categories?post=596"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/selfimagination.in\/tips\/wp-json\/wp\/v2\/tags?post=596"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}