PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused

I found the reason why the connection was not working, it was because the connection was trying to connect to port 8888, when it needed to connect to port 8889.

$conn = new PDO("mysql:host=$servername;port=8889;dbname=AppDatabase", $username, $password);

This fixed the problem, although changing the server name to localhost still gives the error.

Connection failed: SQLSTATE[HY000] [2002] No such file or directory

But it connects successfully when the IP address is entered for the server name.

Related Posts:

  1. PHP Connection failed: SQLSTATE[HY000] [2002] Connection refused
  2. How to use mysqli_query() in PHP?
  3. PDOException SQLSTATE[HY000] [2002] No such file or directory
  4. PDOException SQLSTATE[HY000] [2002] No such file or directory
  5. PHP Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP
  6. what does “/index.php?admin/admin_dashboard” in my url mean
  7. PDO with INSERT INTO through prepared statements
  8. PDO bindParam() with prepared statement isn’t working
  9. How can I prevent SQL injection in PHP?
  10. SQLSTATE[HY093]: Invalid parameter number: parameter was not defined
  11. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  12. Call to a member function on null?
  13. How to create a foreign key in phpmyadmin
  14. ERROR: SQLSTATE[HY000] [2002] No connection could be made because the target machine actively refused it
  15. What is the advantage of using try {} catch {} versus if {} else {}
  16. Deprecated: mysql_query() [duplicate]
  17. If variable equals value php [duplicate]
  18. PHP date() format when inserting into datetime in MySQL
  19. MySQL – count total number of rows in php
  20. PHP Warning: mysqli_error(): Couldn’t fetch mysqli in
  21. Foreach only outputs if id is 0
  22. MySQL Error: : ‘Access denied for user ‘root’@’localhost’
  23. MySQL Error “Operand should contain 1 column”
  24. How to use MySQL DECIMAL?
  25. MySQL ERROR 1290 (HY000) –secure-file-priv option
  26. MySQL server startup error ‘The server quit without updating PID file’
  27. Invalid column count in CSV input on line 1 Error
  28. MySQL ERROR 1045 (28000): Access denied for user ‘bill’@’localhost’ (using password: YES)
  29. How do I quickly rename a MySQL database (change schema name)?
  30. What does SQL Select symbol || mean?
  31. Setting up foreign keys in phpMyAdmin?
  32. phpMyAdmin: secret passphrase?
  33. MySQL error code: 1175 during UPDATE in MySQL Workbench
  34. Access denied; you need (at least one of) the SUPER privilege(s) for this operation
  35. PDO closing connection
  36. How to find MySQL process list and to kill those processes?
  37. MySQL Server on MAMP-Windows Will Not Start
  38. SQL statement not working – “Operand type clash: date is incompatible with int’
  39. How can I output MySQL query results in CSV format?
  40. importing a CSV into phpmyadmin
  41. How can I rebuild indexes and update stats in MySQL innoDB?
  42. select * from table where column = something or, when unavailable, column = something else
  43. Differences between utf8 and latin1
  44. There can be only one auto column
  45. What’s a good strategy for planning WordPress DB growth?
  46. How to get the list of WooCommerce product image of a certain category from database?
  47. WordPress will not operate correctly
  48. tag search using WP_Query
  49. Your PHP installation appears to be missing the MySQL extension which is required by WordPress
  50. Error: MySQL shutdown unexpectedly. XAMPP local conf running WordPress
  51. How can I SQL update a meta_value to remove the dollar signs that were entered with the value? (so just the value remains)
  52. if statement on database query
  53. Is the regular ajax request method safe or I should use admin-ajax.php?
  54. How can I make wordpress suppress mysql errors?
  55. Styling images coming from another blog
  56. How to convert objects into arrays
  57. Ajax $wpdb not returning table data
  58. Set meta_key and meta_value for all registered user in wordpress using sql query [closed]
  59. Can’t get wp_insert_post to work
  60. Connect another DB and fetch records from some tables
  61. mysql query from wordpress page using custom table
  62. PHP Fatal error: Uncaught mysqli_sql_exception: Table doesn’t exist in wordpress/wp-includes/wp-db.php
  63. How to check if a meta value has already been assigned to any user?
  64. Error: MySQL shutdown unexpectedly [closed]
  65. Not connecting to database in file with multiple MySQL connections
  66. Way to bulk make all my tags lowercase?
  67. $Wpdb post meta query is not working with mutliple meta keys and values? [closed]
  68. Defining the same price to all WooCommerce Products
  69. pagination on data fetched using SQL query
  70. Database Structure on Different Servers
  71. Using ‘mysqli_connect’ ‘crashes’ WordPress client-side
  72. email alert for product availability
  73. How to set MYSQLI_OPT_INT_AND_FLOAT_NATIVE option
  74. How do I prepare strings for insertions as values into a MySQL table?
  75. How to insert dash (-) into database using wpdb and new_to_publish hook?
  76. MySQL: How to change url in posts from xxx.com to yyy.org?
  77. How to fetch all meta_key and meta_value using post_id wihout duplication of post meta using sql query
  78. Upgrade DB Loop – WordPress DB Version Conflict
  79. WordPress & MySQL , problem with use many array in meta_query
  80. WordPress low speed after migrating to new host
  81. Button writing to MYSQL database
  82. MySQL ‘duplicate entry’ error
  83. WP Function does not trigger on Webhook API Call
  84. How to edit content in WordPress and the Polylang – plugin? – with demosite
  85. WordPress Dutch characters encoding problem
  86. How to show result of sql query in a page?
  87. Select latest 2 articles, but only from given category
  88. CONCAT_WS in custom sql query
  89. Ordering topics by most replies in X days using MYSQL statement
  90. Conditional statement within WP SQL query
  91. WordPress upload images not displaying
  92. MySQL database migration to WordPress
  93. Running WordPress from MySQL Cluster with HAPRoxy
  94. Custom query_posts() parameter
  95. Query Concatenation
  96. SQL command to export post_content from wp_posts using phpMyAdmin
  97. Display total count of products in orders of a specific order status
  98. mysqldump to a tar.gz
  99. Where is my mysql log on OS X?
  100. running an existing WordPress site from Visual Studio Code?

Leave a Comment