Where is my.cnf

On a Linux system 'locate my. I get -bash: locate: command not found This assumes that your locatedb has been updated since the my. Usually this is done daily via cron. If you need to update it manually run "updatedb" as root — ckliborn. JayRizzo 5 5 bronze badges. Updated my answer. Please try again!!! How did you install MySQL and on what platform? Sven Sven I didn't install it, it's on a machine that's a few years old. It's on Linux mars 2. Nils Nils 7, 3 3 gold badges 29 29 silver badges 71 71 bronze badges.

How are you sure that your cnf file is not being read? Have you restarted mysqld since the change? If an option file contains! For inclusion directives to work, the file path should not be specified within quotes and should have no escape sequences.

For example, the following statements provided in my. On Windows, if! Using Options on the Command Line. Using Options to Set Program Variables. Command Options for Connecting to the Server. Connection Transport Protocols. Connection Compression Control. Setting Environment Variables. Server and Server-Startup Programs. Installation-Related Programs. Administrative and Utility Programs.

Other myisamchk Options. Obtaining Table Information with myisamchk. Specifying the mysqlbinlog Server ID. Program Development Utilities. InnoDB Cluster. InnoDB ReplicaSet. Error Messages and Common Problems. MySQL 8. Table 4. The file specified with --defaults-extra-file , if any.

It doesn't tell you which on the mysqld process found and opened. Also running a find over the entire file system will usually generate scads of "Permission denied" errors unless you are root. Show 1 more comment. You can use : locate my. Satish Sharma Satish Sharma 3, 9 9 gold badges 34 34 silver badges 48 48 bronze badges. And updatedb to update the list locate goes through - if my.

Why is this not the answer? I know I am late to the party - but what if my. Chuck Ross Chuck Ross 2 2 silver badges 2 2 bronze badges. Example MySQL config file for large systems. MySQL programs look for option files in a set of locations which depend on the deployment platform. You can copy this option file to one of those locations.

If you want to know which options a program supports, run the program with the "--help" option. This can be a security enhancement, if all processes that need to connect to mysqld run on the same host. All interaction with mysqld must be made via Unix sockets or named pipes. Note that using this option without enabling named pipes on Windows via the "enable-named-pipe" option will render mysqld useless! However, in case you choose this method, then start replication for the first time even unsuccessfully, for example if you mistyped the password in master-password and the slave fails to connect , the slave will create a master.

Ranaivo Ranaivo 1, 12 12 silver badges 6 6 bronze badges. Matt Sanders Matt Sanders 5, 1 1 gold badge 28 28 silver badges 38 38 bronze badges. But I do not find the.

Smith Smith 7 7 silver badges 8 8 bronze badges. If you want to change mysql configuration in ubuntu Buhake Sindi Buhake Sindi 84k 27 27 gold badges silver badges bronze badges. Try running mysqld --help --verbose grep my. Abram Abram That is the output I receive but that appears to have no relation to the running instance.

None of those files exist. New Alexandria New Alexandria 6, 4 4 gold badges 51 51 silver badges 72 72 bronze badges. You can also run this command. Found mine using mysqld --help --verbose grep my. Noel Swanson Noel Swanson 1 1 silver badge 4 4 bronze badges.

The supported option prefixes are:. If an option is not explicitly set, then the server or client will simply use the default value for that option. For a list of options that can be set for MariaDB Server, see the list of options available for mysqld. Most of the server system variables can also be set in MariaDB's option file.

See the specific page for each client program to determine what options are available for that program. On older releases, you would have also found the following option files:. However, these option files are now very dated for modern servers, so they were removed in MariaDB You can copy one of these sample MariaDB option files and use it as the basis for building your server's primary MariaDB option file.

Knowledge Base Contact Login Search. Option Description --print-defaults Read options from option files, print all option values, and then exit the program. This is useful for options like socket and port, which is common between the server and the clients.

For example, [mysqld For example, [mariadb Available starting with MariaDB For example, [mariadbd In MariaDB When using one of these builds, options from this option group are read even if the Galera Cluster functionality is not enabled. For example, mysqldump. Option Prefix Description autoset Sets the option value automatically.

Only supported for certain options.