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 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. > > Anyway, if anyone can provide a lean and concise > statement that will provide this, it would be very > much appreciated. > > Thanks! > Lee > > __________________________________________________ > Do You Yahoo!? > Tired of spam? Yahoo! Mail has the best spam > protection around > http://mail.yahoo.com > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/[EMAIL PROTECTED] > > -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
