How to edit the MySQL my.cnf file

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:

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:

For example, if you want to edit the max_connections, Find the following line:

After editing save the settings and restart MySQL service:

 

 

Leave a Reply

Your email address will not be published. Required fields are marked *