First connect to mysql as root user and issue the following command
grant select on databasename.* to username@ipaddress identified by
'passwd';
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
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 databasename.* to username@ipaddress identified by
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'm