mysql -u root -p -e "SET GLOBAL max_connections = 200;"

Category: Databases & SQL

mysql -u root -p -e "SET GLOBAL max_connections = 200;"

Raise the connection limit at runtime

Raises max_connections immediately for new connections, but the change is not persisted and reverts on restart. Use SET PERSIST max_connections = 200 to write it to mysqld-auto.cnf as well.
Looking for more? Search all 7,657 commands — works offline, in English or Spanish, and fixes typos.