Differences

This shows you the differences between two versions of the page.

--- mysql_maxconnections [2015/04/07 08:26] – luke7858
+++ mysql_maxconnections [2024/05/23 07:26] (current) – external edit 127.0.0.1
@@ Line 5: / Line 5: @@
 OR if you log into mysql you can use the following command:
 <sxh bash>
-show variables like 'max_connections'
+show variables like 'max_connections';
 </sxh>
 You should have a similar output:
@@ Line 15: / Line 15: @@
 \\
 ===Option 1 ===
-You can use the following command from your shell (you do not need to log directly into mysql for this if your .my.cnf file has been configured).
+You can use the following command from your shell (you do not need to log directly into mysql for this if your /etc/my.cnf file has been configured).
 <sxh bash>
 mysql -e 'set global max_connections = 200;'
@@ Line 25: / Line 25: @@
 \\
 === Option 2 ===
-Edit the .my.cnf file with the new variable settings for them to be permanent. Add the following code to the file:
+Edit the /etc/my.cnf file with the new variable settings for them to be permanent. Add the following code to the file:
 <sxh bash>
 [mysqld]
 max_connections = 1000
+</sxh>
+\\
+---------------------------------------------------------------
+\\
+=== Setting max user connections ===
+<sxh bash>
+mysql -e 'show variables;' | grep -i max_user_connections
+</sxh>
+\\
+<sxh bash>
+show variables like 'max_user_connections';
 </sxh>