title: MySQL ODBC 8.0 Unicode Driver Connection Error [H000]
body: <p>I am unable to connect to MySQL ODBC 8.0 Unicode Driver with unixODBC as underlying driver running on Mac OS.</p>
  
  <p>I am using pyodbc package on python 3.6. Everything works when I use the ANSI driver but the Unicode Driver is not working.</p>
  
  <p>Here are the available drivers installed on my mac.</p>
  
  <blockquote>
    <p>['MySQL ODBC 8.0 ANSI Driver', 'MySQL ODBC 8.0 Unicode Driver', 'ODBC Drivers', 'ODBC Connection Pooling']</p>
  </blockquote>
  
  <p>My Connection String</p>
  
  <blockquote>
    <p>self.connection_string = 'Driver={MySQL ODBC 8.0 Unicode Driver};Server=localhost;Database=db_name;Uid=root;Pwd=P@kistan1;charset=UTF8;Option=3;'</p>
  </blockquote>
  
  <p>And the error detected by pyodbc.Error is</p>
  
  <blockquote>
    <p>('H000', '[H000] [ (0) (SQLDriverConnect)')</p>
  </blockquote>
  
  <p>I am able to establish connection using iODBCAdmin which tells me that the driver is correct.</p>
  
  <p><a href="https://i.stack.imgur.com/SCsq9.png" rel="nofollow noreferrer"><img src="https://i.stack.imgur.com/SCsq9.png" alt="iODBC Admin"></a></p>