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
