Creating users with limited privileges

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

Moderators: egami, macek, gesf

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

Tue Oct 28, 2003 12:39 pm


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?


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

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>


User avatar
Posts: 2257
Joined: Sat Jul 05, 2003 1:18 pm
Location: A bunk in the back

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.

Post Reply