I created my phpMyadmin in Windows Azure which only allows 1 MySQL database for free users.

After creating a phpMyAdmin I linked MySQL Database Resources to another Website.

In this website I try to login my accounts registered to the database.

At first it goes smooth and seems there is no problem, but as i try to continue accessing the website which retrieves details from the linked MySQL Database Resources, The website returns and error of..

User 'b48a56f527c793' has exceeded the 'max_user_connections' resource (current value: 4)

But after a while 3-5mins the connection is good again.

At first I think the Windows Azure just tries to limit traffic but is it really that real cause of the problem or did i made mistake in setting up my phpMyAdmin in Windows Azure?

How to fix that error?

Big thanks in advance!

As the error indicates, the issue in this instance is that you've exceeded the number of user connections that are allowed to the database. When using the free account there is a limit of 4 user connections to the database, so if you wanted to increase that I believe you'd need to look at getting a paid subscription instead.

There's some discussion of this here http://social.msdn.microsoft.com/Forums/windowsazure/en-US/3766eee0-9494-41db-8580-6d5f21808369/mysql-size-limitations-and-cost?forum=windowsazurewebsitespreview and here http://stackoverflow.com/questions/13077465/increase-max-user-connections-for-cleardb-mysql-on-windows-azure-website