Results 1 to 2 of 2
  1. #1

    Limit concurrent users in MySQL

    I try to search and not found the solutions to limit concurrent of db users to connect to MySQL in same time for example:

    Limit user root to connect to MySQL maximum 5 connections in same time

    There have max_connections setting but it limit for all users in all connection to MySQL.

    But I found that in version 4.1.x there have max_connections property in user table (Users and global privileges) of mysql database, this setting is limit connection in 60 minutes.

    I would like to know if there any setting or code modify for this solution that I want.

  2. #2
    Join Date
    Oct 2004
    Location
    Kerala, India
    Posts
    4,750
    Set the value as below in /etc/my.cnf file and restart mysql.

    set-variable = max_user_connections=5
    David | www.cliffsupport.com
    Affordable Server Management Solutions sales AT cliffsupport DOT com
    CliffWebManager | Access WHM from iPhone and Android

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •