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
