ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it

by

If the WAMP icon is Orange then one of the services has not started.

In your case it looks like MySQL has not started as you are getting the message that indicates there is no server running and therefore listening for requests.

Look at the mysql log and if that tells you nothing look at the Windows event log, in the Windows -> Applications section. Error messages in there are pretty good at identifying the cause of MySQL failing to start.

Sometimes this is caused by a my.ini file from another install being picked up by WAMPServers MySQL, normally in the \windows or \windows\system32 folders. Do a search for ‘my.ini’ and ‘my.cnf’ and if you find one of these anywhere outside of the \wamp…. folder structure then delete it, or at least rename it so it wont be found. Then restart the MySQL service.

More Related Contents:

  1. How to check if a row exists in MySQL? (i.e. check if username or email exists in MySQL)
  2. How to apply bindValue method in LIMIT clause?
  3. How do I use password hashing with PDO to make my code more secure? [closed]
  4. PDO with INSERT INTO through prepared statements [closed]
  5. PDO::fetchAll vs. PDO::fetch in a loop
  6. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  7. Real escape string and PDO [duplicate]
  8. PDO multiple queries
  9. PHP PDO vs normal mysql_connect
  10. Can I create a database using PDO in PHP?
  11. PHP PDO and MySQLi [duplicate]
  12. PDO fetch one column from table into 1-dimensional array
  13. Update query with PDO and MySQL
  14. Is “SET CHARACTER SET utf8” necessary?
  15. Set PDO to throw exceptions by default [duplicate]
  16. PDO: MySQL server has gone away
  17. return one value from database with mysql php pdo
  18. Trying to access array offset on value of type bool
  19. How to get a query error from prepare() in PDO PHP?
  20. Checking for an empty result (PHP, PDO, and MySQL) [duplicate]
  21. How can I pass an array of PDO parameters yet still specify their types?
  22. PHP PDO how to run a multiple query request?
  23. PHP/SQL Insert Error when using Named Placeholders
  24. How to escape single-quote (apostrophe) in string using php
  25. PHP Laravel: No connection could be made because the target machine actively refused it
  26. php, mysql – Too many connections to database error
  27. PDO bindParam into one statement?
  28. Insert value list does not match column list: 1136 Column count doesn’t match value count
  29. What is the PDO equivalent of function mysql_real_escape_string?
  30. Installing PDO driver on MySQL Linux server

Leave a Comment