Command Line Connection with MYSQL

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> select count(*) from AURORA.PERSON_AWS;
+----------+
| count(*) |
+----------+
|    27975 |
+----------+
1 row in set (0.03 sec)

Leave a Comment

This site uses Akismet to reduce spam. Learn how your comment data is processed.