CODEWITHSUNDEEP
mysql
Lewis
Lewis

Reputation: 14866

maximum number of users

In order to limit user resources, I tend to create a new db user on each registration. The thing is, there can be millions of users signing up. And I have no idea about the maximum number of database users that can be created on MySQL.

How many users can be created on MySQL?

Upvotes: 3

Views: 4517

Answers (1)

Madona wambua
Madona wambua

Reputation: 1428

There are no hard coded limitations to number of users in a MySQL database. User accounts are stored in tables in terms of rows and columns that consume some variable amount of memory and disk space. Although you could in theory add an infinite number of users, you will hit resource boundaries such as disk space, memory use, and processing time to add new users will take too long.

The exact limit depends on the configuration settings of the MySQL database.

Upvotes: 6

Related Questions