[Solved] XAMPP mysql is not recognized as an internal and external command Error
Feb 12, 2025
Get the full source code of application here:
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/
Show More Show Less View Video Transcript
0:00
uh hello guys welcome to this video so
0:02
in this video I will show you how to fix
0:05
this error which comes if you type the
0:07
my SQL command in the terminal and it
0:10
actually tells you that it is not
0:13
recognized as a internal or external
0:15
command so basically this error comes
0:18
because you haven't uh linked your the
0:21
path where the MySQL is installed so
0:24
that it is not recognizable to use it in
0:26
the terminal so a simple fix to this
0:28
problem is that you need to go to your
0:30
environment
0:32
variable and add the path here so if you
0:35
search environment variable you need to
0:37
click on this button and uh and then you
0:40
need to register this path so just
0:43
select the system path
0:45
here so then click on the edit button
0:49
and here you need to add the path by
0:51
clicking the new button so paste the
0:53
path where my SQL is installed so in
0:56
this video I'm assuming that you have
0:58
installed my SQL uh
1:00
I am
1:01
just uh my SQL comes with examp exam is
1:05
a crossplatform PHP Apache server so you
1:09
can first of all install this if you
1:11
haven't downloaded this it's available
1:15
for every respective system so Windows
1:19
Linux Max so I have a Windows machine so
1:22
I will select this and click on download
1:24
64bit so it comes with the setup so as
1:28
soon as it is installed it is installed
1:31
in the default directory of C so after
1:33
installing you will see this exam exam
1:37
folder so this is the exe file so I
1:39
already installed
1:41
it so if you search inside your Start
1:46
program you will see exam control panel
1:49
so this is actually your Apache mySQL
1:53
database which comes right here you need
1:55
to click the start button to actually
1:57
start both these things and then
2:00
inside this examp folder you will see
2:04
this folder will be there examp inside
2:06
this folder we have this MySQL folder as
2:09
well so if you see this is actually the
2:11
MySQL folder and you need to enter in
2:15
the folder and then just copy this path
2:17
here this is exactly the path that we
2:20
need so simply right click copy this
2:22
path and then you need to go to your
2:24
environment variable and just add this
2:28
path like this
2:30
so after you add this path now it will
2:33
be accessible to the command line so if
2:35
you click okay okay and just you need to
2:38
restart the terminal here just again
2:40
open command line and enter the same
2:43
command which will be my
2:47
SQL so you just need to make the changes
2:57
here okay sorry we have made a mistake
2:59
here uh my SQL and then you also need to
3:03
go to the bin folder where the
3:04
executable is present so again go to the
3:06
bin folder and now copy this
3:09
path so just update that path now copy
3:13
this again go to the environment
3:20
variable and just change this and paste
3:23
the correct path here which includes the
3:26
bin as well where the executable is
3:28
present so then now click okay okay and
3:31
then you need to restart the terminal
3:34
and just type my SQL in the terminal so
3:37
if I type here you will see the command
3:39
is successful it is telling me that you
3:41
need to provide the username to login so
3:45
now as you all know in my SQL you need
3:47
to provide a username so the default
3:50
username is root so I will say Dash you
3:53
for the username root and you will be
3:56
logged in so you will see you are logged
3:58
in now you can create any database
4:02
tables so now to create a new database
4:05
we have a create database command so
4:08
create database and then you can create
4:12
a you just need to replace the name here
4:15
so after you create this you can see
4:18
the command is successful now we need to
4:20
use this database which is this one so
4:24
use and here we can create a table so
4:36
so we have the create table command so
4:38
you can give it a table
4:44
name so you can see that you can fix
4:46
that error so all these commands are
4:49
successful here so in this way you can
4:51
fix that error you just need to copy
4:54
that path here so make sure that you
4:55
have exam control B installed and then
4:58
after that just for follow the steps
5:00
which is there in this video and add
5:02
this path inside your environment
5:05
variable and then the problem will be
5:07
fixed so thank you very much for
5:09
watching this video and also visit my
5:12
website as well free mediat tools.com uh
5:15
which contains thousands of tools
5:17
regarding audio video and image and I
5:20
will be seeing you in the next video
#Computer Education
