Increasing Max MySQL Connections

• Lucas
• February 18, 2012

To increase the maximum number of connections that MySQL allows, you must edit the ‘/etc/my.cnf’ file. Log in to the server as ‘root’, and type the following command: vi /etc/my.cnf There should be a part of the file that looks like the example below: [mysqld] safe-show-database innodb_data_file_path=ibdata1:10M:autoextend datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock   Add the following variable below