Sequel Pro and MySQL connection failed : <p>I just installed mysql on mac from Homebrew </p>

<pre><code>brew install mysql

mysql -V

mysql  Ver 8.0.11 for osx10.13 on x86_64 (Homebrew)
</code></pre>

<p>from terminal it works and I can login to mysql but from Sequel Pro it says</p>

<p><a href="https://i.stack.imgur.com/CIJGy.png" rel="noreferrer"><img src="https://i.stack.imgur.com/CIJGy.png" alt="enter image description here"></a></p>

<blockquote>
  <p>Unable to connect to host 127.0.0.1, or the request timed out.</p>
  
  <p>Be sure that the address is correct and that you have the necessary
  privileges, or try increasing the connection timeout (currently 10
  seconds).</p>
  
  <p>MySQL said: Authentication plugin 'caching_sha2_password' cannot be
  loaded: dlopen(/usr/local/lib/plugin/caching_sha2_password.so, 2):
  image not found</p>
</blockquote>

<p>can't figure out what I am missing</p>
