Re: bout mysql
| From: | Vojtech Dvorak | Date: | Tue, 13 Mar 2001 15:26:03 +0000 |
| Subject: | Re: bout mysql | ||
| References: | 1 | Groups: | php.db |
| Request: | Send a blank email to php-db+get-7401@lists.php.net to get a copy of this message | ||
> can i grant a user to access two database in mySQL?
Yes just use multiple...
GRANT PRIVILEGES ON (or database you want to grant) TO user@"%" IDENTIFIED
BY 'user_pass'
> does mysql has function DECODE like oracle ?
don't know sorry
> how can i know which table or database that user can access if i am
> admin ?
Just check content of mysql database tables "user" etc.
Than RTFM.
Regards
Vojtech