[RESOLVED] Changing Privileges Via PHP Admin

[Nightwalker83]

I was wondering if anyone here knows where online I can find an easy to understand explanation to changing privileges in PHP Admin. I read through the documention listed in PHP Admin but it doesn't mention what the user types are or the different hosts.

Edit:

The reason I'm asking is because kfcSmitty mentioned in another thread that one should avoid allowing all users access to the root directory.

Create a user and give them access to the databases.

Users should never be using root access to access your databases. Limiting them to the basics of what they need is best.

If you have phpMyAdmin, it has a fairly simple interface to achieve this.

[penagate]

I think you meant to post this as a new thread... so I've made it so.

[Nightwalker83]

Yeah, I was originally going to post it as a new thread but I didn't know if what I was asking was separate question or followed on if the thread I started before.

[kfcSmitty]

Basically, the privileges are what you want to allow the user to do, and the host is where you want the user to be able to connect from.

Good practice only allows root access from 127.0.0.1/localhost.

So when creating a new user you

1. Set the username to whatever you want
2. Set the host to whoever you want to allow to connect (IE internal addresses only, localhost. Wildcard is &#37
3. Create or generate a password
4. If you are creating a database for this particular user, they give you a handy tool to grant all privs.
5. Then add all the privileges to the user you want.

If you have a user that only needs to pull data, you would set them to "Select" only on under the "Data" heading.

If you wanted a user to be able to select, update or insert, then you would select those 3 options.

I tried to find a tutorial through Google, but only found people asking questions and people suggesting running mysql commands to handle what they need.

[Nightwalker83]

Ah, I was thinking there was group option where you could place each user if you want to make them an admin, etc! Basically, I thought you could just select a user group from a drop-down box.