Last answered:

05 Dec 2022

Posted on:

04 Dec 2022

2

What's the default max_connections for Mysql workbench???

Hey!!! as suggested in the lecture changes my max_connection to 1 and wanna set it to default but don't know how or what is default max_connection value so I can reset it back to what it was.
Hope to receive an answer.

1 answers ( 0 marked as helpful)
Instructor
Posted on:

05 Dec 2022

2

Hi Mayank!
Thanks for reaching out.

By default, MySQL 5.5+ can handle up to 151 connections. This number is stored in server variable called max_connections. You can run the following query to check it:
SELECT @@max_connections;

Hope this helps.
Best,
Tsvetelin

Submit an answer