Open the Cygwin Terminal and open the MySQL command line by giving the following command. Through this command, we want to open MySQL through the user ID root and try to connect with the MySQL server running at the localhost (127.0.0.1):

$ mysql -u root -p -h 127.0.0.1   
Enter password: 
Welcome to the MariaDB monitor.  Commands end with ; or g.
Your MySQL connection id is 12
Server version: 5.7.14-log MySQL Community Server (GPL)
Copyright (c) 2000, 2017, Oracle, MariaDB Corporation Ab and others.
Type 'help;' or 'h' for help. Type 'c' to clear the current input statement.  
MySQL [(none)]>                                                    

The preceding MySQL prompt that appears confirms that the userid and password have been entered correctly and that you are successfully connected to a running MySQL server. Now, we can go ahead and run SQL commands.