title: error when install mysqlclient using pip to MacOS Bigsur
body: <p>I've tried common solutions written for mysqlclient error</p>
  <ul>
  <li>1st try: <code>brew install mysql-connector-c</code></li>
  <li>2nd try:
  <code>LDFLAGS=-L/usr/local/opt/openssl/lib pip install mysqlclient</code></li>
  <li>3rd try: <code>brew install zstd</code></li>
  </ul>
  <p>And mysql server is well-running.
  But the error is not being fixed..</p>
  <p>I am getting <code>clang linker error</code> saying <code>library not found for -lzstd</code></p>
  <pre><code>    clang -bundle -undefined dynamic_lookup -L/usr/local/opt/readline/lib -L/usr/local/opt/readline/lib -L/Users/user/.asdf/installs/python/3.7.10/lib -L/usr/local/opt/llvm/lib -L/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/lib -L/usr/local/opt/readline/lib -L/usr/local/opt/readline/lib -L/Users/user/.asdf/installs/python/3.7.10/lib -L/usr/local/opt/llvm/lib -L/Library/Developer/CommandLineTools/SDKs/MacOSX.sdk/usr/lib -L/usr/local/opt/llvm/lib -I/usr/local/opt/llvm/include build/temp.macosx-11.2-x86_64-3.7/MySQLdb/_mysql.o -L/usr/local/Cellar/mysql/8.0.25_1/lib -lmysqlclient -lzstd -lresolv -o build/lib.macosx-11.2-x86_64-3.7/MySQLdb/_mysql.cpython-37m-darwin.so
  ld: library not found for -lzstd
  clang-12: error: linker command failed with exit code 1 (use -v to see invocation)
  error: command 'clang' failed with exit status 1
  </code></pre>