Passwords

[Raraken]

Sorry, I have a few questions. ;)
Thanks to anyone who awnsers em, or even a couple! Please note: PHP applies to all these questions.

1. I know in mySql you need a username and a password to access a database. However, can you set a username and password (or even just a password) to access a table or a row?

2. Is there a way you can set a database so you can only add data?

3. is there a way I can have people access values to a database (php) without using a password?

4. is there a way to set up diffrent users (with diffrent permissions) for accessing mySQL data?

5. Any comments about how I can get alot of people accessing a database, from diffrent websites, with keeping i as secure as possible?

[raf]

1. I know in mySql you need a username and a password to access a database. However, can you set a username and password (or even just a password) to access a table or a row?
I believe that table-level is the lowest you can get. Just check out the section about setting userpermissions
http://dev.mysql.com/doc/mysql/en/Adding_users.html
2. Is there a way you can set a database so you can only add data?
Yes. Just give the accont only insert permission on that db
3. is there a way I can have people access values to a database (php) without using a password?
You can create an account and don't set a php for it.
Or doy you mean 'let people acces them through a php-application'?

4. is there a way to set up diffrent users (with diffrent permissions) for accessing mySQL data?
Sure. Check out the section on setting permission

5. Any comments about how I can get alot of people accessing a database, from diffrent websites, with keeping i as secure as possible?
That's a bit to broad to handle here.

[Raraken]

I was asking those questions to see if somthing I want to do is feasable overall. (pretty much, if one of them would work, then I could do it)

But yes, Many Many thank you's!