Threads: 1 Questions: 1 Slow queries: 0 Opens: 12 Flush tables: 1 Open tables: 6 Queries per second avg: 0.022 This is free software,Īnd you are welcome to modify and redistribute it under the GPL license This software comes with ABSOLUTELY NO WARRANTY. applications/mamp/library/bin/mysqladmin Ver 8.41 Distrib 5.0.41, for apple-darwin8.11.1 on i686 If I launch MySQL, sudo -b mysqld_safe, and issue the command again, I get the expected response: This indicates that bash is trying to run the mysqladmin command using my non-MAMP install of MySQL. Applications/MAMP/Library/bin/mysqladmin: connect to server at 'localhost' failedĮrror: 'Can't connect to local MySQL server through socket '/private/tmp/mysql.socket' (2)'Ĭheck that mysqld is running and that the socket: '/private/tmp/mysql.socket' exists! Applications/MAMP/Library/bin/mysqladmin version I can't access mysqladmin for MAMP's install of MySQL.įor example, if I enter the following command: Yes, this same information is also included with MAMP.Īs I explained above, my problem is different. Which, of course, means that my command is being applied to my non-MAMP install of MySQL. however, I get the error message:ĮRROR 2002 (HY000): Can't connect to local MySQL server through socket '/private/tmp/mysql.socket' (2) Here I've added the path to my MAMP bin directory (where mysqladmin is found) before anything else. bash_login file:Įxport PATH="/Applications/MAMP/Library/bin:/usr/local/bin:/usr/local/sbin: For example, I've applied the following line to my. bash_login files, but this isn't fixing the problem. I've tried to reconfigure my environment variables for my PATH in both my. However, I'm having trouble doing this because my bash shell tries to apply the commands I enter to my non-MAMP install of MySQL. As I understand it, this must be done from the command line. I'd like to change my root password for the MySQL install running under MAMP. My installation of MAMP appears to be working fine. Recently, I've decided to give MAMP a try. Which is very misleading because it has nothing to do with the password but the directory you’re in.I have the latest version of MySQL installed on my Mac. If you are not in the right Mamp folder where the database lives, you will get the following error. It’s because you need to make sure all the images are in the uploads folder. So if you get this error: Images not importing properly after migration The database only holds the URLs of the images. You will also need to install MySQL with the following command: brew install mysql How to ensure images come in properly brew install phpįinally, to install WP-CLI with Homebrew, you use the following command. You can also see the official PHP website here for further instructions. bin/bash -c "$(curl -fsSL )"Īfter that, you can install PHP with the following command. See their website here for further instructions. To install Homebrew, you can use the following command. Long story short, that opened a can of worms that lasted about a day until I re-installed homebrew and then I was able to install PHP and WP-CLI. I was trying to export the database from MAMP with: wp db exportīut it kept saying command not found: wp. The site and home URLs usually go hand-in-hand when you run them together. To set the home URL, run the following command wp option set home "new-url"ĭon’t forget to flush the cache wp cache flush To set the site URL, run the following command wp option set siteurl "new-url" You can also check the site/home URL wp option get siteurl Here’s the WordPress documentation on the wp search-replace command. To do a search-replace to update the home and site URL you can use the following command wp search-replace '' '' -precise -recurse-objects -all-tables To copy the file over to another folder: cp -rf filename destinationfolder In my case, I usually move the file to my desktop (/Users/efrainlemus-martinez/Desktop) so it’s easier to drag in FTP. To move the file to another direcotry: mv filename destinationfolder It will prompt for the database password, it’s usually “ root“ mysqldump -u dbusername -p dbname > filename.txt Here’s the command to run to export the database. Which I’ll just add below: cd /applications/MAMP/library/bin Be sure to be in the right directory, read Export / Import Large Database from MAMP using Terminal to see the right directory you need to be in.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |