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 ...

    • MySQL Database Backup and Reload

      You will need to remote access to the FactoryWiz server to perform these procedures. NOTE: the password portion askusforthispassword in these commands is not the actual password. You will need the actual password for the root user. Please send an ...

    • 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 ...