Cannot log in as Drupal admin
Drupal 7 and 8 do not use a straight md5 password hash.  The hash includes a site specific "salt" string that is created with you set up the site.  This is in the settings.php file generally.

To use SQL to set a password, you will need to use the password-hash.sh file which is located in the core/scripts directory.

Run this from your web root directory like ./core/scripts/password-hash.sh` newpassword 

Use the string created as the value for your password in query with no Password function.

Re:Drush

You might try running it in the same directory as your site's settings.php file.  With D8, some versions of drush have a hard time finding this unless you run it there or set up an alias for the site.  

Older version could find it settings.php based on your location (e.g. in a subdirectory of the site directory or would use the sites/default).  But newer Drush versions need more information.