Need up to 30 seconds to load.
hello everyone in this video I'm going
to teach you how to install my sequel
server and my sequel workbench onto your
computer and then how to connect the two
together so you can access your local
server through my sequel workbench I'm
going to be doing this on Windows since
Windows has the most complicated install
process but if you're on a Mac or Linux
system make sure to check the
description where I included links on
where to install my sequel server and my
sequel workbench since it's much easier
to do on Mac and Linux and then if
you're on Mac and Linux make sure you
come back to the end of this video so
you can figure out how to connect your
sequel server to your sequel workbench
so to get started if you're on Windows
go to the link in the windows section of
the description and I will lead you to
this page where if you scroll down to
the bottom there's going to be a button
for my sequel installer for Windows and
this is the all-in-one installer that
you can download so just click the go-to
download page and when this loads you're
presented with two options of the
installers that you want to download the
first option is just a normal installer
that accesses the internet while it's
installing to download everything and
the second installer comes with
everything pre-installed and downloaded
so I'm just going to go with the first
option here because we don't actually
want everything that the Installer has
inside of it so this will be a smaller
download for us and if we click download
then we're out to this page where we're
prompted either login or signup or we
could just skip all that and just start
the download and from here we can just
start the download by clicking save and
that'll download the Installer and as
soon as that's done being installed you
just click on the installer to open it
up and you may get prompted to ask for
permission just click yes to allow it
permission as many times as needed and
then it'll open up the Installer for us
where we just have to accept the license
and then we're given these options for
how we want to install do we want to use
the default which is the developer
settings server only client only
absolutely everything or custom and in
our case we're going to go with a custom
install because we only want the server
and the workbench and we don't want any
of the extra stuff that will download
with the developer install so we can
click on custom click Next and from here
we just go to the my sequel server
section select the server that we want
and pop it over there should only be one
option for you and then in applications
we're going to do the same thing with my
sequel workbench and again there should
only be one option and just send that
over and that's everything that we need
to install if you want you can download
some samples and examples as well as
part of your install process but I'm not
going to do that from here just click
Next and then click execute to download
and install these and it may take a
while depending on your internet speed
and as soon as that's done downloading
and installing we can just click the
next button and from here we now need to
configure our sequel server so if we
click Next we just want to do standalone
mode since we just want individual
sequel server and we don't want to have
any clustering so just keep it selected
on standalone click Next and from here
we want to make sure we select
development computer which will mean
that my sequel server will take the
least amount of memory as possible from
our computer while it's running and then
leave all this other stuff defaulted
what it is this is just the port it'll
be connecting through and if you want to
open your firewall ports to be able to
access it from inside of your internal
network or outside just leave that
selected and click Next and from here
this is new for my sequel server 8 it's
saying that they're using a new hashing
version that's not supported with the
older my sequel version and in our case
we can use that new version of hashing
since we don't need to support an older
version of my sequel so we can just
leave that selected click Next and here
we need to give a password for our root
user which is the user that has access
to everything on our server so just give
it any password that you want and then
after you're done giving it a password
just click Next and then this is where
you have a few options to change here
you can start my sequel server on system
startup which is what I recommend doing
since it's much easier than manually
starting the server every time that you
turn off your computer and turn it back
on and it takes such little memory that
it's not going to actually impact the
performance of your computer so I
recommend leaving this checked and just
keeping this exactly defaulted as it is
clicking next and then all we need to do
is click execute and it will run all the
steps that we told it to do in the
earlier setup for configuring it and if
we just give it a little bit of time now
that that's done we can click finish and
from here just hit next and we have
everything finished so now we can just
start my sequel workbench after the
setup is complete and if we click finish
and wait a little bit and my sequel
workbench should open up now you may
already have a connection here if you
double-click on this and type in your
password you created earlier you are
able to connect to your server but if
you don't have this you'll need to
create a new connection so in order to
do that we just click this plus button
to create a new connection give it
whatever name we want we can just say
local server and then we want to use
standard tcp/ip which is what we
selected earlier we want to use the host
name here which is already our local
host port which is the default so if you
didn't change it in the install process
you'll use this port we have the root as
our user and then we just need to type
in the password here by clicking store
involved so if we type in our password
click OK and if we hit test connection
we should get a green light saying the
connection was successfully made and we
just click OK and here we go we can
connect to our server by double clicking
on this and now we have my sequel
workbench open and connected to our
server and we can run any commands that
we want to for example show databases
and if we run that you'll see that we
have all of our databases being shown
down here so that's how we know that we
are connected to our sequel server that
we just downloaded and that's all it
takes to set up my sequel server and my
sequel workbench together if you guys
enjoyed the video please make sure to
leave a like down below and subscribe
for similar content also make sure to
check out my very next video which is
going to be on how to learn sequel in
one video thank you guys very much for
watching
have a good day