Granting table permissions to anonymous users

[MichaelHooker]

Newbie warning: please be gentle with me... I've never had to worry about permissions before, all my dbs have been single-user.

I want to set up a PHP/MySQL based website to display photos listed in a table, which any visitor can interrogate (read-only) without a username or password; <link removed> is the sort of thing I'm aiming at, if you want an example. My webspace provider has all the right stuff, and I can do the coding myself, once I've got my head around one basic question... All the books and guides I've looked at concentrate on how to limit permissions to specific logged-in users but I can't find anything about giving permissions to all.

It seems to me that the way to give everyone access is to hard-code a specific username@localhost and password into the PHP forms which access the database, having given that generic user the correct very limited permissions. But in the event that I get two or more visitors at the same time, will MySQL actually allow that, or will it insist that the "same" user can only perform one transaction at a time?

Or is there some other approach which works better?

Many thanks in advance

Michael

[Atli]

Hi Michael. Welcome to The Scripts!

If I'm reading this correctly, you want your PHP code to fetch this data from the MySQL database and display it on your website?

If so, you will never need more than a single MySQL user. All your PHP code can execute queries on your MySQL server using a single user, even if there are a million different visitors viewing your page at the same time.

P.S. I removed the link from your post, as all links to commercial webs are strictly forbidden by the Postin Guidelines.

[MichaelHooker]

Thanks very much.

Yes, you understand my question correctly, and it would seem that you're saying that my approach is the right one, which is comforting.

I think those of us who access the website URL I posted to look at and download for free the well over a million aircraft photos which we contribute gratis would be surprised that you classify them as a commercial site. They are first and foremost a portal/resource for enthusiasts.

Thanks again.

Michael

[Atli]

Yes, indeed, your approach is the right one.

I think those of us who access the website URL I posted to look at and download for free the well over a million aircraft photos which we contribute gratis would be surprised that you classify them as a commercial site. They are first and foremost a portal/resource for enthusiasts.

I use the term 'commercial' very loosely there. All links to other websites, with very few exceptions, are not allowed in the technical forums. Especially those who contain advertisements (tho I don't remember seeing any in at your URL), which will most of the time be classified as spam.