Recently i got “too many connections” errors in MySQL, after quick research i found a solution to fix this issue.This issue due to connection limit of my MySQL installation.We can change the max_connections setting to allow more connections.
For windows based systems you can find and set max_connections settings at my.ini file. For example in xampp you can find the file at
c:/xampp/mysql/bin/my.ini.place this line
max_connections = 1000 and restart xampp.
For Linux based systems fallow the below steps :
Locate the file named my.cnf in your server:
find / -name my.cnf
Generally it is stored in the following location:
Edit the file with vim command and find the max_connections string:
Uncomment max_connections and increase the limit to 1000 connections:
max_connections = 1000
Restart mysql service:
I hope you like this Post, Please feel free to comment below, your suggestion and problems if you face - we are here to solve your problems.
I am Arjun from Hyderabad (India). I have been working as a software engineer from the last 7+ years, and it is my passion to learn new things and implement them as a practice. Aside from work, I like gardening and spending time with pets.