mysqli connect HY000 2002 No connection could be made because the target machine actively refused it

Question

I know there are many questions like this  but i didn t find any solution in it   Things i tried -   checked firewall restarted my PC and Apache server restarted MYSQL checked my code Tried everything i know and found on internet   here s my code -   lt  php   dbhost    localhost 3360    dbuser    root    dbpass        db        test db13      conn    mysqli connect  dbhost  dbuser     db    if    conn     die  Could not connect connect          echo  Successfully Connected      sql    Connected Successfully      retvalue   mysqli query  sql      if    retvalue       die  Cannot connect to SQL           echo  DataBase test db13 has successfully created    mysqli close  conn       gt    I did set the password  but it still is showing me the error   Here s the firewall picture -   lastly XAMMP is running here s the proof

User · Answer

In most of cases it is data log problem  Follow the steps   i  Go to data folder of mysql      For xampp go to C  xampp mysql data    ii  Look for log file name like ib logfile0 and ib logfile1    iii  Create backup and delete those files   iv  Restart apache and mysql

User · Answer

In your PHP code you have set the incorrect port  this is what the code should be   lt  php   dbhost    localhost    dbuser    root    dbpass        db        test db13     The port in your code is set to 3360 when it should be 3306  however as this is the default port  you don t need to specify

User · Answer

You have entered wrong port number 3360 instead of 3306  You dont need to write database port number if you are using daefault  3306 in case of MySQL

User · Answer

For those who came here looking for the answer and didnt type 3306 wrong   If like myself  you have wasted hours with no luck searching for this answer  then possibly this may help   If you are seeing this   HY000 2002   No connection could be made because the target machine actively refused it  Then my understanding is that it cant connect for one of the following below  Now which    1  is your wamp  mamp  etc icon GREEN  Either way  right-click the icon --  click tools --  test both the port used for Apache  typically 80  and for Mariadb  3307    Should say  It is correct  for both   2  Error comes from a  php file  So  check your dbconnect php    lt  php  servername    localhost    username    your username    password    your pw    dbname    your dbname    port    3307     gt    Is your setup correct  Does your user exist  Do they have rights  Does port match the tested port in 1   Doesn t have to be 3307 and user can be root  You can also left click the green icon --  click MariaDB and view used port as shown in the image below  All good  Positive  ok     3  Error comes when you login to phpmyadmin  So  check your my ini     Open my ini by left clicking the green icon --  click MariaDB --     The following options will be passed to all MariaDB clients  client   password   your password port   3307 socket    tmp mariadb sock    Here follows entries for some specific programs    The MariaDB server  wampmariadb64   skip-grant-tables port   3307 socket    tmp mariadb sock   Make sure the ports match the port MariaDB is being testing on  Then finally     mysqld  port   3307   At the bottom of my ini  make sure this port matches as well   4  1-3 done  restart your WAMP and cross your fingers

User · Answer

I finally found a solution  I wasted hours just trying to figure what this issue was  I tried deleting all those files suggested above and it didn t work for me  I tried adding new inbound rules to firewall for myslqd exe and it didn t work  The thing that is causing this error is MySQL port is misconfigured and the fix was really simple  if you are using Wamp or Xampp go to  Main Folder Bin mysql mysql  and find a file named my ini  Open my ini file press CTRL   F and inside it search for PORT and change whatever value of port to - 3306 and save file   After that go to Wamp icon at the bottom of the taskbar  system tray  and left click choose mysql option and click  test port 3306 used  and see if it gives you any error  you can also click use other port other than whatever is shown there  and port 3306   Goodluck  if it works comment   enter image description here

User · Answer

If you are using a non default MySQL port number then do the following   Stop your xampp wamp etc session Set port number used by MySQL in config inc php under the phpMyAdmin folder  For example if your MySQL port number is 33747 then paste the following  cfg  Servers    i   port     33747   under the    Authentication type and info     section  Restart Apache and MySQL servers

User · Answer

It is just a matter of changing the port user by mysql 3308 to 3306 Just right click on wamp- gt  select tools under Port Used By mysql 3308 clcik on  quot use a port other than 3308 In the text port text box appear   type 3306 and save  Wait until the wampserver restarts and get green  Now run your PHP code  It will work  That s it - Good Luck

User · Answer

If you look at your XAMPP Control Panel  it s clearly stated that the port to the MySQL server is 3306 - you provided 3360  The 3306 is default  and thus doesn t need to be specified  Even so  the 5th parameter of mysqli connect   is the port  which is where it should be specified    You could just remove the port specification altogether  as you re using the default port  making it    dbhost    localhost    dbuser    root    dbpass        db        test db13     References   mysqli connect   Standard connection of MySQL

[php] mysqli_connect(): (HY000/2002): No connection could be made because the target machine actively refused it

Examples related to php

Examples related to mysqli

Examples related to xampp