Up next in 10
How to fix phpMyAdmin MySQL Shutdown Unexpectedly Error in PHP XAMPP Apache Server in Browser
59 views
Jun 3, 2025
Get the full source code of application here: Watch My Visual Studio Code IDE Setup Video For Fonts,Themes & Extensions https://youtu.be/Bon8Pm1gbX8 Hi Join the official discord server to resolve doubts here: https://discord.gg/cRnjhk6nzW Visit my Online Free Media Tool Website https://freemediatools.com/ Buy Premium Scripts and Apps Here: https://procodestore.com/
View Video Transcript
0:00
uh hello guys uh welcome to this video
0:02
So in this video I will show you how to
0:04
fix this error message of uh PHP admin
0:07
Uh basically showing that port number is
0:09
already in use PHP admin is actually
0:13
part of this exam control panel which is
0:15
actually comes with the Apache server
0:18
for PHP and this is actually your MySQL
0:21
database as well This is PHP and my
0:24
admin right here So right if I basically
0:28
click on the start button you will see
0:31
it will show this error message to me
0:33
that uh my SQL shutdown unexpectedly
0:36
this may due to a block port missing
0:38
dependencies So basically what is
0:41
happening right here uh my SQL run on
0:43
this port number which is
0:45
3306 and on this port number I'm already
0:48
running this application of NodeJS If
0:51
you see server is running on this port
0:54
number 3306 So that's the port number
0:56
that this MySQL PHP MyAdmin uses So now
1:00
to fix this uh I will show you a
1:03
solution The first solution is either
1:05
you basically stop the application which
1:07
is running on that port number 3306 or
1:10
you can actually change the port number
1:12
as well So to follow that you need to
1:15
click on this config button that you see
1:17
right here and right here you need to go
1:19
to this file Simply click open it inside
1:23
the notepad And here inside Ctrl+ F just
1:27
search for
1:28
port and uh right here you will see this
1:32
port
1:33
number Uh by default it uses this port
1:36
number which is 3306 and you just need
1:39
to change to any port number Let's
1:41
suppose I change this to
1:43
43 06 So just make sure that port number
1:46
is not in use So let me choose a
1:49
different port number 4306 And again you
1:52
need to replace it right here as well So
1:55
there is two locations you need to
1:56
replace This is a second location So
1:59
just make it
2:01
4306 And just now save this file
2:04
here And uh after that you just need to
2:09
restart your Apache server Just
2:13
start And uh now if you see again it is
2:17
saying that uh problem detected port
2:19
3306 and used by this node application
2:23
So one more thing you need to do you
2:25
need to go to the C directory where uh
2:28
exam is located So this is your exam
2:31
folder If you see just go to this folder
2:34
and right here you will see this folder
2:36
PHP myadmin So simply you need to go to
2:39
this folder and right inside this folder
2:42
you will find out this file here which
2:44
is
2:45
config Inc This is a file that you need
2:48
to edit Simply open this file inside
2:51
your uh visual studio And uh right here
2:55
if you
2:56
see authentication type this is actually
2:59
the section So here you need to add this
3:02
uh one more field here which will be
3:04
your port
3:06
number Right here you add
3:10
this same port number 4306 and just
3:14
change
3:15
this to port So just replace this just
3:20
add this field right here after this
3:22
field right here on you can see it will
3:25
be there right here in the
3:27
authentication type and info Just add
3:30
this dollar cfg servers All this will be
3:34
the same And right here just replace
3:35
port and whatever is your port number So
3:39
4306 And just save this file here I've
3:41
already autos save enabled And once
3:44
again just restart your
3:46
server and again click the start
3:49
button So now what happens you will see
3:53
your
3:55
uh now the my SQL is already running
3:59
right here So now you can go to the
4:01
admin section localhost PHP myadmin So
4:04
you will be able to run your now you can
4:07
see it has started successfully on this
4:09
port number which is 4306 So now we have
4:13
successfully changed and right here you
4:15
will
4:17
see here you need to replace uh the
4:20
login details So just replace the port
4:26
uh username and the login
4:31
details So it is saying allow no
4:34
password So there will be this field
4:36
here allow no
4:38
password If you
4:42
see I think there is this field that it
4:45
is talking about Oh sorry We missed this
4:48
uh semicolon guys So that's why this
4:50
error is there Just make sure in PHP you
4:54
put this semicolon because if you don't
4:56
put the semicolon then it will not read
4:58
the line That's why it was uh creating
5:02
that problem right here Just put the
5:04
semicolon right here
5:07
Just put the semicolon and again restart
5:10
your
5:11
machine and again
5:14
start So now you will see it will start
5:17
this uh at
5:20
4306 And if you uh go to this PHP
5:24
myadmin you will see your database will
5:27
be now you can see you can easily access
5:29
your database right here You can create
5:31
databases tables as well So this is the
5:34
way by which you can solve this problem
5:36
If the port number is already in use you
5:39
can change that port number to any port
5:41
number of your choice that I showed you
5:43
step by step So in this way you can fix
5:46
this problem and if your problem is
5:48
solved then please hit that like button
5:50
Also comment on this video so that other
5:52
people can also see and also check out
5:55
my website
5:57
freemediatools.com which contains
5:59
thousands of tools regarding audio video
6:01
and image And I will be seeing you in
6:03
the next
#Programming
#Software