MySQL max concurrent connections

[MrEyes]

Hello,

At first this may not seem like a programming question, bear with me it will turn into one

I am trying to get my head around the mx concurrent connection limit in MySQL. Is this as the name suggests the maximum concurrent connections that can be made to the database for all db users? Or is it the maximum concurrent connections that can be made to the database for a single db user?

As an example lets say I have a the MyForum database, there are 3 DB access acounts, acc1, acc2, acc3. Now lets say that the max concurrent connections limit is 10. So if acc1 has 7 connections open and acc2 has 3 connections open can acc3 make a connection?

The reason I ask is that my current hosting is causing me no end of grief with their low connection cap, and I am looking for a way to get around it.

Now this is where it turns into a programming, question...

It the connections are per user and not per server, then I can create a hack in VB that rather than use a single DB account it uses multiple. So rather than have this in the config:

$config['MasterServer']['username'] = 'acc1';

I would have:

$config['MasterServer'][0]['username'] = 'acc1';
$config['MasterServer'][1]['username'] = 'acc2';
$config['MasterServer'][2]['username'] = 'acc3';

Then I would hack the database access component of VB to randomly select one of these accounts.

So the questions are, how exactly does max concurrent connections work in MySQL and does VB use a single class/php function for DB access?