wfutan Posted January 16, 2020 Posted January 16, 2020 Hello all, I always got this kind of error when accessing mysql database: java.sql.SQLSyntaxErrorException: User <username> already has more than 'max_user_connections' active connections... I am still newbie and still using Johnny server, is it typical Johnny characteristics or there might be something else I am missing? Any reply/help would be very appreciated, best regards
wolstech Posted January 16, 2020 Posted January 16, 2020 There's a limit of 4 concurrent connections at a time. You can try something like this in your connection string to limit them. Also, be sure to explicitly close your connections when finished with them. jdbc:mysql://localhost:3306/database?max-connections=4
wfutan Posted January 17, 2020 Author Posted January 17, 2020 oh I see, for Tommy server is there any limit or higher limit? any other solution except coding fix, already tried to close/cleanup connections don't know why still happens. thank you for the reply
wolstech Posted January 17, 2020 Posted January 17, 2020 Tommy has no limit at this time, but that's subject to change if someone abuses the mysql server.
wfutan Posted January 17, 2020 Author Posted January 17, 2020 ok thank you. i have just donate with paypal (transaction id 7NX306982J627924V), please move my account to Tommy sir
Flaze Posted January 17, 2020 Posted January 17, 2020 This support request is being escalated to our root admin.
wolstech Posted January 17, 2020 Posted January 17, 2020 Krydos has to do this since it has Java enabled. If I move it, the Java will break and I don't know how to fix that.
wfutan Posted January 18, 2020 Author Posted January 18, 2020 Thanks for your support Krydos, everything is working well now. No Java Wolstech, just jdbc for connection to mysql database. I will setup paypal monthly donation to support the server. You may closed this topic, Solved!
Recommended Posts