PHP mySQL, creating DB for multiple users?

Question

Can I restrict access to certain tables within my SQL database, rather than have all users having access to everything?
Is this done at PHP level or on the SQL database? or could it be both?

Answer 1

This is typically done at PHP level.

Typically you have an application user (with access control handled by the application,) and a database user (with access control handled by the database)

Your database user probably doesn't change (the information used in the connect command)

Answer 2

They can change their IP yes or it can automatically change. You can simple use session data as a means of stopping them voting until the session runs out however it would be much more prudent to make a login script as to have proper accounting to then track what people have and haven't voted for. You can also stores these session keys and reassign them when a particular person logs bag in but for simplicity sake just make it so one session needs to end before voting again and stop the same IP voting twice.