{"id":223,"date":"2017-08-23T23:10:15","date_gmt":"2017-08-23T23:10:15","guid":{"rendered":"http:\/\/www.mrmarkyoung.com\/oracle\/?p=223"},"modified":"2018-06-04T16:45:34","modified_gmt":"2018-06-04T06:45:34","slug":"command-line-connection-with-mysql","status":"publish","type":"post","link":"http:\/\/www.mrmarkyoung.com\/oracle\/2017\/08\/23\/command-line-connection-with-mysql\/","title":{"rendered":"Command Line Connection with MYSQL"},"content":{"rendered":"<p>If you are wanting to connect to a remote database using the command line with MySQL, you first need to download the MYSQL client available <a href=\"https:\/\/dev.mysql.com\/downloads\/shell\/\" target=\"_blank\">here<\/a><\/p>\n<p>Open a DOS shell and run the following:<\/p>\n<pre class=\"lang:default decode:true \" >mysqlsh \/sql -u aurora -p mypassword -h auroratest-1.cluster-xxxx.ap-southeast-2.rds.amazonaws.com AURORATEST<\/pre>\n<p>Then run your query<\/p>\n<pre class=\"lang:default decode:true \" >mysql-sql&gt; select count(*) from AURORA.PERSON_AWS;\r\n+----------+\r\n| count(*) |\r\n+----------+\r\n|    27975 |\r\n+----------+\r\n1 row in set (0.03 sec)<\/pre>\n","protected":false},"excerpt":{"rendered":"<p>If you are wanting to connect to a remote database using the command line with MySQL, you first need to download the MYSQL client available here Open a DOS shell and run the following: mysqlsh \/sql -u aurora -p mypassword -h auroratest-1.cluster-xxxx.ap-southeast-2.rds.amazonaws.com AURORATEST Then run your query mysql-sql&gt; select count(*) from AURORA.PERSON_AWS; +&#8212;&#8212;&#8212;-+ | count(*) &#8230; <a title=\"Command Line Connection with MYSQL\" class=\"read-more\" href=\"http:\/\/www.mrmarkyoung.com\/oracle\/2017\/08\/23\/command-line-connection-with-mysql\/\" aria-label=\"Read more about Command Line Connection with MYSQL\">Read more<\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[47],"tags":[59],"class_list":["post-223","post","type-post","status-publish","format-standard","hentry","category-mysql","tag-aurora"],"_links":{"self":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/223","targetHints":{"allow":["GET"]}}],"collection":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/comments?post=223"}],"version-history":[{"count":1,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/223\/revisions"}],"predecessor-version":[{"id":224,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/posts\/223\/revisions\/224"}],"wp:attachment":[{"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/media?parent=223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/categories?post=223"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/www.mrmarkyoung.com\/oracle\/wp-json\/wp\/v2\/tags?post=223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}