Re: [COMP] mysql....

James Gosnell wrote:

> how do I grant a user certain privileges for a specific table? I'm
> having trouble doing it. so far I have something like: GRANT create ON
> news TO president

I suggest you read the manual(s) at mysql.net.

The syntax, though, should be:

GRANT <permission list> ON databasename.tablename TO username@hostname
IDENTIFIED BY "<password>"

hostname is generally replaced with: "%" as a wildcard, to allow him to
connect from anywhere.  tablename can be *, if you want him to have
access to all tables in that DB.

John





========================================
Avenir Web's Computers Mailing List

List Modes, Subscription, and General Info:
Go to http://avenir.dhs.org/mailing.html
List Archives: http://avenir.dhs.org/archives/
Administrative Contact: webmaster@xxxxxxxxxxxxxx

Get computer help: http://avenir.dhs.org
========================================

Other related posts: