PHP Connection failed SQLSTATE HY000 2002 Connection refused

Question

I am trying to use a PHP connection to connect MySQL Database which is on phpmyadmin  Nothing fancy about the connection just trying to see whether the connection is successful or not  I am using MAMP to host the database  the connection I am trying to use is this     lt  php  servername    127 0 0 1    username    root    password    root    try        conn   new PDO  mysql host  servername dbname AppDatabase    username   password          set the PDO error mode to exception      conn- gt setAttribute PDO  ATTR ERRMODE  PDO  ERRMODE EXCEPTION       echo  Connected successfully      catch PDOException  e        echo  Connection failed       e- gt getMessage        gt    I have been using postman to test to see if the connection is working  but I keep receiving this error message          Connection failed  SQLSTATE HY000   2002  Connection refused   Before I was receiving an error message of      Connection failed  SQLSTATE HY000   2002  No such file or directory   This was because I had set the servername to localhost  through changing this to the IP address it has given me connection refused and I have no idea what is wrong   Any help regarding this would be appreciated

User · Answer

For me was php version from mac instead of MAMP, PATH variable on .bash_profile was wrong. I just prepend the MAMP PHP bin folder to the $PATH env variable. For me was:

/Applications/mampstack-7.1.21-0/php/bin

In terminal run vim ~/.bash_profile to open ~/.bash_profile
Type i to be able to edit the file, add the bin directory as PATH variable on the top to the file:

export PATH="/Applications/mampstack-7.1.21-0/php/bin/:$PATH"
Hit ESC, Type :wq, and hit Enter
In Terminal run source ~/.bash_profile
In Terminal type which php, output should be the path to MAMP PHP install.

User · Answer

Using MAMP I changed the host localhost to host 127 0 0 1  But a new issue came  connection refused   Solved this by putting  port    gt   8889   in  Datasources    gt

User · Answer

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

User · Answer

In my case MySQL sever was not running  I restarted the MySQL server and issue was resolved    on ubuntu server sudo  etc init d mysql start  To avoid MySQL stop problem  you can use the  quot initctl quot  utility in Ubuntu 14 04 LTS Linux to make sure the service restarts in case of a failure or reboot  Please consider talking a snapshot of root volume  with mysql stopped  before performing this operations for data retention purpose 8   You can use the following commands to manage the mysql service with  quot initctl quot  utility with stop and start operations    sudo initctl stop mysql   sudo initctl start mysql  To verify the working  you can check the status of the service and get the process id  pid   simulate a failure by killing the  quot mysql quot  process and verify its status as running with new process id after sometime  typically within 1 minute  using the following commands    sudo initctl status mysql           get pid   sudo kill -9  lt pid gt                   kill mysql process   sudo initctl status mysql           verify status as running after sometime   Note   In latest Ubuntu version now initctl is replaced by systemctl

User · Answer

For everyone if you still strugle with Refusing connection  here is my advice  Download XAMPP or other similar sw and just start MySQL  You dont have to run apache or other things just the MySQL

User · Answer

Using MAMP ON Mac  I solve my problem by renaming  Applications MAMP tmp mysql mysql sock lock  to  Applications MAMP tmp mysql mysql sock

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

Examples related to php

Examples related to mysql

Examples related to pdo