mac安装MySQLdb-不完全踩坑指北

题记:homebrew在2020年初移除了对python2的支持,同时也移除了可以直接安装编译好的MySQLdb包。所以…

首先安装mysql的开发工具包和openssl

brew install mysql-connector-c
brew install openssl

根据指示添加PATH以及编译时候的lib和incloud

export PATH="/usr/local/opt/openssl@1.1/bin:$PATH"
export PATH="/usr/local/opt/mysql-client/bin:$PATH"

export LDFLAGS="-L/usr/local/opt/mysql-client/lib -L/usr/local/opt/openssl@1.1/lib"
export CPPFLAGS="-I/usr/local/opt/mysql-client/include -I/usr/local/opt/openssl@1.1/include"

8.0.15开始mysql-connector-c不提供my_config.h文件,需要手动复制一份8.0.14以前的my_config.h

vim /usr/local/opt/mysql-client/include/mysql/my_config.h

获取my_config.h

最后就可以编译了

pip install MySQL-python

 

附: my_config.h

/* Copyright (c) 2009, 2018, Oracle and/or its affiliates. All rights reserved.
  
  This program is free software; you can redistribute it and/or modify
  it under the terms of the GNU General Public License, version 2.0,
  as published by the Free Software Foundation.
 
  This program is also distributed with certain software (including
  but not limited to OpenSSL) that is licensed under separate terms,
  as designated in a particular file or component or in included license
  documentation.  The authors of MySQL hereby grant you an additional
  permission to link the program and your derivative works with the
  separately licensed software that they have included with MySQL.
 
  This program is distributed in the hope that it will be useful,
  but WITHOUT ANY WARRANTY; without even the implied warranty of
  MERCHANTABILITY or FITNESS FOR A PARTICULAR PURPOSE.  See the
  GNU General Public License, version 2.0, for more details.
 
  You should have received a copy of the GNU General Public License
  along with this program; if not, write to the Free Software
  Foundation, Inc., 51 Franklin St, Fifth Floor, Boston, MA 02110-1301  USA */
 
 #ifndef MY_CONFIG_H
 #define MY_CONFIG_H
 
 /*
  * From configure.cmake, in order of appearance 
  */
 /* #undef HAVE_LLVM_LIBCPP */
 
 /* Libraries */
 #define HAVE_LIBM 1
 /* #undef HAVE_LIBNSL */
 #define HAVE_LIBCRYPT 1
 /* #undef HAVE_LIBSOCKET */
 #define HAVE_LIBDL 1
 #define HAVE_LIBRT 1
 /* #undef HAVE_LIBWRAP */
 /* #undef HAVE_LIBWRAP_PROTOTYPES */
 
 /* Header files */
 #define HAVE_ALLOCA_H 1
 #define HAVE_ARPA_INET_H 1
 #define HAVE_DLFCN_H 1
 #define HAVE_EXECINFO_H 1
 #define HAVE_FPU_CONTROL_H 1
 #define HAVE_GRP_H 1
 /* #undef HAVE_IEEEFP_H */
 #define HAVE_LANGINFO_H 1
 /* #undef HAVE_LSAN_INTERFACE_H */
 #define HAVE_MALLOC_H 1
 #define HAVE_NETINET_IN_H 1
 #define HAVE_POLL_H 1
 #define HAVE_PWD_H 1
 #define HAVE_STRINGS_H 1
 #define HAVE_SYS_CDEFS_H 1
 #define HAVE_SYS_IOCTL_H 1
 #define HAVE_SYS_MMAN_H 1
 #define HAVE_SYS_PRCTL_H 1
 #define HAVE_SYS_RESOURCE_H 1
 #define HAVE_SYS_SELECT_H 1
 #define HAVE_SYS_SOCKET_H 1
 #define HAVE_TERM_H 1
 #define HAVE_TERMIOS_H 1
 #define HAVE_TERMIO_H 1
 #define HAVE_UNISTD_H 1
 #define HAVE_SYS_WAIT_H 1
 #define HAVE_SYS_PARAM_H 1
 #define HAVE_FNMATCH_H 1
 #define HAVE_SYS_UN_H 1
 /* #undef HAVE_VIS_H */
 #define HAVE_SASL_SASL_H 1
 
 /* Libevent */
 /* #undef HAVE_DEVPOLL */
 /* #undef HAVE_SYS_DEVPOLL_H */
 #define HAVE_SYS_EPOLL_H 1
 #define HAVE_TAILQFOREACH 1
 
 /* Functions */
 /* #undef HAVE_ALIGNED_MALLOC */
 #define HAVE_BACKTRACE 1
 /* #undef HAVE_PRINTSTACK */
 #define HAVE_INDEX 1
 #define HAVE_CHOWN 1
 #define HAVE_CUSERID 1
 /* #undef HAVE_DIRECTIO */
 #define HAVE_FTRUNCATE 1
 #define HAVE_FCHMOD 1
 #define HAVE_FCNTL 1
 #define HAVE_FDATASYNC 1
 #define HAVE_DECL_FDATASYNC 1 
 #define HAVE_FEDISABLEEXCEPT 1
 #define HAVE_FSEEKO 1
 #define HAVE_FSYNC 1
 /* #undef HAVE_GETHRTIME */
 #define HAVE_GETNAMEINFO 1
 #define HAVE_GETPASS 1
 /* #undef HAVE_GETPASSPHRASE */
 #define HAVE_GETPWNAM 1
 #define HAVE_GETPWUID 1
 #define HAVE_GETRLIMIT 1
 #define HAVE_GETRUSAGE 1
 #define HAVE_INITGROUPS 1
 /* #undef HAVE_ISSETUGID */
 #define HAVE_GETUID 1
 #define HAVE_GETEUID 1
 #define HAVE_GETGID 1
 #define HAVE_GETEGID 1
 /* #undef HAVE_LSAN_DO_RECOVERABLE_LEAK_CHECK */
 #define HAVE_MADVISE 1
 #define HAVE_MALLOC_INFO 1
 #define HAVE_MEMRCHR 1
 #define HAVE_MLOCK 1
 #define HAVE_MLOCKALL 1
 #define HAVE_MMAP64 1
 #define HAVE_POLL 1
 #define HAVE_POSIX_FALLOCATE 1
 #define HAVE_POSIX_MEMALIGN 1
 #define HAVE_PREAD 1
 #define HAVE_PTHREAD_CONDATTR_SETCLOCK 1
 #define HAVE_PTHREAD_SIGMASK 1
 /* #undef HAVE_SETFD */
 #define HAVE_SIGACTION 1
 #define HAVE_SLEEP 1
 #define HAVE_STPCPY 1
 #define HAVE_STPNCPY 1
 /* #undef HAVE_STRLCPY */
 /* #undef HAVE_STRLCAT */
 #define HAVE_STRSIGNAL 1
 /* #undef HAVE_FGETLN */
 #define HAVE_STRSEP 1
 /* #undef HAVE_TELL */
 #define HAVE_VASPRINTF 1
 #define HAVE_MEMALIGN 1
 #define HAVE_NL_LANGINFO 1
 /* #undef HAVE_HTONLL */
 #define HAVE_EPOLL 1
 /* #undef HAVE_EVENT_PORTS */
 #define HAVE_INET_NTOP 1
 /* #undef HAVE_WORKING_KQUEUE */
 #define HAVE_TIMERADD 1
 #define HAVE_TIMERCLEAR 1
 #define HAVE_TIMERCMP 1
 #define HAVE_TIMERISSET 1
 
 /* WL2373 */
 #define HAVE_SYS_TIME_H 1
 #define HAVE_SYS_TIMES_H 1
 #define HAVE_TIMES 1
 #define HAVE_GETTIMEOFDAY 1
 
 /* Symbols */
 #define HAVE_LRAND48 1
 #define GWINSZ_IN_SYS_IOCTL 1
 #define FIONREAD_IN_SYS_IOCTL 1
 /* #undef FIONREAD_IN_SYS_FILIO */
 #define HAVE_MADV_DONTDUMP 1
 
 #define HAVE_ISINF 1
 
 /* #undef HAVE_KQUEUE */
 /* #undef HAVE_KQUEUE_TIMERS */
 #define HAVE_POSIX_TIMERS 1
 
 /* Endianess */
 /* #undef WORDS_BIGENDIAN */
 
 /* Type sizes */
 #define SIZEOF_VOIDP     8
 #define SIZEOF_CHARP     8
 #define SIZEOF_LONG      8
 #define SIZEOF_SHORT     2
 #define SIZEOF_INT       4
 #define SIZEOF_LONG_LONG 8
 #define SIZEOF_OFF_T     8
 #define SIZEOF_TIME_T    8
 #define HAVE_ULONG 1
 #define HAVE_U_INT32_T 1
 #define HAVE_TM_GMTOFF 1
 
 /* Support for tagging symbols with __attribute__((visibility("hidden"))) */
 #define HAVE_VISIBILITY_HIDDEN 1
 
 /* Code tests*/
 #define HAVE_CLOCK_GETTIME 1
 #define HAVE_CLOCK_REALTIME 1
 #define STACK_DIRECTION -1
 #define TIME_WITH_SYS_TIME 1
 /* #undef NO_FCNTL_NONBLOCK */
 #define HAVE_PAUSE_INSTRUCTION 1
 /* #undef HAVE_FAKE_PAUSE_INSTRUCTION */
 /* #undef HAVE_HMT_PRIORITY_INSTRUCTION */
 #define HAVE_ABI_CXA_DEMANGLE 1
 #define HAVE_BUILTIN_UNREACHABLE 1
 #define HAVE_BUILTIN_EXPECT 1
 #define HAVE_BUILTIN_STPCPY 1
 #define HAVE_GCC_ATOMIC_BUILTINS 1
 #define HAVE_GCC_SYNC_BUILTINS 1
 /* #undef HAVE_VALGRIND */
 #define HAVE_SYS_GETTID 1
 /* #undef HAVE_PTHREAD_GETTHREADID_NP */
 /* #undef HAVE_PTHREAD_THREADID_NP */
 #define HAVE_INTEGER_PTHREAD_SELF 1
 #define HAVE_PTHREAD_SETNAME_NP 1
 
 /* IPV6 */
 /* #undef HAVE_NETINET_IN6_H */
 /* #undef HAVE_STRUCT_IN6_ADDR */
 
 /*
  * Platform specific CMake files
  */
 #define MACHINE_TYPE "x86_64"
 /* #undef LINUX_ALPINE */
 /* #undef LINUX_SUSE */
 #define HAVE_LINUX_LARGE_PAGES 1
 /* #undef HAVE_SOLARIS_LARGE_PAGES */
 /* #undef HAVE_SOLARIS_ATOMIC */
 #define SYSTEM_TYPE "Linux"
 /* This should mean case insensitive file system */
 /* #undef FN_NO_CASE_SENSE */
 
 /*
  * From main CMakeLists.txt
  */
 #define MAX_INDEXES 64U
 /* #undef WITH_INNODB_MEMCACHED */
 /* #undef ENABLE_MEMCACHED_SASL */
 /* #undef ENABLE_MEMCACHED_SASL_PWDB */
 #define ENABLED_PROFILING 1
 /* #undef HAVE_ASAN */
 /* #undef HAVE_UBSAN */
 /* #undef HAVE_TSAN */
 /* #undef ENABLED_LOCAL_INFILE */
 #define DEFAULT_MYSQL_HOME "/usr/local/mysql"
 #define SHAREDIR "/usr/local/mysql/share"
 #define DEFAULT_BASEDIR "/usr/local/mysql"
 #define MYSQL_DATADIR "/usr/local/mysql/data"
 #define MYSQL_KEYRINGDIR "/usr/local/mysql/keyring"
 #define DEFAULT_CHARSET_HOME "/usr/local/mysql"
 #define PLUGINDIR "/usr/local/mysql/lib/plugin"
 #define DEFAULT_SYSCONFDIR "/usr/local/mysql/etc"
 #define DEFAULT_TMPDIR P_tmpdir
 /*
  * Readline
  */
 #define HAVE_MBSTATE_T
 #define HAVE_LANGINFO_CODESET 
 #define HAVE_WCSDUP
 #define HAVE_WCHAR_T 1
 #define HAVE_WINT_T 1
 #define HAVE_CURSES_H 1
 /* #undef HAVE_NCURSES_H */
 #define USE_LIBEDIT_INTERFACE 1
 #define HAVE_HIST_ENTRY 1
 /* #undef USE_NEW_EDITLINE_INTERFACE */
 
 /*
  * Libedit
  */
 #define HAVE_DECL_TGOTO 1
 
 /*
  * Character sets
  */
 #define MYSQL_DEFAULT_CHARSET_NAME "utf8mb4"
 #define MYSQL_DEFAULT_COLLATION_NAME "utf8mb4_0900_ai_ci"
 
 /*
  * Performance schema
  */
 #define WITH_PERFSCHEMA_STORAGE_ENGINE 1
 /* #undef DISABLE_PSI_THREAD */
 /* #undef DISABLE_PSI_MUTEX */
 /* #undef DISABLE_PSI_RWLOCK */
 /* #undef DISABLE_PSI_COND */
 /* #undef DISABLE_PSI_FILE */
 /* #undef DISABLE_PSI_TABLE */
 /* #undef DISABLE_PSI_SOCKET */
 /* #undef DISABLE_PSI_STAGE */
 /* #undef DISABLE_PSI_STATEMENT */
 /* #undef DISABLE_PSI_SP */
 /* #undef DISABLE_PSI_PS */
 /* #undef DISABLE_PSI_IDLE */
 /* #undef DISABLE_PSI_ERROR */
 /* #undef DISABLE_PSI_STATEMENT_DIGEST */
 /* #undef DISABLE_PSI_METADATA */
 /* #undef DISABLE_PSI_MEMORY */
 /* #undef DISABLE_PSI_TRANSACTION */
 
 /*
  * MySQL version
  */
 #define MYSQL_VERSION_MAJOR 8
 #define MYSQL_VERSION_MINOR 0
 #define MYSQL_VERSION_PATCH 14
 #define MYSQL_VERSION_EXTRA ""
 #define PACKAGE "mysql"
 #define PACKAGE_VERSION "8.0.14"
 #define VERSION "8.0.14"
 #define PROTOCOL_VERSION 10
 
 /*
  * CPU info
  */
 #define CPU_LEVEL1_DCACHE_LINESIZE 64
 
 
 /*
  * NDB
  */
 /* #undef WITH_NDBCLUSTER_STORAGE_ENGINE */
 /* #undef HAVE_PTHREAD_SETSCHEDPARAM */
 
 /*
  * Other
  */
 /* #undef EXTRA_DEBUG */
 
 /*
  * Hardcoded values needed by libevent/NDB/memcached
  */
 #define HAVE_FCNTL_H 1
 #define HAVE_GETADDRINFO 1
 #define HAVE_INTTYPES_H 1
 /* libevent's select.c is not Windows compatible */
 #ifndef _WIN32
 #define HAVE_SELECT 1
 #endif
 #define HAVE_SIGNAL_H 1
 #define HAVE_STDARG_H 1
 #define HAVE_STDINT_H 1
 #define HAVE_STDLIB_H 1
 #define HAVE_STRDUP 1
 #define HAVE_STRTOK_R 1
 #define HAVE_STRTOLL 1
 #define HAVE_SYS_STAT_H 1
 #define HAVE_SYS_TYPES_H 1
 #define SIZEOF_CHAR 1
 
 /*
  * Needed by libevent
  */
 #define HAVE_SOCKLEN_T 1
 
 /* For --secure-file-priv */
 #define DEFAULT_SECURE_FILE_PRIV_DIR "NULL"
 #define HAVE_LIBNUMA 1
 
 /* For default value of --early_plugin_load */
 /* #undef DEFAULT_EARLY_PLUGIN_LOAD */
 
 #define SO_EXT ".so"
 
 #endif

 

相关日志

  1. 2019.04.03

    密码保护:2019第五号项目搭建指北

    这是一篇受密码保护的文章,您需要提供访问密码…

  2. 2018.04.12

    密码保护:2018酸酸乳搭建指北

    这是一篇受密码保护的文章,您需要提供访问密码…

评论

还没有评论。

在此评论中不能使用 HTML 标签。