[FIXED] phpMyAdmin Error: No connection could be made because the target machine actively refused it

hello everyone in this video i will show you how to fix this error which may occur with phpmyadmin so the error is no connection could be made because the target machine actively refused it so this error means either mysql is not running or php my admin is using a different port number than the poor number of mysql so here we can see that mysql is using this port number 3307 which is not the default port number so the default port number is 3306 so to fix the error of phpmyadmin we have either to change this port number and to use the default port number or also we have to configure phpmyadmin to use this sport number so if you want to change this poor number and to use the default port number then you have first to stop mysql then you have to click on config then my.ini and here we need to find the mysql server and we need to change this port number and to use the default port number which is 3306 but in this video i will show you how to configure phpmyadmin to use this port number so we have just to click on config here then browse phpmyadmin and here we have to open this file it is called config.inc.php so this is the configuration file of phpmyadmin and we can see that phpmyadmin will connect using the root user and will not use any password so here we can see that we will connect to the mysql server which is available on the local machine but we can see that we don't have the configuration of the port number this means that phpmyadmin will use the default port number which is 3306 but because we are not using the default port number then we have to configure this poor number in this file so let's copy this line and let's paste it just here now let's change the key and let's write por then here let's write the port number of mysql which is 3307 now let's save this file and let's refresh the browser and this time we can see that we don't have the error anymore now i will show you how to use the default port number of mysql so here we need to stop mysql then let's click on config then my.ini then here let's change this value so it is under the mysql server so let's change the port number and let's use the default port number now let's save this file and let's close it now let's configure phpmyadmin so let's click on config then browse phpmyadmin then let's open this file and then we can delete this line because phpmyadmin will connect to the default port number which is 3306 now let's save this file now let's start the mysql service then let's go to phpmyadmin so let's click on admin so here we can see that we are connected to the database and we don't have the error anymore

Channel: BoostMyTool

Views: 109,422

Keywords:

Id: fU_HgdT_L8o

Length: 3min 57sec (237 seconds)

Published: Thu May 12 2022