Creating users with limited privileges

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

Moderators: macek, egami, gesf

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


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: 266
Joined: Tue Apr 08, 2003 5:18 am
Location: Ottawa, Canada

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>


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

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 0 guests