Max users per database

[Udayakiran]

1. Is there any limit on the maximum number of users that can be created per database?
2. Is there any host that enforces such a rule?
I'm a complete noob to MySQL or databases or even forums... And your answers would change the entire structure of my project... Tried googling, but couldn't find anything... Hoping you ppl could help...

[entrecon]

Why do you need so many users? In most cases you create a user for your scripts and that user/password combination is what all of your scripts use to access the database.

I don't use MySQL alot, but I have never found need to create more than 1 or two users.

[vojoudi]

Hi,

These are the limitations of MySQL server in Powweb. I suppose it is helpful for you.

Question/Problem
Configuring: MySQL connections and query limits

Answer/Solution
Query limit is the maximum number of database actions performed in one hour by a specific user. Note that a user can have multiple concurrent MySQL connections, in which case the sum of all database actions for all connections cannot exceed the given limit.
The maximum number of concurrent MySQL connections per user is 10.
The maximum number of database queries per user is 50,000/hr.

regards,
Vojoudi

[YvetteKuhns]

The maximum number of database queries per user is 50,000/hr.

See updated number:

Im going to correct myself. The limit is 75,000 queries per hour.