Is the number of concurrent connections particular to a specific data base?

Question

Is the number of concurrent connections particular to a database or to the whole mysql database server?

Answer 1

The number is whatever you want it to be. However, if you want to limit it, MySQL allows you do it at several levels:

• For the whole server: set the max_connections global variable
• For each user: issue the appropriate GRANT command

See also http://dev.mysql.com/doc/refman/5.1/en/too-many-connections.html