Error message:

“…Library not loaded: libmysqlclient.18.dylib

Referenced from: …ython2.7/site-packages/_mysql.so
  Reason: image not found”

the reason:

After upgrading MySQL, libmysqlclient.18.dylib becomes libmysqlclient.20.dylib.

Solution:

Find mysql lib under the installation path of libmysqlclient.20.dylibestablishing a soft connection.

sudo ln -s /usr/local/mysql/lib/libmysqlclient.20.dylib /usr/local/mysql/lib/libmysqlclient.18.dylib

Read More:

• [Solved] zabbix configure: error: MySQL library not found
• [Solved] Sphinx macos sql_connect: failed to load libmysqlclient
• After installing mysql5.7 on centos7, an error 1045 (28000) is reported: access denied for user ‘root’ @’localhost ‘(using PAS)
• [Solved] there are special symbols in the initial password for installing MySQL in Hadoop, and an error is reported
• How to Solve MYSQL Error: No module named MySQLdb
• [Solved] Python import Error: pip –upgrade Error: ERROR: Cannot uninstall ‘dnspython‘. It is a distutils installed
• Error [err] is reported when redirecting_HTTP_HEADERS_SENT]: Cannot set headers after they are sent to the client
• [Solved] Navicat Connect MySQL error: Authentication plugin ‘caching_sha2_password‘ cannot be loaded
• [Solved] public key is not available client side (option serverRsaPublicKeyFile not set)
• [Solved] Error: ER_HOST_NOT_PRIVILEGED: Host ‘x.x.x.x‘ is not allowed to connect to this MySQL server
• [Solved] MySQL: Syntax error or access violation: 1055 Expression #1 of SELECT list is not …
• How to Fix MySQL ERROR 1130 (HY000): Host ‘XXXX’ is not allowed to connect to this MySQL server
• [Solved] Description: Failed to configure a DataSource: ‘url‘ attribute is not specified and no embedded
• The setobject() method reports an error. The parameter index out of range and MySQL syntax error exception report an error
• pymysql Error: File “/usr/local/lib/python2.7/site-packages/PyMySQL-1.0.2-py2.7.egg/pymysql/connections.py”, line 167 SyntaxError: invalid syntax
• [Solved] MySQL Error: “Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggre”
• MYSQL Slave is not configured or failed to initialize properly. You must at least set –server-id
• Remote connection to MySQL database error: is not allowed to connect to this MYSQL server solution
• [Solved] ERROR 1055 (42000): Expression #1 of SELECT list is not in GROUP BY clause and contains nonaggregate
• Caused by: java.sql.SQLTransientConnectionException: HikariPool-1 – Connection is not available, request timed out after 30005ms.