I could write the statement for you if you could answer these three
things:
1) which user account would you like to modify the permissions of.
2) which database are you granting access to
3) what permissions do you want the user account of 1) to have on the
database of 2)
Respectfully,
Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
"Yong Wang" <[EMAIL PROTECTED]> wrote on 08/27/2004 11:38:31 AM:
> Hi, Shawn:
> Thank you very much for you point out the privileges problem. I
> just read the mysql document.
> There are several privilege level, global, database, table, column. I
> guess I only need do in global lelvel.
> We have three databases, two exist before and work fine. Could you
> please give me an example how to use
> grant command ? I only add one database to an existing username (with
> oow databses before) ? Do I have to
> use revoke command . I need to be very careful not screw up the
> existing databases.
> Thanks a lot.
>
>Yong
>
>
> >>> <[EMAIL PROTECTED]> 2004-8-25 15:00:25 >>>
> If you do not use the GRANT, REVOKE, and DROP USER statements to create
>
> and destroy user accounts, you must manually FLUSH PRIVILEGES. It's
> all
> documented in the manual:
>
> http://dev.mysql.com/doc/mysql/en/GRANT.html
>
> and in even more detail here:
>
> http://dev.mysql.com/doc/mysql/en/User_Account_Management.html
>
> Shawn Green
> Database Administrator
> Unimin Corporation - Spruce Pine
>
> "Yong Wang" <[EMAIL PROTECTED]> wrote on 08/24/2004 03:15:39
> PM:
>
> > Hi, all:
> > I use root login to create a new databse in the existing
> server.
> > Then I use the existing user name in the mysql user table as user
> name,
> > add the database and username .. info into mysql db table. Then
> > mysqladmin to load the table. When I login the database using the
> > existing user name, I
> > only can see previously existing database without seeing the new
> added
> > database. What is the problem ?
> > Thanks a lot.
> >
> > Yong
> >
> >
> >
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe:
> http://lists.mysql.com/[EMAIL PROTECTED]
> >
