Now that we have Aposhian stalled we can go ahead and install essential services including my rescue
Well p p and p p by admin.
We'll start with my as well.
My school is a database management system.
It organizes and provides access to databases where you can store information a common example is storing
customer information.
If you operate an e-commerce site to install my ask you will take the following command.
Now if you're logged into the root account you don't have to type in pseudo But I'll just keep it there
because I'm copying and pasting the command lines to save a bit of time.
So sudo apt install my s to all.
Gosh server.
And press enter.
So at the first prompt which just indicates that it's going to take 162 megabytes of additional disk
space which we're fine with.
Type in Y and press enter.
So again you'll see the progress bar appears and it should go by fairly quickly.
When the installation is complete we can secure our my Estival installation.
This is a good practice and it just means getting rid of some of the dangerous default settings that
can be a security risk to your database server so to do so.
Type in the following command.
And press enter.
So now go through the various prompts to complete this installation.
The first one is it's asking if we want to use the validate password plug in.
This can be used to enhance password security by default.
So any time you want to set a password it will force you to stick to a certain format for the password
secure format.
It's great to use this if you're comfortable with Majeski well.
Also if you don't intend on using many plug ins for example Wordpress or if you're going to be installing
ph p.m.-I admin there can be certain things that conflict with this particular plug in.
So for this purpose we'll go ahead and type in no.
And press enter.
So now we'll have to enter a password for mine as well.
This is to connect to your database server.
So again just make sure that it's something secure but something you can remember as well.
If you pick a very complicated password Do remember to write it down and store it somewhere safe.
I'll just go ahead and re-enter it and press enter.
You'll try that one more time
K so the next prompt here is asking about anonymous users.
It says by default to my usual installation has an anonymous user allowing anyone to log into my eschew
all without having to have a user account created for them.
This is intended only for testing and to make the installation go a bit smoother.
You should remove that you should remove them before moving into a production environment.
So even though we're just setting this up the ultimate goal is to move into production.
So we'll go ahead and select YES to remove the anonymous user and press ENTER
OK the next thing is to do we want to disallow route log in remotely.
Typically you only want to allow the local host to log in as root.
This is a this is a great practice for security and so when you go ahead and select YES disallow route
log in so remote users can not log in as root and press enter
by default my escrowed comes with a database named test that anyone can access.
This is also intended only for testing and should be removed before moving into a production environment.
So again we don't need this test database or go ahead and type Y and press enter.
Case The next step here is reloading the privilege tables.
And this will ensure that all the changes we just made take effect immediately.
So TDY and press enter and there it is we're all done with setting up my rescue will.
One last item that remains here is to change our authentication method that my tool uses to authenticate
the root user although the default authentication method does offer some additional security.
It conflicts with other tools that we need to install later such as HP my admin.
So for this reason we'll need to switch our authentication method from off underscore socket to my rescue
Well native password and you'll understand how this works in just a second this basically means we can
use a regular password to authenticate.
Now to do this you're going to start by typing the following command.
So now we've opened up my ask you will.
Now let's go ahead and check which authentication method each of our might as we'll use your accounts
uses to authenticate to do that type in the following command.
And press enter
that table that you see here does confirm that the root user does in fact connect with auth socket to
change this.
We need to type a command.
So go ahead and paste in the command.
But there is a perimeter will need to change.
So this is the command here.
OK so we want to alter the authentication method for root at localhost.
We want to identify with my rescue all need of password.
Now you need to change over here where it says password you need to type in the password you want to
authenticate with.
OK so I've entered the password.
I want to authenticate with it then go ahead and press enter.
So you see this message query.
OK.
And that tells you that the command was executed successfully.
Now we'll need to run the flush privileges command and this tells the server to reload the grant tables
and put your new changes into effect.
So this is what the command is.
Flush privileges and press enter.
Now that we've completed these steps let's confirm that the root user no longer authenticates using
the office socket plug in.
So take the following command
and press enter.
We can confirm in this table that the root user.
Now authenticates with my Escudo native password and no longer with the office socket plug in.