Does anyone know what command in mysql I need to run to give a user access to ONLY read/select ALL the databases?

Mike

Originally posted by Michael
Does anyone know what command in mysql I need to run to give a user access to ONLY read/select ALL the databases?

Mike

Just create the user, and give him a Y in the global SELECT privilege (in the mysql.user table).

Remember to do a FLUSH PRIVILEGES afterwards.

--
Jens Kristian Søgaard, Mermaid Consulting I/S,
jens@mermaidconsulting.dk,
http://www.mermaidconsulting.com/
http://www.raqsupport.net/