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 > '<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 command > > Anil > DBA > > -----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 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] > > -- Benjamin Arai http://www.cs.ucr.edu/~barai [EMAIL PROTECTED] -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
