I am getting this error while fetching data from mysql

[Anonymous]

Failed to update data source credentials: MySQL: Too many connectionsHide details

Activity ID:	450092ad-6880-419d-a4c5-b163d96cb314
Request ID:	d632372f-0b94-aa01-10a9-7bde818b8736
Status code:	400
Time:	Mon Dec 07 2020 17:07:18 GMT+0530 (India Standard Time)
Service version:	13.0.14788.65
Client version:	2011.3.03863-train
Cluster URI:	https://wabi-india-west-redirect.analysis.windows.net/

[amitchandak · Accepted solution]

@Anonymous , This mean there are many connection to database. In can of mysql you can increase max connection in config file or Setting given in RDS

https://dev.mysql.com/doc/refman/8.0/en/too-many-connections.html

[Anonymous]

Hi @Anonymous 

Could you tell me if your problem has been solved? If it is, kindly Accept it as the solution. More people will benefit from it. Or you are still confused about it, please provide me with more details about your problem.

Best Regards,

Rico Zhou

[Anonymous · Accepted solution]

Hi @Anonymous 

In addition to amitchandak's reply, the maximum number of connections threads allowed for the server is contained in the system variable max_connections.

You may refer to the blog as below to change the max_connections parameter (Temporarily) or (Permanently).

Blog: MySQL Error “Too many connections” and how to resolve it

Best Regards,

Rico Zhou

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly. 

[amitchandak · Accepted solution]

@Anonymous , This mean there are many connection to database. In can of mysql you can increase max connection in config file or Setting given in RDS

https://dev.mysql.com/doc/refman/8.0/en/too-many-connections.html