How to connect to Mysql database through windows command line (cmd)!

Access your databases through command line, instead of user graphical user interface.

---

Closed Caption:

hello youtube today i'm going to show
you how to use my secret base on command
line and we are also going to look how
to connect the database through command
line
CMD after that we are going to create a
database through command line when you
install some this program here
it's normally create the beam for them
that mean for the has my sequel database
and the most demonstrate that we should
go to the gym for by clicking computer
then c drive on the c drive
we got to Tom from we go to my escort
and form a square
we got the ring for dinner and he is my
is for little bits
the program so I threw a command-line
CMD we have to click and write CMD and
change to that being directory which is
CD back / then CD zom and we we can
check what is inside some florida by
typing the bhayera as a director and
this all fries or folders inside some
and from some you're going to to my
escort Florida
so type CD my s4 and the era that we
check why inside my mysql folder and we
can see there is being here then we
change again change the record to be and
he said being in check what's inside
beam and so there are a lot of fires
that ends with DX e extinction but we
are interested on my s4 e x e so now we
need to connect to database so we type
my is to our and user by default route
then password host
host you have to option either even
Taiwan to 7.0 plus 0.1 which is
perfectly fine
or you could type localhost for my case
I'm going to use localhost then press
ENTER and the just prompt you to type of
process for my case I don't have a
password so enter again but i don't
remember the past so I have to check
from the start
the zom-- control panel and we have a
project mask we're so we start all a
process server and and my s4 from there
you go to the browser then you type a
lot of host-type caliber host and like a
host
and we can access to our some server and
you go to PHP my admin on a PHP myadmin
you
you can see these are all my data is the
list of my database
here have a couple number of databases
but i'm not interested to this step is
I'm just I just want to use CMD control
that uses here or uses it seems on any
local host password know all privileged
privileged
now I thought that to have said the
password and the way you said the past
is here you give you can uncheck you
remove all these privileged from users
or you can you could just keep your
privilege to select insert update delete
create out
grand to this for demonstration
destruction data down here
you have posted so you type
no person then go
ok now if we try again come back here
and we ask you the same command now it
has just go through
and as you already connected to the lab
is first we need to look this database
here I'll show you through this command
line so just type show that a business &
7 : same column this is a very important
to remember that issue always put some
column then enter and these are the list
of databases i have and what I'm going
to do now is to create the database in
New that is so just type create database
name users
oh let's give it to them
maybe the shop database and remember to
put some column if you don't percent
column
this is what will happen that's what
happened so if you type some column then
it executes the command so query ok
one affected so we can now say show that
database or the name of the database
which is sharp and we have the same
column and you have an error message
that's chicken - that correspond to
okay i think that was wrong command not
show shop should be used shop sharp and
that i was sent changed
you mean it has changed to shop if we
type show tables
I am to set which means we don't have
any database and it
tables inside our show cannabis the next
tutorial we are going to talk about how
to create tables and please guys
subscribe and click like