Skip to main content

How to edit the MySQL/MariaDB configuration (my.cnf) file

Alex Jankowiak
  • Updated

Question

How to edit the MySQL/MariaDB configuration (my.cnf) file?

 

Answer

WHM
  1. Login to WHM as the root user.
  2. Access Home / SQL Services / Edit SQL Configuration
  3. Using this tool, change the configuration that you require.
  4. Use the Submit button at the bottom of the page to confirm your changes, and apply the configuration.

Note: Not all options are exposed in this interface, and more advanced MySQL configuration will require direct modification via the command-line.

Command-Line
  1. Login as root using SSH, or the Terminal in WHM.

  2. Edit the /etc/my.cnf file using your preferred command-line editor:

    # nano /etc/my.cnf

  3. After changes have been made, restart the service:

    # /scripts/restartsrv_mysql

Related articles

Comments

0 comments

Article is closed for comments.

%