title: How to connect to local MySQL Server 8.0 with DBIish in Perl6
body: <p>I'm working on a Perl6 project, but having difficulty connecting to MySQL. Even when using the DBIish (or perl6.org tutorial) example code, the connection fails. Any suggestions or advice is appreciated! User credentials have been confirmed accurate too.</p>
  
  <p>I'm running this on Windows 10 with MySQL Server 8.0 and standard Perl6 with Rakudo Star. I have tried modifying the connection string in numerous ways like :$password :password&lt;> :password() etc. but can't get a connection established. Also should note that I have the ODBC, C, C++, and.Net connectors installed.</p>
  
  <pre><code>#!/usr/bin/perl6
  use v6.c;
  use lib 'lib';
  use DBIish;
  use Register::User;
  
  # Windows support
  %*ENV&lt;DBIISH_MYSQL_LIB&gt; = "C:/Program Files/MySQL/MySQL Server 8.0/liblibmysql.dll"
      if $*DISTRO.is-win;
  
  my $dbh = DBIish.connect('mysql', :host&lt;localhost&gt;, :port(3306), :database&lt;dbNameHere&gt;, :user&lt;usernameHere&gt;, :password&lt;pwdIsHere&gt;) or die "couldn't connect to database"; 
  my $sth = $dbh.prepare(q:to/STATEMENT/);
      SELECT *
      FROM users
      STATEMENT
  
  $sth.execute();
  
  my @rows = $sth.allrows();
  
  for @rows { .print }
  say @rows.elems;
  
  $sth.finish;
  $dbh.dispose;
  </code></pre>
  
  <p>This should be connecting to the DB. Then the app runs a query, followed by printing out each resulting row. What actually happens is the application hits the 'die' message every time.</p>