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

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.

Related Posts:

  1. PDOException SQLSTATE[HY000] [2002] No such file or directory
  2. PDOException SQLSTATE[HY000] [2002] No such file or directory
  3. PDO with INSERT INTO through prepared statements
  4. PDO bindParam() with prepared statement isn’t working
  5. Fix Access denied for user ‘root’@’localhost’ for phpMyAdmin
  6. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  7. Call to a member function on null?
  8. What is the advantage of using try {} catch {} versus if {} else {}
  9. Deprecated: mysql_query() [duplicate]
  10. How to log in to phpMyAdmin with WAMP, what is the username and password?
  11. Should I use mysqli_real_escape string() or mysql_real_escape_string() for form data?
  12. Fatal error: Call to undefined function mysql_connect()
  13. http://localhost:80 is not working on running Apache server through UniServer ZeroXIII
  14. Mysql query- How to use contains?
  15. mysqli_fetch_array() expects parameter 1 to be mysqli_result, boolean given in
  16. Invalid column count in CSV input on line 1 Error
  17. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  18. Invalid column count in CSV input on line 1 Error
  19. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  20. $wpdb->update or $wpdb->insert results in slashes being added in front of quotes
  21. phpMyAdmin: secret passphrase?
  22. Forbidden :You don’t have permission to access /phpmyadmin on this server
  23. Creating a search form in PHP to search a database?
  24. How can I do ‘insert if not exists’ in MySQL?
  25. Fatal error: Call to a member function bind_param() on boolean [duplicate]
  26. pdo – Call to a member function prepare() on a non-object
  27. MySqli Commands out of sync; you can’t run this command now
  28. Trying to get property of non-object in
  29. Getting connection failed: php_network_getaddresses: getaddrinfo failed: Name or service not known
  30. Commands out of sync; you can’t run this command now
  31. Lost connection to MySQL server at ‘reading initial communication packet’, system error: 0
  32. Are PDO prepared statements sufficient to prevent SQL injection?
  33. PDO closing connection
  34. PHP with MySQL 8.0+ error: The server requested authentication method unknown to the client
  35. How can I do ‘insert if not exists’ in MySQL?
  36. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  37. Object of class DateTime could not be converted to string
  38. What does it mean to escape a string?
  39. Convert from MySQL datetime to another format with PHP
  40. MAMP “Apache couldn’t be started because port is in use.” AND “Can’t connect to local MySQL server through /tmp/mysql.sock
  41. mysqli::query(): Couldn’t fetch mysqli
  42. Unexpected Exception: SQLSTATE[HY000] [1045] Access denied for user ****@’localhost’ (using password: YES)
  43. Fatal error: Call to undefined function sqlsrv_connect()
  44. Uncaught Error: Call to undefined function mysql_escape_string()
  45. Warning: mysql_fetch_array() expects parameter 1 to be resource, boolean given in
  46. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102
  47. Warning: mysqli_query() expects parameter 1 to be mysqli, resource given
  48. MySQL query to get column names?
  49. What does MYSQLI_NUM mean and do?
  50. Mysql where id is in array
  51. select * from table where column = value ^ column2= value
  52. No query results for model [App\Products] Laravel
  53. Fatal error: Call to a member function query() on null
  54. mysqlworkbench giving version error on exporting database
  55. How to make DROP INDEX IF EXISTS for mysql?
  56. What is the meaning of sprintf(): Too few arguments
  57. Having a problem getting mysqli_query to execute
  58. CodeIgniter: Unable to connect to your database server using the provided settings Error Message
  59. Can I store images in MySQL 
  60. MySQL Daemon Failed to Start – centos 6
  61. How to insert TIMESTAMP into my MySQL table?
  62. How to remove index.php from WordPress site URL
  63. PHP Like thing similar to MySQL Like, for if statement?
  64. How get value from URL
  65. How to use Memcached with PHP7?
  66. select count(*) from table of mysql in php
  67. You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near ””)’ at line 2
  68. Replace ' and similar html codes with their correspondent character?
  69. Google Calendar API event update always return 404 “not found” error
  70. How to prevent the “Confirm Form Resubmission” dialog?
  71. navigate back with PHP form submission
  72. How to set 777 permission on a particular folder? [closed]
  73. How do I make a redirect in PHP?
  74. How to use mysqli_query() in PHP?
  75. List of All Locales and Their Short Codes?
  76. Difference between “as $key => $value” and “as $value” in PHP foreach
  77. How do I get a YouTube video thumbnail from the YouTube API?
  78. What is a slug?
  79. Visual list of all installed fonts with respective pangram phrase?
  80. How to avoid Request Entity Too Large 413 error
  81. Array to String PHP?
  82. Undefined function mysql_connect()
  83. MySQL column count doesn’t match value count at row 1 [closed]
  84. Undefined function mysql_connect()
  85. How can I send an email using PHP?
  86. Fatal error: Call to undefined function mysql_connect()
  87. count() parameter must be an array or an object that implements countable in laravel
  88. regex match any whitespace
  89. What’s the net::ERR_HTTP2_PROTOCOL_ERROR about?
  90. How to fix “Headers already sent” error in PHP
  91. currently unable to handle this request HTTP ERROR 500
  92. PHP page redirect
  93. Fatal error: Call to undefined function mysql_connect()
  94. Whoops, looks like something went wrong. Laravel 5.0
  95. PHP “or” Syntax
  96. How to fix “Headers already sent” error in PHP
  97. “Notice: Undefined variable”, “Notice: Undefined index”, and “Notice: Undefined offset” using PHP
  98. What are namespaces?
  99. Get the full URL in PHP
  100. How do I get PHP errors to display?

Leave a Comment

Hata!: SQLSTATE[HY000] [1045] Access denied for user 'divattrend_liink'@'localhost' (using password: YES)