I need some help suggesting an elegant way of doing something.
I'm currently in the planning phase of a media management solution that comes in two parts; The administration website, and the deployment website. What I'm considering doing is, at the time a member signs up for an account, I create a database user for that account. This way when a member associates a deployment website (one to many) I can allow connections from the host(s) defined.
So the important thing I need to know before I go down this road is: Is there a cap to the number of users a MySQL database can have? Also, is this the most effective way of allowing controlled external access to my database?