[MySQL] view MySQL configuration file path and related configuration

[MySQL] view the MySQL configuration file path and related configuration (1) about the configuration file path, sometimes, I found that although I tried to modify some variables in the configuration file, it did not take effect. It was later discovered that the modified file was not the configuration file read by the MySQL server. If you do not know the path of the configuration file currently used by MySQL, you can view it as follows: the server will first read/etc/my. cnf file. If the file does not exist, try to read it from the following paths in sequence. (2) the configuration file configuration item Segment configuration file my. cnf is usually divided into several parts, such as [client], [mysqld], and [mysql. MySQL programs generally read segments with the same name. For example, the server mysqld reads the configuration items under the [mysqld] segment. If the location of the configuration item is incorrect, the configuration will not take effect. (3) for global variables, if you want to view some global variable settings of MySQL, you can view them without logon and permission:

Mysqladmin variables-p

This operation is equivalent to the Command Used for logon.

Show global variables;