If you have your VPS or Dedicated server, you can manage your MySQL settings into my.cnf file.This article will explain the steps to view and edit your my.cnf file.
1- To view your MySQL settings into my.cnf file:
Login to your server via ssh
To view the settings run the following command:
cat /etc/my.cnf
The content of my.cnf file will be displayed.
2- To edit MySQL my.cnf file:
login to your server via SSH
To edit the settings type the following command:
nano /etc/my.cnf
For example, if you want to edit the max_connections, Find the following line:
max_connections=100
After editing save the settings and restart MySQL service:
service mysql restart