Can’t Connect to MySQL Database using WP CLI and MAMP on a macOS Catalina, using Oh My Zsh

Generally, MAMP is not installed in a place that wp-cli expect it to be installed. And the MySQL socket file is needed to by the application.

Creating a symbolic link would help.

  1. Locate the socket file location either in tmp or var

    netstat -a | grep mysql

    In the case of MAC Sierra and MAMP PRO, you have /Applications/MAMP/tmp/mysql/mysql.sock

  2. Create a symbolic link to this file

    cd /var 
sudo mkdir mysql
sudo chmod 755 mysql
cd mysql
sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock mysql.sock

If this did not work you can also add a symbolic to tmp folder.

cd tmp
sudo ln -s /Applications/MAMP/tmp/mysql/mysql.sock mysql.sock

This is a tweak to the answer by @Brain Lowe here

Related Posts:

  1. Detect if WP is running under WP-CLI
  2. wp-cli Enabling Maintainance Mode
  3. WP-CLI Cannot Connect to Database due to Vagrant
  4. Changing the WP CLI cache folder
  5. WP-CLI Process Killed
  6. wp-cli commands do nothing, return nothing
  7. How do I clone or duplicate a post with the WordPress Command Line Interface WP-CLI?
  8. WP-CLI get all posts from certain post type and taxonomy term
  9. Does wp post delete also delete metadata associated with posts?
  10. WP-CLI :: Cannot installing plugin as www-data
  11. Export list of users with first and lastname in WP-CLI
  12. WP-CLI – Return posts with matching meta key
  13. What could cause WP-CLI search-replace to not replace all instances of a string?
  14. Revert WordPress default options after a PHPUnit test has run
  15. Can I create multiple pages at once using WP-CLI?
  16. wp-cli create post and media import
  17. Import Media To CPT with CLI & Filter Custom Taxonomy
  18. wp-cli with MAMP shows sh: mysql: command not found
  19. What is the difference between the Package Language and the Site Language?
  20. How do I update a nested option?
  21. Wp-cli-ssh global installation problem [closed]
  22. WP-CLI with theme: Uncaught Error: Class ‘WP_CLI’ not found
  23. WPCLI search and replace variants for all tables
  24. Allow download_url for lan addresses
  25. What tools respect `.distignore`?
  26. How to prevent WP-CLI shell from exiting when an exception occurs?
  27. WP-CLI Get Site ID from its url
  28. WP-CLI alias: connect with ssh proxy
  29. Ask WP-CLI latest core WordPress version released
  30. How to change a post attribute to homepage using WP CLI?
  31. WP-CLI sudden empty response
  32. How to get all posts related to a term with WP-CLI?
  33. WP CLI: there has been critical error
  34. How to verify a correct wp-cli installation?
  35. How can I add an RSS widget using WP-CLI?
  36. MAMP PRO WP-CLI Error: Error establishing a database connection
  37. Shortest way to install WP-CLI
  38. “Class ‘Phar’ not found” error setting up WP-CLI with Cygwin
  39. Uninstall WP-CLI
  40. Running WP-CLI without SSH
  41. Is it possible to delete a range of posts by ID with WP-CLI?
  42. Get last published post in WordPress using wp-cli
  43. WP Cli will not execute on Windows
  44. Formatting messed up when piping wp commands
  45. Where do the files of a custom WP CLI Command reside?
  46. wpcli: Error on post_content or post_title if accents
  47. wp-cli configuration in php?
  48. Lock User and Enforce Password change via wp-cli
  49. BackupBuddy WP CLI Invalid Profile Error
  50. How to find what pages/posts contain a particular reusable block?
  51. How can I search and replace by post type?
  52. Only the WP CLI command, wp –info, runs under my cPanel account
  53. Error establishing a database connection when running phpunit
  54. Set Site Icon programmatically (eg. using `wp cli`)
  55. How to rename default category name and slug using WP CLI?
  56. Resetting internal WordPress state during its cycle
  57. How do I add HTML code to a widget with wp-cli?
  58. Wildcard for wp-cli search-replace
  59. Update BackupBuddy with WP-CLI
  60. Is resetting post data necessary with custom WP_CLI commands?
  61. Get media url (featured image) with wp-cli
  62. Migrating Multisite with WP-Cli and/or Search-Replace-DB
  63. Can I use wp-cli to create posts with a custom post types?
  64. WP CLI: search and replace specific directory name of URL
  65. WP-CLI plugin install causes PHP fatal error – Using $this when not in object context
  66. How to delete a single post using wp cli in command line?
  67. Adding content from file with wp post create
  68. WP CLI allowed fields?
  69. WP-CLI unable to recongnise PHP server / environment variables on Ubuntu
  70. WP-CLI media import error
  71. Is it possible to view WP documentation within the WordPress shell?
  72. Userless db-only wordpress instalation
  73. WPCLI doesn’t recognize the site
  74. One-click WP site generation wih wp-cli on Windows
  75. Combine WPCLI commands for plugin installation and activation?
  76. Add passwords to config.yml to manage multiple sites
  77. What user should I use for wp-cli on Ubuntu VPS [closed]
  78. WP-CLI mysteriously stopping while downloading the core [closed]
  79. Working with CLI and missing my namespace classes inside
  80. Mocking WP_CLI static methods in unit tests
  81. How to add an array to a command “wp config set”?
  82. WP CLI: critical error on your website
  83. How to specify which editor is used when editing posts with WP-CLI?
  84. WP changes siteurl, but some URLs then don’t work
  85. Creating a subcommand for custom wp-cli command
  86. Install plugin on remote wordpress
  87. WP-CLI is unable to update password
  88. WP-CLI – How to install a plugin from a remote server
  89. Make WordPress more like Jekyll (using wp-cli package?)
  90. Find latest/published version of post using wp-cli
  91. Wp-cli from a plugin?
  92. Is it possible to update a single page using WP-CLI?
  93. undefined function apache_request_headers()
  94. ignoring, hidding mu plugins when wp-cli is run
  95. How to install WordPress with Composer?
  96. WP-CLi Uable to Install / Update Plugins
  97. Remote Export DB w. WP-cli.phar Over SSH
  98. Post Count for Multisite?
  99. is it possible to use wp cli to export custom post types
  100. Why doesn’t “wp db cli” enable tab completion?
techhipbettruvabetnorabahisbahis forumueduseduedusedueduseduseduseduedusedu