Resolving MySQL 'Too Many Connections' Error

MySQL Too Many Connections

Too Many Connections

We recommend taking a back up of your server beforehand.

Set the following:

You need to create 2 new DWORDS in the Registry.

HKEY_LOCAL_MACHINE\SYSTEM\CurrentControlSet\Services\Tcpip\Parameters
Value Name: MaxUserPort
Data Type: REG_DWORD
Value: 65534

and

Value Name: TcpTimedWaitDelay
Data Type: REG_DWORD
Value: 30

Restart the server for this change to take effect



    • Related Articles

    • 8.3.5 MySQL Console

      MySQL Console FactoryWiz™ Monitoring provides a MySQL command console to access the database directly using T-SQL database commands. FactoryWiz™ recommends that only users with MySQL experience and training be authorized to open this console. To ...

    • Troubleshooting Mazak Native Connections

      This is not for ADAM or MTConnect machines How to check Mazak Native Connections Can you ping the machine IP address? If not, check the IP address in the machine is correct. Check the physical network connection Check the switch is not blocking the ...

    • 8.7.8 Machine Connections

      In order to obtain a license for a machine, you must identify the type of machine you are configuring in the Set Machine Type pane. The type of machine will also determine which settings you are allowed to configure. As you work through the ...

    • 10.2 ODBC Installation

      If you wish to connect a computer on your FactoryWiz network to the FactoryWiz database for things such as Microsoft Excel, you can use an ODBC connector. Normally we will install the 32bit MySQL ODBC Connector for things such as FactoryWizTV ...

    • 11 External Documentation

      FactoryWiz uses multiple external libraries and software packages. Here are links to vendor resources and manuals. · MySQL Database · Adam APAX Utility · Adam APAX Utility Manual · Moxa Device Manager Software · Moxa Nport Manual · Comtrol Manual · ...