Contents
Where do I Find my CNF in MySQL?
You can actually ask MySQL to show you the list of all locations where it searches for my.cnf (or my.ini on Windows). It is not an SQL command though. Rather, execute: In the very first lines you will find a message with a list of all my.cnf locations it looks for.
How to determine which MySQL configuration file is being used?
If you run mysql –verbose –help | less it will tell you about line 11 which .cnf files it will look for. You can also do mysql –print-defaults to show you how the configuration values it will use. This can also be useful in identifying just which config file it is loading. Is this answer outdated?
How is mysqld multi used in production servers?
It is more usual to see mysqld_multi being used in production servers: It’s provided with the server package and uses the same single configuration file that people are used to looking for when setting up MySQL. So, how does it work? How do we configure and manage the instances?
Is there a tool to run multiple instances of MySQL?
Yet from time to time the Percona Supportteam receives a request from a customer to assist in the configuration of such an environment. MySQL provides a tool to facilitate the execution of multiple instances called mysqld_multi:
Where do I find MySQL configuration file in Windows?
How to find the mySQL configuration file “my.cnf”. The mySql file can be found in multiple default locations and under various names. e.g. C:\\Windows\\my.ini, C:\\Windows\\my.cnf, C:\\my.ini, C:\\my.cnf,
How to enable binary logging in MySQL 5.6?
Within the [mysqld] section of the configuration file, add the log-bin and server-id options. If these options already exist, but are commented out, uncomment the options and alter them according to your needs. For example, to enable binary logging using a log file name prefix of mysql-bin, and configure a server ID of 1, use these lines:
How does MySQL _ config _ editor obfuscates mylogin.cnf file in memory?
mysql_config_editor obfuscates the .mylogin.cnf file so it cannot be read as cleartext, and its contents when unobfuscated by client programs are used only in memory. In this way, passwords can be stored in a file in non-cleartext format and used later without ever needing to be exposed on the command line or in an environment variable.
When to use set command with MySQL _ config _ editor?
When you use the set command with mysql_config_editor to create a login path, you need not specify all possible option values (host name, user name, password, port, socket). Only those values given are written to the path.