read only access to a MySQL database

[dbonino]

Dear friends:

How do I enable a MySQL database for anonymous read only access from my site? Where can I find information about this?

I´ll explain further this issue: I simply want that any visitor to my site can access in read only fashion to the database that drives my Web, without MySQL asks for any user ID or password.

Thanks you all.

Diego

[alemcherry]

You can create mysql users with just the required rights. Link users to phpmyadmin, either with hardcoded user/pass(with just enough rights) or login info passed in the format http://user:pass@yoursite.com/phpmyadmin/

This should work, but I am not sure if it is the right approcah. ideally you need a custom php script to read and display the values to the user in a more user friendly way. Most users may get confused by phpmyadmin interface.