what is the exact command/query to flush privileges? using mysql client or
mysqladmin?
----- Original Message -----
From: Ray Parish <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Monday, November 27, 2000 7:57 PM
Subject: Re: mysql - granting rights to another pc
> Did you flush privileges?
>
> Ray Parish
>
> ----- Original Message -----
> From: "Corisen" <[EMAIL PROTECTED]>
> To: <[EMAIL PROTECTED]>
> Sent: Monday, November 27, 2000 3:16 AM
> Subject: mysql - granting rights to another pc
>
>
> > i've granted rights to another machine using the following query in
mysql
> > client (logged in as root): "grant all privileges on mydatabase to
> > [EMAIL PROTECTED] identified by 'password';"
> >
> > when i change database to "use mysql", i saw the newly granted host with
> all
> > "N" for all privileges columns. i then proceed to change all the "N" to
> "Y".
> >
> > next, i login from my other pc using
> > "mysql -hmysql.company.com -uroot -ppassword". but when i issue the
> command
> > "use mydatabase" and "show tables", it show empty set. i'm able to use
the
> > database but not able to see the tables.
> >
> > pls advise what should be the correct procedure to grant rights to
another
> > pc?
> >
> > thanks.
> >
> >
> >
> > _______________________________________________
> > Redhat-list mailing list
> > [EMAIL PROTECTED]
> > https://listman.redhat.com/mailman/listinfo/redhat-list
> >
>
>
>
> _______________________________________________
> Redhat-list mailing list
> [EMAIL PROTECTED]
> https://listman.redhat.com/mailman/listinfo/redhat-list
>
_______________________________________________
Redhat-list mailing list
[EMAIL PROTECTED]
https://listman.redhat.com/mailman/listinfo/redhat-list
