uh hello guys uh welcome to this video
So in this video I will show you how to
fix this error message of uh PHP admin
Uh basically showing that port number is
already in use PHP admin is actually
part of this exam control panel which is
actually comes with the Apache server
for PHP and this is actually your MySQL
database as well This is PHP and my
admin right here So right if I basically
click on the start button you will see
it will show this error message to me
that uh my SQL shutdown unexpectedly
this may due to a block port missing
dependencies So basically what is
happening right here uh my SQL run on
this port number which is
3306 and on this port number I'm already
running this application of NodeJS If
you see server is running on this port
number 3306 So that's the port number
that this MySQL PHP MyAdmin uses So now
to fix this uh I will show you a
solution The first solution is either
you basically stop the application which
is running on that port number 3306 or
you can actually change the port number
as well So to follow that you need to
click on this config button that you see
right here and right here you need to go
to this file Simply click open it inside
the notepad And here inside Ctrl+ F just
search for
port and uh right here you will see this
port
number Uh by default it uses this port
number which is 3306 and you just need
to change to any port number Let's
suppose I change this to
43 06 So just make sure that port number
is not in use So let me choose a
different port number 4306 And again you
need to replace it right here as well So
there is two locations you need to
replace This is a second location So
just make it
4306 And just now save this file
here And uh after that you just need to
restart your Apache server Just
start And uh now if you see again it is
saying that uh problem detected port
3306 and used by this node application
So one more thing you need to do you
need to go to the C directory where uh
exam is located So this is your exam
folder If you see just go to this folder
and right here you will see this folder
PHP myadmin So simply you need to go to
this folder and right inside this folder
you will find out this file here which
is
config Inc This is a file that you need
to edit Simply open this file inside
your uh visual studio And uh right here
if you
see authentication type this is actually
the section So here you need to add this
uh one more field here which will be
your port
number Right here you add
this same port number 4306 and just
change
this to port So just replace this just
add this field right here after this
field right here on you can see it will
be there right here in the
authentication type and info Just add
this dollar cfg servers All this will be
the same And right here just replace
port and whatever is your port number So
4306 And just save this file here I've
already autos save enabled And once
again just restart your
server and again click the start
button So now what happens you will see
your
uh now the my SQL is already running
right here So now you can go to the
admin section localhost PHP myadmin So
you will be able to run your now you can
see it has started successfully on this
port number which is 4306 So now we have
successfully changed and right here you
will
see here you need to replace uh the
login details So just replace the port
uh username and the login
details So it is saying allow no
password So there will be this field
here allow no
password If you
see I think there is this field that it
is talking about Oh sorry We missed this
uh semicolon guys So that's why this
error is there Just make sure in PHP you
put this semicolon because if you don't
put the semicolon then it will not read
the line That's why it was uh creating
that problem right here Just put the
semicolon right here
Just put the semicolon and again restart
your
machine and again
start So now you will see it will start
this uh at
4306 And if you uh go to this PHP
myadmin you will see your database will
be now you can see you can easily access
your database right here You can create
databases tables as well So this is the
way by which you can solve this problem
If the port number is already in use you
can change that port number to any port
number of your choice that I showed you
step by step So in this way you can fix
this problem and if your problem is
solved then please hit that like button
Also comment on this video so that other
people can also see and also check out
my website
freemediatools.com which contains
thousands of tools regarding audio video
and image And I will be seeing you in
the next