Shulou(Shulou.com)06/01 Report--

How to view the path of MySQL profile and related configuration? This problem may be often seen in our daily study or work. I hope you can gain a lot from this question. The following is the reference content that the editor brings to you, let's take a look at it!

(1) about the configuration file path

Sometimes, I find that although I try to change some variables in the configuration file, it doesn't work. It turned out later that the modified file was not a configuration file read by the MySQL server.

If you are not clear about the configuration file path currently used by MySQL, you can try to view it like this:

As you can see from the figure above, the server first reads the / etc/my.cnf file, and if it doesn't exist, it tries to read it from the next few paths in turn.

(2) about profile configuration item segmentation

The configuration file my.cnf is usually divided into several parts, such as [client], [mysqld], [mysql], and so on. MySQL programs usually read fragments with the same name, for example, the server mysqld usually reads the relevant configuration items under the [mysqld] segment. If the configuration item is not located correctly, the configuration will not take effect. Detailed documentation I think you can refer to this article: my.cnf detailed explanation.

(3) about global variables

In addition, if you want to view some global variable settings for MySQL, you can view it like this if you are not logged in and have permissions: mysqladmin variables-p

This operation is also equivalent to using the command show global variables when logging in.

Thank you for reading! After reading the above, do you have a general idea of how to view the path of the MySQL configuration file and related configurations? I hope the content of the article will be helpful to all of you. If you want to know more about the relevant articles, you are welcome to follow the industry information channel.

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.