0

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?

2
Contributors
3
Replies
4
Views
9 Years
Discussion Span
Last Post by mwasif
0

Is there a cap to the number of users a MySQL database can have?

I never heard of that. But there is a limit of maximum concurrent connections and maximum connections per user limit which can be changed in my.cnf with the configuration variables max_connections and max_user_connections.

0

Right, I'm aware of the connection and concurrent connection limits, I just wasn't aware whether there is a cap on users created. Couldn't find any info in the manual about it.

0

Couldn't find any info in the manual about it.

Then it can be assumed that there is no limit :)

This topic has been dead for over six months. Start a new discussion instead.
Have something to contribute to this discussion? Please be thoughtful, detailed and courteous, and be sure to adhere to our posting rules.