Users and Groups in MySQL

Question

Has anyone seen a plugin for MySQL that will allow you to set up users and groups for access where you can have a user who can login, create db etc but ONLY see the stuff that belongs to them?

I'm speaking of a shared server where multiple people can use the same instance but be fully separated just like a file share.

Answer 1

MySQL don't support user groups

but it has all features for privileges like for tables, views and even columns, you can even restrict the access of a colum of a view to a user and make a difference if that same user comes from ip-address A or ip-address B

not sure if you find any RDBMS which is more flexible than mysql.