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 installed process.

But if you're on a Mac or Linux system, make sure you 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 Lennox, and then if you're our Maculan IX makes 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 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 sequence dollar for Windows, and this is the all in one installed work that you can download.

So just click go to download page on 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, violets 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 would be a smaller download for us.

And if we click download, then we brought to this page were prompted data logging or sign up.

Or we could just skip all that and just start the download.

And from here we could just start the download by clicking Save and that'll download the installer.

And as soon as I was done being installed, just click on the Install it, Open it up and you may get prompted.

Toe.

Ask for permission.

Just click yes, to allow it permission.

It's many times is needed, and then it'll open up the installer for us.

Well, 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'll download with the developer install so we can click on Custom Click next, And from here we just go to the bicycle service section.

It's like the server that we want and pop it over.

There should only be one option for you and then in applications were going to do the same thing with my secret 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 installed 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, downloaded it in stolen.

We could 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 stand alone mode, since we just want individual sequel server and we don't wanna have any clustering, so just keep it selected on Stand Alone.

Click Next, and from here we want to make sure we select development Computer.

Which would 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, 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 eight.

It's saying that they're using a new hash inversion 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 could just leave that selected click next and here.

We need to give a password for our route user, which is the user 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 could 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 is not going to actually impact the performance of your computer.

So I recommend leaving this checked, just keeping this exactly defaulted as it is clicking next.

And then all we need to do is Click Execute, and it'll run all the steps that we told it to do in the earlier set up 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 could just start my sequel workbench after the setups complete, and if we click, finish and wait a little bit and my secret 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 were 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 could just say local server and then we want to use standard TCP I P, 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 we type in our password, click okay, and we hit test connection.

We should get a green light saying that the connection was successfully made and we just click, okay.

And here we go.

We connect to our server by double clicking on this and now we have my secret work bench 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 sickle server and my secret work bench together.

If you guys enjoyed the video, please make sure to leave it like down below and subscribe for similar content.

Also, make sure to check out my very next video, which is going to be on howto learn sequel in one video.

Thank you guys very much for watching.

Have a good day.