PHP Warning: mysqli_connect(): (HY000/2002): Connection refused

by

In case anyone else comes by this issue, the default port on MAMP for mysql is 8889, but the port that php expects to use for mysql is 3306. So you need to open MAMP, go to preferences, and change the MAMP mysql port to 3306, then restart the mysql server. Now the connection should be successful with host=localhost, user=root, pass=root.

More Related Contents:

  1. CakePHP Database connection “Mysql” is missing, or could not be created
  2. php+mysql Fatal error: Call to undefined function mysql_connect()
  3. Using PHP data in MySQL [closed]
  4. drop down menu using php and mysql [closed]
  5. php code for multiple search box after connecting to mysql [closed]
  6. Checking the availability of rooms
  7. How to sort user data by id
  8. Select those record only from table 1 where city exist against state id in table 2 in PHP
  9. PHP PDO prepared statements
  10. Example of how to use bind_result vs get_result
  11. mysqli::query(): Couldn’t fetch mysqli
  12. select count(*) from table of mysql in php
  13. Incorrect Integer (2147483647) is inserted into MySQL?
  14. I need my PHP page to show my BLOB image from mysql database
  15. How to test if a MySQL query was successful in modifying database table data?
  16. jQuery UI Sortable, then write order into a database
  17. How to override the path of PHP to use the MAMP path?
  18. Delete multiple rows by selecting checkboxes using PHP
  19. Object of class DateTime could not be converted to string
  20. PHP MYSQL UPDATE if Exist or INSERT if not?
  21. mysql_real_escape_string VS addslashes
  22. How to add a delete button to a PHP form that will delete a row from a MySQL table
  23. IP address storing in MySQL database using PHP [duplicate]
  24. “No such file or directory” or “No such host is known” when running migrations
  25. How to convert IPv6 from binary for storage in MySQL
  26. Select last 20 order by ascending – PHP/MySQL
  27. mysqli – fetch_Array error call to a member function fetch_array() on a non-object mysqli [duplicate]
  28. How do I save PHP session data to a database instead of in the file system?
  29. MySQL, how to insert null dates
  30. Escaping SQL queries in Codeigniter

Leave a Comment