CODEWITHSUNDEEP
phpmysqlmacoslocalhost
JP Lew
JP Lew

Reputation: 4469

getting "db: SQLSTATE[HY000] [2002] Connection refused" error on Mac with MAMP

I am trying to run the CLI version of this PHP databse Search and Replace Script, but I think this a more general MySQL problem relating to Mac OS X and MAMP. I receive the following error whenever I attempt to run the CLI script locally:

db: SQLSTATE[HY000] [2002] Connection refused

Here is the command I'm running:

./srdb.cli.php -h 127.0.0.1 -u root -n mydbname -proot -c utf\-8 -s mywebsite.com -r dev.mywebsite.com

What I've tried

I am using this mysql: /Applications/MAMP/Library/bin/mysql

And this php: /Applications/MAMP/bin/php/php5.3.28/bin/php

Anybody any ideas? Thanks!

Edit

Here is the source code showing how the script connects to MySQL: https://github.com/interconnectit/Search-Replace-DB/blob/master/srdb.cli.php

which in turn imports this:

https://github.com/interconnectit/Search-Replace-DB/blob/master/srdb.class.php

Upvotes: 2

Views: 9979

Answers (3)

user1574371
user1574371

Reputation: 73

To add onto z80crew's brilliant solution, for anyone else unfamiliar/uncomfortable with altering path variables, specifying the full location paths for both the MAMP php binary and the search-replace-db script in the cli script provided by interconnect solved the problem for me. I put the strings to search for and replace with in quotes. I also increased the php timeout limit in wp-config.php with: set_time_limit(3000);

I was consistent with the server name between the options passed to the script and what's in my wp-config.php file (using localhost in wp-config, using localhost in the script as well)

/Applications/MAMP/bin/php/php7.4.2/bin/php /Applications/MAMP/htdocs/test/Search-Replace-DB-master/srdb.cli.php -h localhost -u root -proot --port 8889 -n test -s "http://olddomain.com" -r "http://localhost:8888/test" -v true

Upvotes: 0

Mahak Choudhary
Mahak Choudhary

Reputation: 1384

Stop mysql :

sudo service mysql stop

And then start it :

sudo service mysql start

It resolved the problem

Upvotes: 1

z80crew
z80crew

Reputation: 1200

As stated in my comment already, chances are that you're not running the PHP binary you thought you were running. Even if the MAMP php binary is in your path, the shebang line in srdb.cli.php reads #!/usr/bin/php and that points to the Apple-provided php binary.

So if you invoke the script with the full path to your MAMP php binary, the problem should be avoided:

/Applications/MAMP/bin/php/php5.3.28/bin/php srdb.cli.php -h 127.0.0.1 -u root -n mydbname -proot -c utf\-8 -s mywebsite.com -r dev.mywebsite.com

Another solution might be to replace the shebang line with:

#!/usr/bin/env php

This works only if the MAMP binary is in your $PATH in front of /usr/bin. Using #!/usr/bin/env phpensures however, that you're always using the same binary no matter if you're invoking the script via ./srdb.cli.php or with php srdb.cli.php.

Upvotes: 10

Related Questions