reset password
Author Message
cshah6
Posts: 19
Posted 21:43 Mar 03, 2014 |

I have just created two tables in cs320stu55@cs3 data connection's cs320stu55 database and then I am trying to open my Database connection it will show below error , What should I need to do?

 

 

Attachments:
cysun
Posts: 2935
Posted 21:49 Mar 03, 2014 |

Well, that's the "max_user_connections" error. I restarted the MySQL service so it should work now.

Each CS3 account has a limit of 5 concurrent database connections, so don't open many connections at the same time. In particular, make sure db connections are properly closed in your code (see the HelloJDBC example).

cshah6
Posts: 19
Posted 22:04 Mar 03, 2014 |

Professor,

I have some questions.

1. How can we identify that how many connections right now open?

2. If I am not working with code , I am just only work with MySql workbench , and execute one query at a time in one xyz.sql file then how can I figure out that I am using more than one connections?

cysun
Posts: 2935
Posted 22:06 Mar 03, 2014 |

1. I don't know, but a google search turns up this: http://stackoverflow.com/questions/6502036/how-can-i-see-how-many-mysql-connections-are-open.

2. I think MySQL Workbench only uses one connection.

kevinmowers@yahoo.com
Posts: 49
Posted 00:51 Mar 09, 2014 |

Hi Professor,

I have the "max_user_connections" error as well. I followed the HelloJDBC example. What can I do?

 

RE: Nevermind, it's working again

Thank you!

Last edited by kevinmowers@yahoo.com at 01:14 Mar 09, 2014.