MySQL - Too many connections

Results 1 to 2 of 2
  1. #1
    Member Thewicard is offline
    MemberRank
    Nov 2011 Join Date
    NorwayLocation
    92Posts

    MySQL - Too many connections

    I am getting the Too many connections error in mysql when having above 30-40 online in my hotel, tried to edit max_connections in my.ini to 5000 but that resulted in that mysql refused to start, (it starts fine now)
    How do I increase the number of max_connections or how do I disable the limit?

    I am using IIS 7, Windows Server 2008 R2, MySQL for Windows


  2. #2
    Enthusiast mmdoh8 is offline
    MemberRank
    Jul 2011 Join Date
    44Posts

    Re: MySQL - Too many connections

    Run this query in your mysql database:

    set global max_connections = 500;



Advertisement