Creating users with limited privileges

How to use phpmyadmin.... phpmyadmin related arguments. Even phpMyAdmin issues

Moderators: macek, egami, gesf

ylkien
New php-forum User
New php-forum User
Posts: 28
Joined: Sat Dec 14, 2002 9:43 am

Creating users with limited privileges

Postby ylkien » Tue Oct 28, 2003 12:39 pm

Hi,

i was wondering whether i can create other users in my mysql account, whereby i limit thier access? I entered the "user" table in mysql database, and saw a lot of fields, like host, password, user, select_priv, insert_priv, etc.

What does all of these priv mean? How do i just create a user with a limited access to 1 database only?

Thanks.

liquedus
php-forum Active User
php-forum Active User
Posts: 266
Joined: Tue Apr 08, 2003 5:18 am
Location: Ottawa, Canada
Contact:

Postby liquedus » Tue Oct 28, 2003 1:03 pm

its sounds to me what you are looking for is the GRANTING of rights or

GRANT ALL ON <item> TO <user> IDENTIFIED BY <password>

:wink:

User avatar
swirlee
Moderator
Moderator
Posts: 2272
Joined: Sat Jul 05, 2003 1:18 pm
Location: A bunk in the back
Contact:

Postby swirlee » Tue Oct 28, 2003 1:15 pm

The documentation on GRANT and REVOKE is here, and there are lots of different options you can set on a per-user level.


Return to “phpMyAdmin”

Who is online

Users browsing this forum: No registered users and 1 guest