When we connect to BHP my admin for the first time through the WAP menu we do so as the route might
as well user the route user has the highest level of administrative privileges that can be assigned
to your hp.
My admin configuration this means the route user can perform any action on any my as old database when
connected the route user can delete modify and create databases tables indexes among many other privileges.
By default the route user does not require a password to connect.
This can be dangerous especially if you have multiple users connecting to my ESC You will databases
on your server perhaps through a local network or even remotely.
You may only want to grant certain users access to certain databases.
Also you may want to assign specific privileges to different users.
For example user John can update records but not modify tables structure.
The first thing we need to do is to make sure we've assigned passwords to all our route users.
This will prevent any unauthorized access to my S2 all databases on your server as a root user.
To do so click the user's button in the top menu.
You should now see a listing of all your users.
If you haven't worked with HP my admin before you'll likely see three route users by default
you'll also see the word no in the password column for each user.
Mine is set to Yes because I've already assigned a password to each user.
You can see here that route users have all privileges granted.
This means they can perform any action on any my askew old database on your server to set a password
for each user.
Click the edit privileges button.
We'll start with the first one.
Now scroll down to the change password section.
Make sure to select a password option and enter your new password.
Then click the Go button
now repeat the exact same thing for the remaining two users
to keep it simple I've set each route user to the same password
so keep in mind that local host each one of these hosts are just another way of identifying your local
machine.
Once you've changed your password you won't be able to do anything inside BHP admin.
So if I click anywhere else you'll notice I get an error saying access denied for such and such user
the route user this is because I've changed my password and so have you.
You've created it for the first time and so what we need to do is we need to update our config.
Dot I NC dot HP file and in this file we specify the new password that we've assigned so we can log
back in if you're using web.
This file will be located at the in the directory shown on your screen.
So once you've open that file it looks like this
you're going to scroll down to this line here line 33.
You're going to have an empty area here.
I have my old password and I'm just going to change it to my new one
they'll make sure you save the file
and then just refresh your web browser and you can see that we're now connected again.