Facebook Twitter Instagram
    TecAdmin
    • Home
    • FeedBack
    • Submit Article
    • About Us
    Facebook Twitter Instagram
    TecAdmin
    You are at:Home»Databases»MySQL»How To Find MySQL my.cnf File Location

    How To Find MySQL my.cnf File Location

    By RahulJune 4, 20221 Min Read

    MySQL configuration file (my.cnf) file location depends on the operating system or installation method. There is no command available to trace this file location on your system. In this tutorial, you will get some default locations of the my.cnf file.

    Advertisement
    • /etc/my.cnf
    • /etc/mysql/my.cnf
    • $MYSQL_HOME/my.cnf
    • [DATADIR]/my.cnf
    • ~/.my.cnf

    In case my.cnf file is available in more than one place, the system load each file and overrides configuration values.

    Share. Facebook Twitter Pinterest LinkedIn Tumblr Email WhatsApp

    Related Posts

    Changing the Default MySQL Data Directory on Ubuntu

    A Comprehensive Guide to Changing the Default MySQL Data Directory on Ubuntu & Debian

    Securing MySQL Database with Limited User Permissions

    Safely Disabling MySQL Replication on Slave Servers: Best Practices and Considerations

    View 2 Comments

    2 Comments

    1. R on March 6, 2017 5:43 pm

      Refer to:

      https://mariadb.com/kb/en/mariadb/configuring-mariadb-with-mycnf/#configuration-syntax-and-groups

      … You can see for each program which configuration files and groups it reads by executing program-name –help –verbose

      sh> mysqld –help –verbose

      Regards

      Reply
    2. R on March 6, 2017 5:22 pm

      Hi,
      I wonder whether the excerpted lines from the output of the following command is system dependent:

      mysqld –help –verbose

      …
      Default options are read from the following files in the given order:
      /etc/my.cnf …

      Reply

    Leave A Reply Cancel Reply

    Advertisement
    Recent Posts
    • A Comprehensive Look at the Simple Mail Transfer Protocol (SMTP)
    • Understanding Basic Git Workflow: Add, Commit, Push
    • The Difference Between Git Reset –soft, –mixed, and –hard
    • Understanding the Staging Area in Git’s Workflow
    • Python Function with Parameters, Return and Data Types
    Facebook Twitter Instagram Pinterest
    © 2023 Tecadmin.net. All Rights Reserved | Terms  | Privacy Policy

    Type above and press Enter to search. Press Esc to cancel.