Understanding MAX_USER_CONNECTIONS in MySQL
December 20, 2019
2:12 pm
At times, you may want to restrict the number of connections made from a user to the database. This may be necessary to improve performance, reporting, etc. MySQL supports this with the help MAX_USER_CONNECTIONS arrtibute associated with CREATE USER and ALTER USER statements. User creation query: CREATE USER ‘root_user’ IDENTIFIED