How to Solve MySQL / MariaDB Error 1040 “Too Many Connections”
In this article, I’m going to share how to solve MySQL / MariaDB error 1040 “Too Many Connections”.
Table of Contents
Login to your server and enter this command to login to MySQL/MariaDB client:
mysql -u root -p
Then run this command to see max connections limit:
SHOW VARIABLES LIKE "max_connections";
By default, max connection is 151.
To set new
max_connections value, run this command:
SET GLOBAL max_connections=[new maximum number];
For example, let’s set max connection to 300:
SET GLOBAL max_connections=300;
Open the file
/etc/my.cnf to edit with the command:
sudo nano /etc/my.cnf
[mysqld] section add the following line:
That’s all. Thank you. ?
Preview may take a few seconds to load.
Below you will find some common used markdown syntax. For a deeper dive in Markdown check out this Cheat Sheet
Bold & Italic
Bold **double asterisks**
Three back ticks and then enter your code blocks here.
# This is a Heading 1
## This is a Heading 2
### This is a Heading 3
> type a greater than sign and start typing your quote.
You can add links by adding text inside of  and the link inside of (), like so:
To add a numbered list you can simply start with a number and a ., like so:
1. The first item in my list
For an unordered list, you can add a dash -, like so:
- The start of my list
You can add images by selecting the image icon, which will upload and add an image to the editor, or you can manually add the image by adding an exclamation !, followed by the alt text inside of , and the image URL inside of (), like so:
To add a divider you can add three dashes or three asterisks:
--- or ***