{"id":19959,"date":"2022-11-08T06:54:05","date_gmt":"2022-11-08T01:24:05","guid":{"rendered":"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/"},"modified":"2022-11-08T06:54:05","modified_gmt":"2022-11-08T01:24:05","slug":"solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed","status":"publish","type":"post","link":"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/","title":{"rendered":"[Solved] I do not know how to use command prompt for mysql using [closed]"},"content":{"rendered":"<p> [ad_1]<br \/>\n<\/p>\n<div id=\"answer-32478707\" class=\"answer js-answer accepted-answer js-accepted-answer\" data-answerid=\"32478707\" data-parentid=\"32478561\" data-score=\"-2\" data-position-on-page=\"2\" data-highest-scored=\"0\" data-question-has-accepted-highest-score=\"0\" itemprop=\"suggestedAnswer\" itemscope itemtype=\"https:\/\/schema.org\/Answer\">\n<div class=\"post-layout\">\n<div class=\"votecell post-layout--left\"><\/div>\n<div class=\"answercell post-layout--right\">\n<div class=\"s-prose js-post-body\" itemprop=\"text\">\n<ol>\n<li>You have to create your service (which you can see by clicking right start menu bar and task manager). To create your service you have to open cmd as an adminstrator. Then write <code>cd where\/your\/ sql\/bin\/<\/code>. After that, write <code>mysqld -install<\/code> &#8211; you should see <code>service succesfully installed<\/code>.<\/li>\n<li>Go to services from task manager, find mysql, right click it and click start.<\/li>\n<li>Go to cmd, write <code>cd where\/your\/ sql\/bin\/<\/code>, and press <kbd>enter<\/kbd>.<\/li>\n<li>Write <code>mysql -u root<\/code> (if it is not protected with password, if so then add <code>-p<\/code>).<\/li>\n<\/ol>\n<p>Then you will be able to use SQL queries.<\/p>\n<p>Please see the Mysql Manual page <a rel=\"nofollow noopener\" target=\"_blank\" href=\"http:\/\/dev.mysql.com\/doc\/refman\/5.7\/en\/mysql.html\">The MySQL Command-Line Tool<\/a> for a reference.<\/p>\n<\/p><\/div>\n<div class=\"mt24\"><\/div>\n<\/div>\n<p>            <span class=\"d-none\" itemprop=\"commentCount\">1<\/span> <\/p><\/div>\n<\/div>\n<p>[ad_2]<\/p>\n<p>solved I do not know how to use command prompt for mysql using [closed] <\/p>\n","protected":false},"excerpt":{"rendered":"<p>[ad_1] You have to create your service (which you can see by clicking right start menu bar and task manager). To create your service you have to open cmd as an adminstrator. Then write cd where\/your\/ sql\/bin\/. After that, write mysqld -install &#8211; you should see service succesfully installed. Go to services from task manager, &#8230; <a title=\"[Solved] I do not know how to use command prompt for mysql using [closed]\" class=\"read-more\" href=\"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/\" aria-label=\"More on [Solved] I do not know how to use command prompt for mysql using [closed]\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[320],"tags":[776,340,341],"class_list":["post-19959","post","type-post","status-publish","format-standard","hentry","category-solved","tag-cmd","tag-mysql","tag-sql"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v26.5 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>[Solved] I do not know how to use command prompt for mysql using [closed] - JassWeb<\/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:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"[Solved] I do not know how to use command prompt for mysql using [closed] - JassWeb\" \/>\n<meta property=\"og:description\" content=\"[ad_1] You have to create your service (which you can see by clicking right start menu bar and task manager). To create your service you have to open cmd as an adminstrator. Then write cd where\/your\/ sql\/bin\/. After that, write mysqld -install &#8211; you should see service succesfully installed. Go to services from task manager, ... Read more\" \/>\n<meta property=\"og:url\" content=\"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/\" \/>\n<meta property=\"og:site_name\" content=\"JassWeb\" \/>\n<meta property=\"article:published_time\" content=\"2022-11-08T01:24:05+00:00\" \/>\n<meta name=\"author\" content=\"Kirat\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"Kirat\" \/>\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:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/\"},\"author\":{\"name\":\"Kirat\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\"},\"headline\":\"[Solved] I do not know how to use command prompt for mysql using [closed]\",\"datePublished\":\"2022-11-08T01:24:05+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/\"},\"wordCount\":125,\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"keywords\":[\"cmd\",\"mysql\",\"sql\"],\"articleSection\":[\"Solved\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/\",\"url\":\"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/\",\"name\":\"[Solved] I do not know how to use command prompt for mysql using [closed] - JassWeb\",\"isPartOf\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#website\"},\"datePublished\":\"2022-11-08T01:24:05+00:00\",\"breadcrumb\":{\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/jassweb.com\/solved\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"[Solved] I do not know how to use command prompt for mysql using [closed]\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/jassweb.com\/solved\/#website\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"name\":\"JassWeb\",\"description\":\"Build High-quality Websites\",\"publisher\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/jassweb.com\/solved\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/jassweb.com\/solved\/#organization\",\"name\":\"Jass Web\",\"url\":\"https:\/\/jassweb.com\/solved\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"contentUrl\":\"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png\",\"width\":693,\"height\":132,\"caption\":\"Jass Web\"},\"image\":{\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31\",\"name\":\"Kirat\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"contentUrl\":\"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750\",\"caption\":\"Kirat\"},\"sameAs\":[\"http:\/\/jassweb.com\"],\"url\":\"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"[Solved] I do not know how to use command prompt for mysql using [closed] - JassWeb","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:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/","og_locale":"en_US","og_type":"article","og_title":"[Solved] I do not know how to use command prompt for mysql using [closed] - JassWeb","og_description":"[ad_1] You have to create your service (which you can see by clicking right start menu bar and task manager). To create your service you have to open cmd as an adminstrator. Then write cd where\/your\/ sql\/bin\/. After that, write mysqld -install &#8211; you should see service succesfully installed. Go to services from task manager, ... Read more","og_url":"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/","og_site_name":"JassWeb","article_published_time":"2022-11-08T01:24:05+00:00","author":"Kirat","twitter_card":"summary_large_image","twitter_misc":{"Written by":"Kirat","Est. reading time":"1 minute"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/#article","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/"},"author":{"name":"Kirat","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31"},"headline":"[Solved] I do not know how to use command prompt for mysql using [closed]","datePublished":"2022-11-08T01:24:05+00:00","mainEntityOfPage":{"@id":"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/"},"wordCount":125,"publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"keywords":["cmd","mysql","sql"],"articleSection":["Solved"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/","url":"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/","name":"[Solved] I do not know how to use command prompt for mysql using [closed] - JassWeb","isPartOf":{"@id":"https:\/\/jassweb.com\/solved\/#website"},"datePublished":"2022-11-08T01:24:05+00:00","breadcrumb":{"@id":"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/jassweb.com\/solved\/solved-i-do-not-know-how-to-use-command-prompt-for-mysql-using-closed\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/jassweb.com\/solved\/"},{"@type":"ListItem","position":2,"name":"[Solved] I do not know how to use command prompt for mysql using [closed]"}]},{"@type":"WebSite","@id":"https:\/\/jassweb.com\/solved\/#website","url":"https:\/\/jassweb.com\/solved\/","name":"JassWeb","description":"Build High-quality Websites","publisher":{"@id":"https:\/\/jassweb.com\/solved\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/jassweb.com\/solved\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/jassweb.com\/solved\/#organization","name":"Jass Web","url":"https:\/\/jassweb.com\/solved\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/","url":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","contentUrl":"https:\/\/jassweb.com\/wp-content\/uploads\/2021\/02\/jass-website-logo-1.png","width":693,"height":132,"caption":"Jass Web"},"image":{"@id":"https:\/\/jassweb.com\/solved\/#\/schema\/logo\/image\/"}},{"@type":"Person","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/65c9c7b7958150c0dc8371fa35dd7c31","name":"Kirat","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/jassweb.com\/solved\/#\/schema\/person\/image\/","url":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","contentUrl":"https:\/\/jassweb.com\/solved\/wp-content\/litespeed\/avatar\/1261af3c9451399fa1336d28b98ea3bb.jpg?ver=1775798750","caption":"Kirat"},"sameAs":["http:\/\/jassweb.com"],"url":"https:\/\/jassweb.com\/solved\/author\/jaspritsinghghumangmail-com\/"}]}},"_links":{"self":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/19959","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/comments?post=19959"}],"version-history":[{"count":0,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/posts\/19959\/revisions"}],"wp:attachment":[{"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/media?parent=19959"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/categories?post=19959"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/jassweb.com\/solved\/wp-json\/wp\/v2\/tags?post=19959"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}