M. Erickson writes:
> On Thu, 17 Feb 2000 sinisa@stripped wrote:
>
> > Please do not meddle directly with mysql privilege tables. Use GRANT /
> > REVOKE.
> >
> > Howerver, if you do already, then you have to flush privilege system !
> > Use mysqladmin or myqslgui for the purpose.
>
> How do I add users without meddling directly with the privileges? I
> thought inserting them into mysql.user was the only way...
>
> thx,
> /me
>
Hi!
Use standard SQL way. Use GRANT and REVOKE commands. They can grant
and reovke privileges on the global, database, table and column level.
Read a manual on the subject.
Regards,
Sinisa
+----------------------------------------------------------------------+
| TcX ____ __ _____ _____ ___ == mysql@stripped |
| /*/\*\/\*\ /*/ \*\ /*/ \*\ |*| Sinisa Milivojevic |
| /*/ /*/ /*/ \*\_ |*| |*||*| mailto:sinisa@stripped |
| /*/ /*/ /*/\*\/*/ \*\|*| |*||*| Larnaka, Cyprus |
| /*/ /*/ /*/\*\_/*/ \*\_/*/ |*|____ |
| ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^ |
| /*/ \*\ Developers Team |
+----------------------------------------------------------------------+
