To view the contents of the my.cnf file, run the following command.The contents of my.cnf file will look like as shown in the following snapshot.
cat /etc/my.cnf
Note that the content of the my.cnf file might differ depending on the operating system, control panel and several other factors. Furthermore, the lines starting with "#" are comments and they will tell you what these different settings are for.
Edit my.cnf file
To edit the MySQL settings with my.cnf file type the following command.
nano /etc/my.cnf
Find the settings you wish to edit. Say, for example, you want to increase the max_connections limit for MySQL server. Locate max_connections and set your desired value.
max_connections=20
To increase the max_connectionsto 30 change it to the following.
max_connections=30
Enter Ctrl + O to save the settings and Ctrl + X to exit. Restart the MySQL server by typing the following command.
service mysql restart
View MySQL variables
Type the following command to view MySQL variables. The MySQL variables will look like as shown in the following snapshot.
mysqladmin variables
