AIL PROTECTED]
> Sent: Monday, October 11, 2004 7:30 AM
> To: [EMAIL PROTECTED]
> Subject: Read-Only DB User
>
> Hi All,
>I'm sorry to access such a basic question, but I
> couldn't find a specific answer to it in the mysql
> manual pages.
>
>The questi
--Original Message-
From: Lee Zelyck [mailto:[EMAIL PROTECTED]
Sent: Monday, October 11, 2004 7:30 AM
To: [EMAIL PROTECTED]
Subject: Read-Only DB User
Hi All,
I'm sorry to access such a basic question, but I
couldn't find a specific answer to it in the mysql
manual pages.
The qu
Thanks James!
The actual command that worked for me was as
follows:
mysql> GRANT SELECT ON db.* TO [EMAIL PROTECTED]
IDENTIFIED BY '2user3';
Query OK, 0 rows affected (0.09 sec)
I receieved errors while trying to include the
'PASSWORD' option, as that seemed to be wanting a the
password in hex
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'
Hi All,
I'm sorry to access such a basic question, but I
couldn't find a specific answer to it in the mysql
manual pages.
The question is, how would someone create a basic
read-only user for a single db? I just intend for it
to be used by a script to validate data in the db
itself.
Anyw