Re: Can connect to AWS MySQL with Workbench, but not Client

[Peter Brawley]

Quote

mysql -h AWS_endpoint -P 3306 -u admin -p;

But I get-
ERROR 1064 (42000): You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'mysql -h ▪▪▪▪▪▪▪▪▪▪▪▪▪▪▪▪▪▪.us-east-2.rds.amazonaws.com -P 3306 -u ' at line 1

That error message indicates that your connection attempt was sent to the MySQL server as if is were SQL.

A connection commend is not SQL, it's an operating system command. Issue it in a cmd.exe window.