Run "SELECT * FROM user;" in the mysql database. All of the options
are obvious.
On Mon, 11 Oct 2004 19:28:49 +0530, Anil Doppalapudi
<[EMAIL PROTECTED]> wrote:
> First connect to mysql as root user and issue the following command
>
> grant select on .* to @ identified by
> '';
> flush privileg
First connect to mysql as root user and issue the following command
grant select on .* to @ identified by
'';
flush privileges;
it will grant only select privilege to the newly created user on database
and he can only connect from the ipaddress specified in command
Anil
DBA
-Original Mess
Lee,
On the MySQL side:
GRANT SELECT ON db.* TO user@'host' IDENTIFIED BY
PASSWORD 'password';
This will give 'user' from 'host' SELECT privileges to
all tables on 'db' (db.*).
http://dev.mysql.com/doc/mysql/en/GRANT.html
HTH,
James
--- Lee Zelyck <[EMAIL PROTECTED]> wrote:
> Hi All,
>I'
